August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: |
create or replace view mailing_list as select decode(gender,‘M’,‘Mr.’,‘F’,‘Ms.’)||first_name||’‘||last_name name, street, city, state from employee; |
| A2: |
create or replace view employee_wages as select fk_department, last_name, first_name, city, wages from employee where fk_department = ‘WEL’ with check option; update employee_wages set fk_department = ‘INT’ where city = ‘PLAINS’; |