ALL_EMPLOYEES_BY_DEPARTMENT


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   ALL_EMPLOYEES_BY_DEPARTMENT   

Name
DEPT_NAME
EMP_FNAME
EMP_ID
EMP_LNAME
PHONE

CREATE VIEW ALL_EMPLOYEES_BY_DEPARTMENT (emp_id, emp_lname, emp_fname, phone, dept_name)
	AS SELECT 
			ALL_EMPLOYEES.emp_id,
			ALL_EMPLOYEES.emp_fname,
			ALL_EMPLOYEES.emp_lname,
			ALL_EMPLOYEES.phone,
			dep.dept_name
		FROM
			ALL_DEPARTMENTS dep,
			ALL_EMPLOYEES
		WHERE 
			ALL_EMPLOYEES.dept_id = dep.dept_id



     
Name Types Description
<DEFAULT SCHEMA>.ALL_DEPARTMENTS View View
<DEFAULT SCHEMA>.ALL_EMPLOYEES View View
<DEFAULT SCHEMA>.ALL_DEPARTMENTS.DEPT_ID Column View column
<DEFAULT SCHEMA>.ALL_DEPARTMENTS.DEPT_NAME Column View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_FNAME Column View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_ID Column View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.EMP_LNAME Column View column
<DEFAULT SCHEMA>.ALL_EMPLOYEES.PHONE Column View column
<DEFAULT SCHEMA>.EMPLOYEE.DEPT_ID Foreign Key Column

     
Name Types Description
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS View View
<DEFAULT SCHEMA>.ALL_EMPLOYEES_DETAILS.Select Select Statement SELECT empByDep.emp_id, empByDep.emp_fname, empByDep.emp_lname, empByDep.phone, empB