Yurttas/PL/DBL/oracle/F/01/Bank/u08.sql

 1REM
 2REM u08.sql
 3REM
 4REM Suppose that we want to provide all loan customers in the
 5REM `Perryridge' branch with a $200 savings account.(Let the
 6REM loannumber serve as the accountnumber for the new savings account.)
 7REM
 8
 9INSERT INTO Depositor
10  SELECT branchname, loannumber, customername, 200
11  FROM Borrower
12  WHERE branchname = 'Perryridge';