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;