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

From ZCubes Wiki
Revision as of 22:51, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div"> REM REM u07.sql REM REM Insert that `Smith' has $1200 in account 9732 at the `Perryridge' REM branch. REM INSERT I...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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);