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