testoag

Top 35 SQL Interview Question asked in Oracle Apps R12 Technical Interview  or  SQL TOP 35 Frequently asked question in Technical Interview       Frequently asked Technical (SQL) question in Oracle apps r12 -: 1.    To find EVEN NUMBER select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) from emp); 2.    To find EVEN NUMBER select * from emp where rowid in (select decode(mod(rownum,2),0,null ,rowid) from emp); 3.    To find the 5th MAX salary select distinct sal from emp e1 where 5 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal); 4.    To find the 9th MIN salary in the emp table. select distinct sal from emp e1 where 9 = (select count(distinct sal) from emp e2 where e1.sal >= e2.sal); 5.    How can we use Rownum function/How can get output for first 10-row output select * from emp where rownum <= &Enter_row_num; 6.    How can get output for Las...

Definition of Lookup in Oracle Apps R12 Or What is Lookup in Oracle Apps R12? Or What is the main purpose of lookups in Oracle Apps R12? The main purpose of a lookup is to keep programs flexible and easier to configure. Lookups are an approach of creating a configurable “list of values” in E-Business Suite. One of the simplest examples of a lookup type is gender. A “gender lookup” will have definitions as shown next: Code       Meaning M             Male F              Female U             Unknown Suppose that there is a table for employees named PER_ALL_PEOPLE_F and it has the following columns: FIRST_NAME LAST_NAME DATE_OF_BIRTH GENDER The screen that displays an employee’s gender will display a value of Male, Female, or Unknown. However, the database column PER_ALL_PEOPLE_F table. GENDER will store a value of M, F, or U. Hence, the screen displays the meaning, whereas the dat...

What are the differences between system, extensible, and user lookup types in Oracle Apps R12? OR Type of Lookups in Oracle Apps R12 User Updating of the start date, end date, and enabled fields are allowed Deletion of codes is allowed Updating of the tag is allowed Insertion of new codes is allowed Extensible Insertion of new codes is allowed Updating of the start date, end date, enabled fields, and the tag is allowed  only  if the code is not 'seed data' Deletion of codes is allowed  only  if the code is not 'seed data' Updating of the module is  not  allowed Deletion of lookup type is  not  allowed System Insertion of new codes is  not  allowed Updating of the start date, end date, and enabled fields are  not  allowed Deletion of codes is  not  allowed Updating of the tag is  not  allowed Updating of the module is  not  allowed Deletion of lookup type is  not  allowed For more detail...