Oracle Apps Interview Questions

Oracle Apps Interview Questions › Category: SQL
Filter:AllOpenResolvedClosedUnanswered
How to display 9th record from EMP table?
ResolvedQuestions Master asked 9 years ago • 
14233 views1 answers0 votes
How to display the employee name and annual salary for all employees including commission?
ResolvedQuestions Master asked 9 years ago • 
12633 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 9 years ago • 
4941 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 9 years ago • 
13977 views1 answers0 votes
How to display the names of employees whose names have second alphabet A in their names?
ResolvedQuestions Master asked 9 years ago • 
8057 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 9 years ago • 
11769 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 9 years ago • 
3938 views1 answers0 votes
How to display the names of the employees who earn highest salary in their respective departments?
ResolvedQuestions Master asked 9 years ago • 
22156 views1 answers0 votes
How to display the Job groups having total salary greater than the maximum salary for managers?
ResolvedQuestions Master asked 9 years ago • 
7223 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 9 years ago • 
4184 views1 answers0 votes
How to display those employees who are working in the same dept where his manager is work?
ResolvedQuestions Master asked 9 years ago • 
9101 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 9 years ago • 
5284 views1 answers0 votes
Why does NULL = NULL Fail in SQL statements?
ResolvedQuestions Master asked 10 years ago • 
2333 views1 answers0 votes
Why ROWNUM =(> 1) will not work ?
ResolvedQuestions Master asked 9 years ago • 
11777 views1 answers0 votes
What is the difference between TRUNCATE and DELETE commands
OpenQuestions Master asked 10 years ago • 
3136 views1 answers0 votes
12