Yurttas/PL/DBL/oracle/F/01/Bank/u08.sql
Jump to navigation
Jump to search
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';