Ejercicios De Oracle

ADM. Y PROG. BASE DE DATO - ORACLE
PRACTICE 1 MAE. Enrique Salazar Meza

PRACTICE 1 1. Show the structure of the EMP table. 2. Create a query to display the name, job, hire date and employeenumber for each employee, with employee number appearing first. Name the column headings Emp #, Employee, Job, and Hire Date, respectively. 3. Create a query to display unique departments from the EMPtable. 4. Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE_OUTPUT. 5. Write a script file to display the employee name, job, and hire datefor all employees who started between a given range. Concatenate the name and job together, separated by a space and comma, and label the column Employees. Prompt the user for the two ranges using theACCEPT command. 6. Create a query to display the name and salary of employees whose salary is not in the range of $1500 and $2850. 7. Display the employee name, job and start date of employees hiredbetween February 20, 1981, and May 1, 1981. Order the query in ascending order by start date. 8. Display the employee name and department number of all employees in departments 10 and 30 in alphabeticalorder by name. 9. Display the name and hire date of every employee who has hired in 1982. 10. Display the name and job title of all employees who do not have a manager. 11. Display the name, salaryand commission for all employees who earn commissions. Sort data in descending order of salary and commissions. 12. Display the names of all employees where the third letter of their name is an A. 13.Display the name of all employees who have two Ls in their name and are in department 30 or their manager is 7782. 14. Display the name, job and salary for all employees whose job is Clerk or Analyst,and their salary is not equal to $1000, $3000 or $5000. 15. Display the name, salary and commission for all employees whose commission amount is greater than their salary increased by 10%....