Yurttas/PL/DBL/oracle/F/01/Company-A/WorksOn-ins.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM WorksOn-ins.sql
 4REM
 5REM
 6
 7INSERT INTO WorksOn
 8  VALUES ('123456789', '1', 32.5);
 9
10INSERT INTO WorksOn
11  VALUES ('123456789', '2', 7.5);
12
13INSERT INTO WorksOn
14  VALUES ('666884444', '3', 40.0);
15
16INSERT INTO WorksOn
17  VALUES ('453453453', '1', 20.0);
18
19INSERT INTO WorksOn
20  VALUES ('453453453', '2', 20.0);
21
22INSERT INTO WorksOn
23  VALUES ('333445555', '2', 10.0);
24
25INSERT INTO WorksOn
26  VALUES ('333445555', '3', 10.0);
27
28INSERT INTO WorksOn
29  VALUES ('333445555', '10', 10.0);
30
31INSERT INTO WorksOn
32  VALUES ('333445555', '20', 10.0);
33
34INSERT INTO WorksOn
35  VALUES ('999887777', '30', 30.0);
36
37INSERT INTO WorksOn
38  VALUES ('999887777', '10', 10.0);
39
40INSERT INTO WorksOn
41  VALUES ('987987987', '10', 35.0);
42
43INSERT INTO WorksOn
44  VALUES ('987987987', '30', 5.0);
45
46INSERT INTO WorksOn
47  VALUES ('987654321', '30', 20.0);
48
49INSERT INTO WorksOn
50  VALUES ('987654321', '20', 15.0);
51
52INSERT INTO WorksOn
53  VALUES ('888665555', '20', 10.0);