Yurttas/PL/DBL/oracle/F/01/Bank/v01.sql
1REM
2REM v01.sql
3REM
4REM Consider a view consisting of branch names and the names of
5REM customers.
6REM
7
8CREATE VIEW AllCustomer
9 AS (SELECT branchname, customername
10 FROM Depositor)
11 UNION
12 (SELECT branchname, customername
13 FROM Borrower);
14
15SELECT *
16FROM AllCustomer;