Yurttas/PL/DBL/oracle/F/02/Bank/Branch-ins.sp

From ZCubes Wiki
Jump to navigation Jump to search
 1DECLARE
 2
 3BEGIN
 4
 5INSERT INTO Branch 
 6  VALUES ('Downtown', 9000000, 'Brooklyn');
 7
 8INSERT INTO Branch 
 9  VALUES ('Redwood', 2100000, 'Palo Alto');
10
11INSERT INTO Branch 
12  VALUES ('Perryridge', 1700000, 'Horseneck');
13
14INSERT INTO Branch 
15  VALUES ('Mianus', 400000, 'Horseneck');
16
17INSERT INTO Branch 
18  VALUES ('Round Hill', 8000000, 'Horseneck');
19
20INSERT INTO Branch 
21  VALUES ('Pownal', 300000, 'Bennington');
22
23INSERT INTO Branch 
24  VALUES ('North Town', 3700000, 'Rye');
25
26INSERT INTO Branch 
27  VALUES ('Brighton', 7100000, 'Brooklyn');
28
29END;
30/