OracleAppsDNA

Oracle Apps Interview Questions

Filter:AllOpenResolvedClosedUnanswered
How to display those employees who joined the company before 15 of the month?
ResolvedQuestions Master asked 10 years ago • 
11297 views1 answers0 votes
How to display employee name and his salary whose salary is greater than highest average of department number?
ResolvedQuestions Master asked 10 years ago • 
8961 views1 answers0 votes
How to display those employee whose joining of month and grade is equal?
ResolvedQuestions Master asked 10 years ago • 
5810 views1 answers0 votes
How to display the 10th record of emp table(without using rowid) ?
ResolvedQuestions Master asked 10 years ago • 
9546 views1 answers0 votes
How to display all enames in reverse order? (SMITH:HTIMS)
ResolvedQuestions Master asked 10 years ago • 
6776 views1 answers0 votes
How to display those employee whose joining DATE is available in deptno?
ResolvedQuestions Master asked 10 years ago • 
8141 views1 answers0 votes
How to impose a validation saying that salary cannot be greater 10,000 (note give a name to this constraint)
ResolvedQuestions Master asked 10 years ago • 
6504 views1 answers0 votes
How to Delete the rows of employees who are working in the company for more ?
ResolvedQuestions Master asked 10 years ago • 
6118 views1 answers0 votes
Write a Query to Delete The Repeated Rows from emp table?
ResolvedQuestions Master asked 10 years ago • 
8314 views1 answers0 votes
HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
ResolvedQuestions Master asked 10 years ago • 
13253 views1 answers0 votes
How to display 9th record from EMP table?
ResolvedQuestions Master asked 10 years ago • 
14260 views1 answers0 votes
In outbound interface is der any way to load the data (large data-millions of records) except UTL_FILE package?
ResolvedAnonymous asked 10 years ago • 
1349 views1 answers0 votes
How to display the employee name and annual salary for all employees including commission?
ResolvedQuestions Master asked 10 years ago • 
12658 views1 answers0 votes
How to display the names of all the employees who are working as clerks and drawing a salary more than 3000?
ResolvedQuestions Master asked 10 years ago • 
4952 views1 answers0 votes
How to display the names of the employees who are working in the company for the past 5 years?
ResolvedQuestions Master asked 10 years ago • 
14023 views1 answers0 votes
How to display the names of employees whose names have second alphabet A in their names?
ResolvedQuestions Master asked 10 years ago • 
8084 views1 answers0 votes
How to display name,salary,hra,pf,da,total salary for each employee. The output should be in the order of total salary,hra 15% of salary,da 10% of salary,pf 5% salary,total salary will be(salary+hra+da)-pf?
ResolvedQuestions Master asked 10 years ago • 
11799 views1 answers0 votes
How to display the names of clerks who earn a salary more than the lowest salary of any salesman?
ResolvedQuestions Master asked 10 years ago • 
3950 views1 answers0 votes
How to display the names of the employees who earn highest salary in their respective departments?
ResolvedQuestions Master asked 10 years ago • 
22342 views1 answers0 votes
How to display the Job groups having total salary greater than the maximum salary for managers?
ResolvedQuestions Master asked 10 years ago • 
7247 views1 answers0 votes
How to display employee name, dept name, salary and comm for those sal in between 2000 to 5000 while location is Chicago?
ResolvedQuestions Master asked 10 years ago • 
4196 views1 answers0 votes
How to display those employees who are working in the same dept where his manager is work?
ResolvedQuestions Master asked 10 years ago • 
9111 views1 answers0 votes
How to display grade and employees name for the dept no 10 or 30 but grade is not 4 while joined the company before 31-dec-82?
ResolvedQuestions Master asked 10 years ago • 
5351 views1 answers0 votes
PLSQL Clob Document,showing Numeric or value error in the Notification
OpenAnonymous asked 10 years ago • 
1836 views1 answers0 votes
invoice details in AR AND AP MODULES
OpenAnonymous asked 10 years ago • ,
1659 views1 answers0 votes
what r the major difference between 11i and R12 in PO,AP,AR modules? pls post ur comments
OpenAnonymous asked 10 years ago • 
2024 views0 answers0 votes
What are the two different file extensions that are created by Oracle Reports ?
ResolvedQuestions Master asked 10 years ago • 
1903 views1 answers0 votes
Which API used to get the current application user id ?
ResolvedQuestions Master asked 10 years ago • 
4638 views1 answers0 votes
How to skip a Header record in SQL Loader without modifying control file??
ResolvedQuestions Master asked 10 years ago • 
9295 views1 answers0 votes
What are Modifiers and Qualifiers?
ResolvedQuestions Master asked 10 years ago • 
6751 views1 answers0 votes
Why does NULL = NULL Fail in SQL statements?
ResolvedQuestions Master asked 10 years ago • 
2343 views1 answers0 votes
How different is Alert from a database trigger
ResolvedQuestions Master asked 10 years ago • 
6043 views1 answers0 votes
Is there a limit for number of parameters of a concurrent program??
ResolvedQuestions Master asked 10 years ago • 
4974 views1 answers0 votes
How to findout base path of a Custom Application top only from front end ?
ResolvedQuestions Master asked 10 years ago • 
10371 views1 answers0 votes
When you try to update or delete a record in People screen or some other screens in HR Module, a Window appears with two Options for Update or Corrections. What are they?
ResolvedQuestions Master asked 10 years ago • 
1340 views1 answers0 votes
What are the steps involved in Order to Cash (O2C) life cycle?
OpenQuestions Master asked 10 years ago • 
8482 views1 answers0 votes
Why ROWNUM =(> 1) will not work ?
ResolvedQuestions Master asked 10 years ago • 
11799 views1 answers0 votes
What is IN parameter and OUT parameter in PLSQL?
OpenQuestions Master asked 10 years ago • 
3978 views0 answers0 votes
In seeded XMLP reports we see parameters of concurrent program are defined as variables in package , but why is this followed?
OpenQuestions Master asked 10 years ago • 
1599 views1 answers0 votes
What is a trigger and what is the difference between Row Level and Statement Level trigger??
OpenQuestions Master asked 10 years ago • 
4805 views0 answers0 votes
1…5678
Exit mobile version