View-Using SQL
Does this view create
a problem in the context of the view-using SQL in the last slide?
CREATE VIEW Employees AS
SELECT P.Person_ID
Employee_ID, P.Last_Name, P.First_Name, D.Name Department_Name, M.Full_Name Manager_Name
FROM Persons P, Persons M, Person_Roles R,
Departments D
WHERE P.Mgr_ID = M.Person_ID(+)
AND P.Department_ID
= D.Department_ID(+)
AND P.Person_ID =
R.Person_ID
AND R.Role_Code =
'EMP'
AND SYSDATE BETWEEN
R.Start_Date AND
NVL(R.END_DATE,SYSDATE);