This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
kurs:instead_of_trigger [2010/06/09 15:37] mh |
kurs:instead_of_trigger [2010/06/09 15:39] mh |
||
---|---|---|---|
Line 3: | Line 3: | ||
employee_id, first_name, last_name, salary, department_id | employee_id, first_name, last_name, salary, department_id | ||
from employees | from employees | ||
- | |||
create table my_dep as select | create table my_dep as select | ||
department_id, department_name from departments | department_id, department_name from departments | ||
+ | |||
+ | CREATE OR REPLACE VIEW EMPDEP ( | ||
+ | FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT_NAME) AS | ||
+ | select first_name, last_name, salary, | ||
+ | department_name from my_emp e, my_dep d | ||
+ | where e.department_id = d.department_id | ||
</code> | </code> | ||