Tutorial 5, page 1 Context: jobsEngine: oracle

You can create a view by saying:

CREATE VIEW firstview as
  select distinct empno from empcourse

This view can be accessed by

SELECT * from firstview

It continues to exist for all questions in this tutorial section. To get rid of it use "drop view firstview".

Create a view "secondview" which shows all employees who have an empno less than 5. In order to get a mark for this you must finish the queries with "select * from secondview".

Active SQL index              Next Question

SQL To Be Executed