Oracle Operator - Exercises with Solution

Oracle Operator [14 exercises with solution]

1. Write a query to list the name of all the employees who are working in department number 20.

Click me to see the solution

2. Write a query to list the employees name and total salary of a year and yearly salary is more than $10000.

Click me to see the solution

3. Write a query to list the employees name and salary who?s daily salary is more than $100.

Click me to see the solution

4. Write a query to list the name of all the employees who are not working in department number 20.

Click me to see the solution

5. Write a query to list the name of all the employees who are working as account manager and drawing a salary more than $5000.

Click me to see the solution

6. Write a query to list the names of all the employees who are working as accountant in finance section and drawing a salary less than $20000.

Click me to see the solution

7. Write a query to list the name of all the employees who are working as accountant in finance section and drawing a salary is greater than equal to $5000 and less than equal to $20000.

Click me to see the solution

8. Write a query to list the names, salary of all the employees who are working with a commission package.

Click me to see the solution

9. Write a query to list the name, salary of all the employees where employee first name belongs in a specified list.

Click me to see the solution

10. Write a query to list the first name, last name, Job id of all the employees except "IT_PROG " & " FI_ACCOUNT" in asc order of Salaries.

Click me to see the solution

11. Write a query to list the name (first and last name), hire date of all the employees who joined before or after 2005.

Click me to see the solution

12. Write query to list the name (first and last name), hire date of all the employees who joined on 1-JUL-2006,24-MAR-2007,04-JAN-2008 in ascending order of seniority.

Click me to see the solution

13. Write a query to concatenate first name, last name and job id from employees table in the following format.

Click me to see the solution

14. Write a query to list the employees who are joined in the year between '01-Jan-2004' and '31-Dec-2008'.

Click me to see the solution

More to Come !