The Employee Details View (EMP_DETAILS_VIEW) is included
as part of the HR Schema. This view provides inner joins
between the employees, departments, jobs, locations,
countries, and regions tables.
The definition can be seen in SQLDeveloper by Navigating in
the Connections panel on the left side to your connection and
opening the Views folder. Right click on EMP_DETAILS_VIEW and
choose the SQL tab to see the DDL used to create the view.
The view definition is as follows:
CREATE OR REPLACE VIEW EMP_DETAILS_VIEW (EMPLOYEE_ID, JOB_ID, MANAGER_ID, DEPARTMENT_ID,
LOCATION_ID, COUNTRY_ID, FIRST_NAME, LAST_NAME, SALARY, COMMISSION_PCT, DEPARTMENT_NAME,
JOB_TITLE, CITY, STATE_PROVINCE, COUNTRY_NAME, REGION_NAME) AS
WHERE e.department_id = d.department_id
AND d.location_id = l.location_id
AND l.country_id = c.country_id
AND c.region_id = r.region_id
AND j.job_id = e.job_id
WITH READ ONLY;
Note: the join syntax is the old Oracle form rather than ANSI standard.