oracle_sql练习题（oracle_sql练习题）.docVIP

oracle_sql练习题（oracle_sql练习题） Oracle_SQL exercises 1 1. of all employees in 30. 2. a list of all clerks (CLERK) name, code and department code. 3. to find the higher salary Commission. 4. to find 60% employees salary higher than the Commission. 5. to find all 10 Department Manager (MANAGER) and the 20 Department Clerk (CLERK) in all details. 6. to find all 10 Department Manager (MANAGER), the 20 departments in all staff (CLERK), is not the manager but not the clerk but the salary is greater than or equal to the details of all 2000 employees. 7. find work commission charge different employees. 8. find do not charge commission or the commission charged less than 100 employees. 9. find all employees each month the last third days of employment. 10. to find employment as early as 12 years ago of the employees. 11. to capitalize the first letter display all employee name. 12. shows exactly 5 characters of the employees name. 13. show with R the names of employees. The first three characters of the 14. display all employee names. 15. shows all the employees name, replace all A a 16. shows over 10 years of service life of the employees name and date of employment. 17. shows the details of the staff, sort by name. 18. shows the employees name and date of employment, according to their service life, the old people in the front row. 19. shows all the employees name, job and salary, sorted by the descending order, if the same according to salary ranking. 20. display all employees to join the companys name, year and month by month, date of employment is sorted, if the same month will be the first year of the staff in the front row. 21. shows in a month for 30 days, all employee salaries, ignore the remainder. 22. find (in any year) all staff recruited in February. 23. for each employee, the number of days to join the company. 24. display any location name field contains all employees A name. 25. to date display all staff service life. Answer： One Select ename, job, Mgr, hiredate