sql continuation

18. Create a view called INVOICE_View based on four columns in the INVOICE table.

19

. 19. Using your view INVOICE_View, enter a query to display values for three of the four columns included in the view.

20. Create a view named INV_VIEW_QUERY that does not allow an invoice DESCRIPTION to be changed through the view.

21. Create a sequence to be used with the primary key column of the INVOICE table. The sequence should start at 1000 and have a maximum value of 2000. Have your sequence increment by a single number. Name the sequence INVOICE_SEQ.

22

. Write a script to insert a row into the INVOICE table. Be sure to use the sequence that you created for the primary key column. Create a customized prompt to enter the DESCRIPTION.

23. Create a synonym for the INVOICE table.

24. Write a query to display the three columns of data for all employees with the same MANAGER_ID as Grant.

25.Create a query to display the employee number, last name and hire date for all employees who have a salary greater than the average salary. Sort the results in descending order of salary.

26. Create a report containing the employee name, address, city, and each employee’s salary. Label the columns with a different name than the column name. Break on the individual department numbers.