ALL_MANAGERS_BY_DEPARTEMENT

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_MANAGERS_BY_DEPARTEMENT

Name
DEPTNAME
EMP_FNAME
EMP_ID
EMP_LNAME
NAME
PHONE
STATUS

CREATE VIEW ALL_Managers_by_Departement(emp_id, emp_lname, emp_fname, phone,status,deptName)
	AS SELECT 
			employee.emp_id,
			employee.emp_fname,
			employee.emp_lname,
			employee.phone,
			employee.status,
      AD.DEPT_NAME
		FROM
			EMPLOYEE employee
    INNER JOIN ALL_DEPARTMENTS  AD ON AD.Manager_Id = employee.EMP_ID

Name	Types	Description
DERIVEDTABLE	Table	Table
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
<DEFAULT SCHEMA>.ALL_DEPARTMENTS	View	View
<DEFAULT SCHEMA>.ALL_DEPARTMENTS.DEPT_NAME	Column	View column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_FNAME	Column	Column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_LNAME	Column	Column
<DEFAULT SCHEMA>.ALL_DEPARTMENTS.MANAGER_ID	Column	View column
PHONE	Column	Virtual column
STATUS	Column	Virtual column
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Name	Types	Description
<DEFAULT SCHEMA>.ALL_MANAGERS	View	View
<DEFAULT SCHEMA>.ALL_MANAGERS.Select	Select Statement	SELECT AMD.emp_id, AMD.emp_fname, AMD.emp_lname, AMD.phone,