Yurttas/PL/DBL/oracle/F/02/Bank/Branch-ins.sp
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/