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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM u07.sql
 3REM
 4REM Insert that `Smith' has $1200 in account 9732 at the `Perryridge'
 5REM   branch.
 6REM
 7
 8INSERT INTO Depositor
 9  VALUES ('Perryridge', 9732, 'Smith', 1200);
10
11REM or
12REM INSERT INTO Depositor
13REM     (branchname, accountnumber, customername, balance)
14REM   VALUES ('Perryridge', 9989, 'Smith', 1200);
15
16REM or
17REM INSERT INTO Depositor
18REM     (accountnumber, customername, branchname, balance)
19REM   VALUES (9990, 'Smith', 'Perryridge', 1200);