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

From ZCubes Wiki
Jump to navigation Jump to search
 1DECLARE
 2
 3BEGIN
 4
 5INSERT INTO Borrower 
 6  VALUES ('Downtown', 17, 'Jones', 1000);
 7
 8INSERT INTO Borrower 
 9  VALUES ('Redwood', 23, 'Smith', 2000);
10
11INSERT INTO Borrower 
12  VALUES ('Perryridge', 15, 'Hayes', 1500);
13
14INSERT INTO Borrower 
15  VALUES ('Mianus', 93, 'Curry', 500);
16
17INSERT INTO Borrower 
18  VALUES ('Round Hill', 11, 'Turner', 900);
19
20INSERT INTO Borrower 
21  VALUES ('Pownal', 29, 'Williams', 1200);
22
23INSERT INTO Borrower 
24  VALUES ('North Town', 16, 'Adams', 1300);
25
26INSERT INTO Borrower 
27  VALUES ('Downtown', 18, 'Johnson', 2000);
28
29INSERT INTO Borrower 
30  VALUES ('Perryridge', 25, 'Glenn', 2500);
31
32INSERT INTO Borrower 
33  VALUES ('Brighton', 10, 'Brooks', 2200);
34
35END;
36/