Tutorial 5, page 7 Context: jobsEngine: oracle
Modify your query as produced in question 6 so that if the department name is not present ni the view then the department name appears as "UNKNOWN" (in upper case). Use a UNION and not an OUTER JOIN to do this.
Active SQL index Previous Question Next Question

SQL To Be Executed