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

From ZCubes Wiki
Jump to navigation Jump to search
 1DECLARE
 2
 3BEGIN
 4
 5INSERT INTO Customer
 6  VALUES ('Jones', 'Main', 'Harrison');
 7
 8INSERT INTO Customer
 9  VALUES ('Smith', 'North', 'Rye');
10
11INSERT INTO Customer
12  VALUES ('Hayes', 'Main', 'Harrison');
13
14INSERT INTO Customer
15  VALUES ('Curry', 'North', 'Rye');
16
17INSERT INTO Customer
18  VALUES ('Lindsay', 'Park', 'Pittsfield');
19
20INSERT INTO Customer
21  VALUES ('Turner', 'Putnam', 'Stamford');
22
23INSERT INTO Customer
24  VALUES ('Williams', 'Nassau', 'Princeton');
25
26INSERT INTO Customer
27  VALUES ('Adams', 'Spring', 'Pittsfield');
28
29INSERT INTO Customer
30  VALUES ('Johnson', 'Alma', 'Palo Alto');
31
32INSERT INTO Customer
33  VALUES ('Glenn', 'Sand Hill', 'Woodside');
34
35INSERT INTO Customer
36  VALUES ('Brooks', 'Senator', 'Brooklyn');
37
38INSERT INTO Customer
39  VALUES ('Green', 'Walnut', 'Stamford');
40
41END;
42/