Oracle Apps Interview Questions

Oracle Apps Interview Questions › Category: SQL
Filter:AllOpenResolvedClosedUnanswered
How to display 9th record from EMP table?
ResolvedQuestions Master asked 12 years ago • 
15887 views1 answers0 votes
How to display the employee name and annual salary for all employees including commission?
ResolvedQuestions Master asked 12 years ago • 
13927 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 12 years ago • 
6143 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 12 years ago • 
15587 views1 answers0 votes
How to display the names of employees whose names have second alphabet A in their names?
ResolvedQuestions Master asked 12 years ago • 
9281 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 12 years ago • 
12648 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 12 years ago • 
5005 views1 answers0 votes
How to display the names of the employees who earn highest salary in their respective departments?
ResolvedQuestions Master asked 12 years ago • 
25571 views1 answers0 votes
How to display the Job groups having total salary greater than the maximum salary for managers?
ResolvedQuestions Master asked 12 years ago • 
8521 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 12 years ago • 
5308 views1 answers0 votes
How to display those employees who are working in the same dept where his manager is work?
ResolvedQuestions Master asked 12 years ago • 
10231 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 12 years ago • 
7923 views1 answers0 votes
Why does NULL = NULL Fail in SQL statements?
ResolvedQuestions Master asked 12 years ago • 
3340 views1 answers0 votes
Why ROWNUM =(> 1) will not work ?
ResolvedQuestions Master asked 12 years ago • 
13306 views1 answers0 votes
What is the difference between TRUNCATE and DELETE commands
OpenQuestions Master asked 12 years ago • 
4329 views1 answers0 votes
12