Tutorial 5, page 5 Context: jobsEngine: oracle
Create a view which is identical to department except it only contains departments whose HEAD is equal to the empno of an employee with a surname "Jones". Run a "select * from viewname" to confirm this.
Active SQL index Previous Question Next Question

SQL To Be Executed