Oracle to DB2 UDB Conversion Guide2003

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;