| < Day Day Up > |
|
There are two views in the ORA_EMP database:
CREATE VIEW employees_offices (dept_code, acct_id, building, office_id) AS SELECT dept_code, acct_id, building, offices.office_id FROM offices, employees WHERE offices.office_id = employees.office_id; REATE VIEW office_summary (building, total_seats) AS SELECT building, sum(number_seats) total_seats FROM offices GROUP BY building;
| < Day Day Up > |
|