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 |