Oracle Apps Interview Questions

Oracle Apps Interview Questions › Category: SQL
Filter:AllOpenResolvedClosedUnanswered
Lets say there is a table with 500 rows. Write a query to display rows from 101 to 500.
ResolvedAnonymous asked 9 years ago • 
2906 views0 answers0 votes
Query to find records inserted in last 2 hours
ResolvedAnonymous asked 9 years ago • 
14599 views0 answers0 votes
What is the different between Analytic and Group function in SQL?
ResolvedQuestions Master asked 9 years ago • 
4483 views0 answers0 votes
How to find SQL statements which takes more time to run on Database?
ResolvedQuestions Master asked 9 years ago • 
2979 views0 answers0 votes
What is Referential Integrity?
ResolvedQuestions Master asked 9 years ago • ,
4693 views0 answers0 votes
What is Global Temporary Tables and What is it Purpose?
ResolvedQuestions Master asked 9 years ago • ,
5150 views0 answers0 votes
How to sort a VARCHAR2 field as a Numeric field in SQL?
ResolvedQuestions Master asked 9 years ago • 
2499 views0 answers0 votes
What is the Difference between an Empty String and a NULL value?
ResolvedQuestions Master asked 9 years ago • 
2560 views0 answers0 votes
How would you convert date into Julian date format in Oracle SQL?
ResolvedQuestions Master asked 9 years ago • 
2606 views0 answers0 votes
Can we use a WHERE clause in TRUNCATE statement?
ResolvedQuestions Master asked 9 years ago • 
5227 views1 answers0 votes
How to display the employee number and name for employee working as clerk and earning highest salary among clerks?
ResolvedQuestions Master asked 9 years ago • 
4998 views1 answers0 votes
How to display all employees name,job,salary,grade and depart name for every one in the company except ‘CLERK’.Sort on salary display the highest salary?
ResolvedQuestions Master asked 9 years ago • 
3142 views1 answers0 votes
How to find out the top 5 earners of company based on emp dept table?
ResolvedQuestions Master asked 9 years ago • 
4946 views1 answers0 votes
How to display dname where at least 3 are working and display only department name?
ResolvedQuestions Master asked 9 years ago • 
4655 views1 answers0 votes
How to display those managers name whose salary is more than average salary of his employee?
ResolvedQuestions Master asked 9 years ago • 
6580 views1 answers0 votes
How to display employee name, sal, comm and net pay for those employee whose net pay is greater than or equal to any other employee salary of the company?
ResolvedQuestions Master asked 9 years ago • 
5234 views1 answers0 votes
How to find out last 5 (least) earners of the company.?
ResolvedQuestions Master asked 9 years ago • 
7112 views1 answers0 votes
How to display those employee whose salary is ODD value?
ResolvedQuestions Master asked 9 years ago • 
9000 views1 answers0 votes
How to display those employee who joined in the company in the month of Dec?
ResolvedQuestions Master asked 9 years ago • 
11102 views1 answers0 votes
How to display those employee whose 10% of salary is equal to the year of joining?
ResolvedQuestions Master asked 9 years ago • 
5985 views1 answers0 votes
How to display those employees who joined the company before 15 of the month?
ResolvedQuestions Master asked 9 years ago • 
11265 views1 answers0 votes
How to display employee name and his salary whose salary is greater than highest average of department number?
ResolvedQuestions Master asked 9 years ago • 
8935 views1 answers0 votes
How to display those employee whose joining of month and grade is equal?
ResolvedQuestions Master asked 9 years ago • 
5793 views1 answers0 votes
How to display the 10th record of emp table(without using rowid) ?
ResolvedQuestions Master asked 9 years ago • 
9517 views1 answers0 votes
How to display all enames in reverse order? (SMITH:HTIMS)
ResolvedQuestions Master asked 9 years ago • 
6759 views1 answers0 votes
How to display those employee whose joining DATE is available in deptno?
ResolvedQuestions Master asked 9 years ago • 
8110 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 9 years ago • 
6487 views1 answers0 votes
How to Delete the rows of employees who are working in the company for more ?
ResolvedQuestions Master asked 9 years ago • 
6104 views1 answers0 votes
Write a Query to Delete The Repeated Rows from emp table?
ResolvedQuestions Master asked 9 years ago • 
8291 views1 answers0 votes
HOW TO DISPLAY 5 TO 7 ROWS FROM A TABLE?
ResolvedQuestions Master asked 9 years ago • 
13224 views1 answers0 votes
How to display 9th record from EMP table?
ResolvedQuestions Master asked 9 years ago • 
14231 views1 answers0 votes
How to display the employee name and annual salary for all employees including commission?
ResolvedQuestions Master asked 9 years ago • 
12629 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 • 
4939 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 • 
13974 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 • 
8051 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 • 
11760 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 • 
3937 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 • 
22155 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 • 
7221 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 • 
4183 views1 answers0 votes
12