HR

Basic Index   Expanded Index

View Name:EMP_DETAILS_VIEW

FieldTypeNulls?
EMPLOYEE_IDNUMBER (6)No
JOB_IDVARCHAR2 (10)No
MANAGER_IDNUMBER (6)Yes
DEPARTMENT_IDNUMBER (4)Yes
LOCATION_IDNUMBER (4)Yes
COUNTRY_IDCHAR (2)Yes
FIRST_NAMENVARCHAR2 (20)Yes
LAST_NAMEVARCHAR2 (25)No
SALARYNUMBER (8, 2)Yes
COMMISSION_PCTNUMBER (2, 2)Yes
DEPARTMENT_NAMEVARCHAR2 (30)No
JOB_TITLEVARCHAR2 (35)No
CITYVARCHAR2 (30)No
STATE_PROVINCEVARCHAR2 (25)Yes
COUNTRY_NAMEVARCHAR2 (40)Yes
REGION_NAMEVARCHAR2 (25)Yes

SELECT
e.employee_id,
e.job_id,
e.manager_id,
e.department_id,
d.location_id,
l.country_id,
e.first_name,
e.last_name,
e.salary,
e.commission_pct,
d.department_name,
j.job_title,
l.city,
l.state_province,
c.country_name,
r.region_name
FROM
employees e,
departments d,
jobs j,
locations l,
countries c,
regions r
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