Difference between revisions of "HR.EMP DETAILS VIEW (view)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view | HR.EMP_DETAILS_VIEW |- |} <pre> </pre>)
 
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''view
+
| '''View
 
| HR.EMP_DETAILS_VIEW
 
| HR.EMP_DETAILS_VIEW
−
|-
 
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
−
 
+
CREATE OR REPLACE VIEW HR.EMP_DETAILS_VIEW AS
 +
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
 
</pre>
 
</pre>

Latest revision as of 10:33, 27 August 2011

wikibot[edit]

View HR.EMP_DETAILS_VIEW

Source[edit]

CREATE OR REPLACE VIEW HR.EMP_DETAILS_VIEW AS 
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
Retrieved from "http://dbshelp.devio.at/index.php?title=HR.EMP_DETAILS_VIEW_(view)&oldid=3047"