-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path03_sample_data_script.sql
More file actions
268 lines (260 loc) · 21 KB
/
Copy path03_sample_data_script.sql
File metadata and controls
268 lines (260 loc) · 21 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
/* Sample data for 'product' */
INSERT ALL
INTO product VALUES (1, 'Red Guitar', 784770785924, 1000, 30.00, 100.39)
INTO product VALUES (2, 'Gray Coat', 622824907658, 1000, 20.00, 110.00)
INTO product VALUES (3, 'Office Chair', 201190716089, 500, 55.00, 100.00)
INTO product VALUES (4, 'White Desk', 888265807754, 1000, 30.00, 190.00)
INTO product VALUES (5, 'Smartphone', 530393190763, 2000, 1300.00, 2000.25)
INTO product VALUES (6, 'Z Painting', 958179282411, 2000, 1200.00, 3000.00)
INTO product VALUES (7, 'HD Tv', 027455110767, 600, 2200.00, 3100.00)
INTO product VALUES (8, 'Dinner Table', 638393812734, 500, 150.00, 230.99)
INTO product VALUES (9, 'Night Table', 187166842345, 2000, 160.00, 230.00)
INTO product VALUES (10, 'Small Laptop', 956057920227, 1200, 300.00, 450.00)
INTO product VALUES (11, 'Black Backpack', 688229941020, 1200, 20.00, 40.44)
INTO product VALUES (12, 'Red Couch', 869904651422, 900, 100.00, 180.00)
INTO product VALUES (13, 'Leather Shoes', 611159247020, 1200, 100.00, 185.00)
INTO product VALUES (14, 'Black Shoes', 658783784227, 1200, 35.00, 70.00)
INTO product VALUES (15, 'Orange Sneakers', 498527656755, 3000, 30.00, 70.00)
INTO product VALUES (16, 'Microwave Oven', 232650865331, 12000, 500.00, 1100.55)
INTO product VALUES (17, 'Blue Sofa', 658268094057, 12000, 300.00, 550.77)
INTO product VALUES (18, 'Bed Frame', 122312730325, 3000, 280.00, 475.88)
INTO product VALUES (19, 'Wireless Keyboard', 880538908783, 3000, 70.00, 120.22)
INTO product VALUES (20, 'Wireless Mouse', 451718961165, 700, 60.00, 150.14)
INTO product VALUES (21, 'Computer Monitor', 714995044151, 2500, 134.00, 275.00)
INTO product VALUES (22, 'Leather Wallet', 518264454761, 2500, 10.00, 40.11)
INTO product VALUES (23, 'Red and Blue Carpet', 078063602224, 2500, 40.00, 90.22)
INTO product VALUES (24, 'Leather Jacket', 246659421676, 800, 75.00, 110.00)
INTO product VALUES (25, 'HD Monitor', 938435628169, 550, 480.00, 680.33)
INTO product VALUES (26, 'Y Laptop', 904541553657, 4100, 500.00, 780.00)
INTO product VALUES (27, 'Tshirts', 057386677294, 4100, 40.00, 70.00)
INTO product VALUES (28, 'Black Guitar', 777841179586, 12000, 800.00, 1200.22)
INTO product VALUES (29, 'Y Painting', 322248986417, 4100, 50.00, 90.11)
INTO product VALUES (30, 'X Laptop', 040885862139, 10000, 1400.00, 1900.11)
SELECT * FROM dual;
/* Sample data for 'region' */
INSERT ALL
INTO region VALUES (1, 'Toronto, Ontario', 'Canada')
INTO region VALUES (2, 'Hamilton, Ontario', 'Canada')
INTO region VALUES (3, 'Barrie, Ontario', 'Canada')
INTO region VALUES (4, 'Mississauga, Ontario', 'Canada')
INTO region VALUES (5, 'Kingston, Ontario', 'Canada')
INTO region VALUES (6, 'Thunder Bay, Ontario', 'Canada')
INTO region VALUES (7, 'Vancouver, British Columbia', 'Canada')
INTO region VALUES (8, 'Victoria, British Columbia', 'Canada')
INTO region VALUES (9, 'Kelowna, British Columbia', 'Canada')
INTO region VALUES (10, 'Kamloops, British Columbia', 'Canada')
INTO region VALUES (11, 'Burnaby, British Columbia', 'Canada')
INTO region VALUES (12, 'Abbotsford, British Columbia', 'Canada')
INTO region VALUES (13, 'Seattle, Washington', 'USA')
INTO region VALUES (14, 'Olympia, Washington', 'USA')
INTO region VALUES (15, 'Miami, Florida', 'USA')
INTO region VALUES (16, 'Tampa, Florida', 'USA')
INTO region VALUES (17, 'Orlando, Florida', 'USA')
INTO region VALUES (18, 'Richmond, Virginia', 'USA')
INTO region VALUES (19, 'Williamsburg, Virginia', 'USA')
INTO region VALUES (20, 'Los Angeles, California', 'USA')
INTO region VALUES (21, 'Sydney, New South Wales', 'Australia')
INTO region VALUES (22, 'Melbourne, Victoria', 'Australia')
INTO region VALUES (23, 'Brisbane, Queensland', 'Australia')
INTO region VALUES (24, 'Perh, Western Australia', 'Australia')
INTO region VALUES (25, 'Adelaide, South Australia', 'Australia')
INTO region VALUES (26, 'London', 'UK')
INTO region VALUES (27, 'Bristol', 'UK')
INTO region VALUES (28, 'Manchester', 'UK')
INTO region VALUES (29, 'York', 'UK')
INTO region VALUES (30, 'Liverpool', 'UK')
SELECT * FROM dual;
/* Sample data for 'status' */
INSERT ALL
INTO status VALUES (1, 'arrived')
INTO status VALUES (2, 'delayed')
INTO status VALUES (3, 'cancelled')
SELECT * FROM dual;
/* Sample data for 'store' */
INSERT ALL
INTO store VALUES (100,1,'123 Alphabet St')
INTO store VALUES (101,2,'456 Number St')
INTO store VALUES (102,3,'789 Binary St')
INTO store VALUES (103,4,'987 Java St')
INTO store VALUES (104,5,'654 Apple St')
INTO store VALUES (105,6,'321 Canada St')
INTO store VALUES (106,7,'111 Creative St')
INTO store VALUES (107,8,'222 Road St')
INTO store VALUES (108,9,'333 Banana St')
INTO store VALUES (109,10,'444 Fruit St')
INTO store VALUES (110,11,'555 Tomato St')
INTO store VALUES (111,12,'666 Soup St')
INTO store VALUES (112,13,'777 Coffee St')
INTO store VALUES (113,14,'888 Dirt St')
INTO store VALUES (114,15,'999 Horse St')
INTO store VALUES (115,16,'1111 Crazy St')
INTO store VALUES (116,17,'2222 Coolie St')
INTO store VALUES (117,18,'3333 Mango St')
INTO store VALUES (118,19,'4444 Snake St')
INTO store VALUES (119,20,'5555 Spider St')
INTO store VALUES (120,21,'6666 Data St')
INTO store VALUES (121,22,'7777 Dream St')
INTO store VALUES (122,23,'8888 Sleep St')
INTO store VALUES (123,24,'9999 Play St')
INTO store VALUES (124,25,'1212 Sheep St')
INTO store VALUES (125,26,'1313 Cow St')
INTO store VALUES (126,27,'1414 Pig St')
INTO store VALUES (127,28,'1515 Fish St')
INTO store VALUES (128,29,'1616 Dog St')
INTO store VALUES (129,30,'1717 Cat St')
SELECT * FROM dual;
/* Sample data for 'employee' */
INSERT ALL
INTO employee VALUES (10029,129,'Johnny','Garrec','CEO',to_date('1990-01-01', 'yyyy-mm-dd'),10029)
INTO employee VALUES (10010,110,'Darry','Johnson','Manager',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10011,111,'Ferry','Deck','Manager',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10000,100,'Emma','Ployee','Cashier',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10001,101,'John','Clark','Cashier',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10002,102,'Stella','Windell','Cashier',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10003,103,'Jacob','Lin','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10004,104,'Bob','Frayee','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10005,105,'Dana','Lee','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10006,106,'Clark','Peele','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10007,107,'Emily','Jameson','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10008,108,'Derek','Maul','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10009,109,'Hassy','Forsee','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10012,112,'Boris','Wesley','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10013,113,'Jack','Rimmington','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10014,114,'Ashe','Lin','Sales',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10015,115,'Patrick','Smith','HR',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10016,116,'Josh','Yang','HR',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10017,117,'Damien','Rock','Delivery',to_date('2022-02-10', 'yyyy-mm-dd'), 10008)
INTO employee VALUES (10018,118,'Benny','Rettel','Delivery',to_date('2022-02-10', 'yyyy-mm-dd'), 10009)
INTO employee VALUES (10019,119,'Maggie','Bathory','Delivery',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10020,120,'Bob','Lee','Delivery',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10021,121,'Harley','Jones','Delivery',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10022,122,'James','Katter','Customer Service',to_date('2022-02-10', 'yyyy-mm-dd'), 10009)
INTO employee VALUES (10023,123,'Sarah','Bakely','Customer Service',to_date('2022-02-10', 'yyyy-mm-dd'), 10010)
INTO employee VALUES (10024,124,'Smith','Baker','Customer Service',to_date('2022-02-10', 'yyyy-mm-dd'), 10011)
INTO employee VALUES (10025,125,'Gary','Bale','Janitor',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10026,126,'Emily','Placee','Janitor',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10027,127,'Karen','Rollce','Janitor',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
INTO employee VALUES (10028,128,'Jerry','Rocker','Janitor',to_date('2022-02-10', 'yyyy-mm-dd'), 10029)
SELECT * FROM dual;
/* Sample data for 'customer' */
INSERT ALL
INTO customer VALUES (1000,'Tom','Brady',to_date('1990-01-01', 'yyyy-mm-dd'),'123 Pompom St', 10003)
INTO customer VALUES (1001,'Bob','Jones',to_date('1992-02-02', 'yyyy-mm-dd'),'456 Desert St', 10004)
INTO customer VALUES (1002,'Kyle','Brown',to_date('1993-03-03', 'yyyy-mm-dd'),'789 Faraway St', 10005)
INTO customer VALUES (1003,'John','Smith',to_date('1996-04-04', 'yyyy-mm-dd'),'1000 Skate St', 10005)
INTO customer VALUES (1004,'Jane','Doe',to_date('1994-05-05', 'yyyy-mm-dd'),'1100 Angel St', 10006)
INTO customer VALUES (1005,'Carly','Jones',to_date('1964-06-06', 'yyyy-mm-dd'),'1111 Close St', 10006)
INTO customer VALUES (1006,'Jackie','Lin',to_date('1982-07-07', 'yyyy-mm-dd'),'5055 Chihuahua St', 10006)
INTO customer VALUES (1007,'Michael','Jones',to_date('2000-08-08', 'yyyy-mm-dd'),'1234 Dosh St', 10007)
INTO customer VALUES (1008,'Sarah','Lacey',to_date('2004-09-09', 'yyyy-mm-dd'),'5232 Settle St', 10008)
INTO customer VALUES (1009,'Jarvis','Cook',to_date('1976-10-10', 'yyyy-mm-dd'),'6544 St.John St', 10009)
INTO customer VALUES (1010,'Leslie','Leslie',to_date('1940-11-11', 'yyyy-mm-dd'),'1241 Dash St', 10010)
INTO customer VALUES (1011,'Tom','Smith',to_date('1950-12-12', 'yyyy-mm-dd'),'5155 Government St', 10011)
INTO customer VALUES (1012,'Alex','Li',to_date('1991-01-13', 'yyyy-mm-dd'),'5102 Goose St', 10012)
INTO customer VALUES (1013,'May','Boris',to_date('1999-02-14', 'yyyy-mm-dd'),'4424 Orange St', 10013)
INTO customer VALUES (1014,'Donald','Mackenzie',to_date('1999-03-15', 'yyyy-mm-dd'),'4234 Bank St', 10014)
INTO customer VALUES (1015,'Jamie','Lee',to_date('1990-04-16', 'yyyy-mm-dd'),'432 Delivery St', 10003)
INTO customer VALUES (1016,'June','May',to_date('1994-05-17', 'yyyy-mm-dd'),'2212 Imagine St', 10008)
INTO customer VALUES (1017,'Haley','Jones',to_date('1995-06-18', 'yyyy-mm-dd'),'423 Blackwood St', 10008)
INTO customer VALUES (1018,'Josh','Barry',to_date('1996-07-19', 'yyyy-mm-dd'),'4224 White St', 10009)
INTO customer VALUES (1019,'Richard','Nguyen',to_date('1998-08-20', 'yyyy-mm-dd'),'529 Stone St', 10010)
INTO customer VALUES (1020,'Tim','Bassery',to_date('1998-09-21', 'yyyy-mm-dd'),'1234 Lego St', 10011)
INTO customer VALUES (1021,'Larry','Bathy',to_date('1998-10-22', 'yyyy-mm-dd'),'2344 Faraday St', 10012)
INTO customer VALUES (1022,'Tina','Chao',to_date('1991-11-23', 'yyyy-mm-dd'),'1232 Tar St', 10013)
INTO customer VALUES (1023,'Darry','Brak',to_date('2000-12-24', 'yyyy-mm-dd'),'2324 Parry St', 10014)
INTO customer VALUES (1024,'Terry','Jones',to_date('2005-01-25', 'yyyy-mm-dd'),'2454 Legend St', 10014)
INTO customer VALUES (1025,'Carl','Forry',to_date('1994-02-26', 'yyyy-mm-dd'),'1524 Marsh St', 10005)
INTO customer VALUES (1026,'Diana','Fossly',to_date('1986-03-27', 'yyyy-mm-dd'),'582 Dagetz St', 10003)
INTO customer VALUES (1027,'Denise','Johnson',to_date('1976-04-28', 'yyyy-mm-dd'),'9999 Penguin St', 10006)
INTO customer VALUES (1028,'Frank','Smith',to_date('1989-05-29', 'yyyy-mm-dd'),'8874 Donkey St', 10011)
INTO customer VALUES (1029,'Johnathan','Bareto',to_date('1978-06-30', 'yyyy-mm-dd'),'7144 Near St', 10013)
SELECT * FROM dual;
/* Sample data for 'orders' */
INSERT ALL
INTO orders VALUES (20001, to_date('2022-01-06', 'yyyy-mm-dd'), NULL, 100, 1001)
INTO orders VALUES (20002, to_date('2022-01-06', 'yyyy-mm-dd'), NULL, 100, 1002)
INTO orders VALUES (20003, to_date('2022-01-08', 'yyyy-mm-dd'), 'Customer reported damage on goods', 101, 1002)
INTO orders VALUES (20004, to_date('2022-01-09', 'yyyy-mm-dd'), NULL, 101, 1004)
INTO orders VALUES (20005, to_date('2022-01-11', 'yyyy-mm-dd'), 'Customer requested for expedite shipping', 101, 1004)
INTO orders VALUES (20006, to_date('2022-01-11', 'yyyy-mm-dd'), NULL, 103, 1005)
INTO orders VALUES (20007, to_date('2022-01-11', 'yyyy-mm-dd'), NULL, 103, 1006)
INTO orders VALUES (20008, to_date('2022-01-12', 'yyyy-mm-dd'), NULL, 105, 1006)
INTO orders VALUES (20009, to_date('2022-01-14', 'yyyy-mm-dd'), NULL, 105, 1011)
INTO orders VALUES (20010, to_date('2022-01-14', 'yyyy-mm-dd'), 'Customer requested for a replacement', 106, 1012)
INTO orders VALUES (20011, to_date('2022-01-16', 'yyyy-mm-dd'), NULL, 106, 1013)
INTO orders VALUES (20012, to_date('2022-01-17', 'yyyy-mm-dd'), NULL, 106, 1013)
INTO orders VALUES (20013, to_date('2022-01-18', 'yyyy-mm-dd'), NULL, 107, 1016)
INTO orders VALUES (20014, to_date('2022-01-18', 'yyyy-mm-dd'), 'Customer reported parts missing in the box', 107, 1017)
INTO orders VALUES (20015, to_date('2022-01-21', 'yyyy-mm-dd'), NULL, 110, 1018)
INTO orders VALUES (20016, to_date('2022-01-21', 'yyyy-mm-dd'), NULL, 111, 1018)
INTO orders VALUES (20017, to_date('2022-01-22', 'yyyy-mm-dd'), 'Customer would like to get silver color if there is stock', 111, 1019)
INTO orders VALUES (20018, to_date('2022-01-23', 'yyyy-mm-dd'), NULL, 116, 1022)
INTO orders VALUES (20019, to_date('2022-01-24', 'yyyy-mm-dd'), NULL, 116, 1023)
INTO orders VALUES (20020, to_date('2022-01-24', 'yyyy-mm-dd'), NULL, 117, 1026)
INTO orders VALUES (20021, to_date('2022-01-24', 'yyyy-mm-dd'), NULL, 120, 1027)
INTO orders VALUES (20022, to_date('2022-01-25', 'yyyy-mm-dd'), NULL, 122, 1027)
INTO orders VALUES (20023, to_date('2022-01-26', 'yyyy-mm-dd'), 'Customer complainted he did not receive the delivery, someone else signed and took the good for him', 128, 1028)
INTO orders VALUES (20024, to_date('2022-01-26', 'yyyy-mm-dd'), NULL, 124, 1029)
INTO orders VALUES (20025, to_date('2022-01-27', 'yyyy-mm-dd'), 'Oversea order, please arrange shippment and charge the customer if extra cost occurs', 129, 1029)
SELECT * FROM dual;
/* Sample data for 'receipt' */
INSERT ALL
INTO receipt VALUES (120039, 20001, to_date('2022-01-06', 'yyyy-mm-dd'))
INTO receipt VALUES (120040, 20002, to_date('2022-01-06', 'yyyy-mm-dd'))
INTO receipt VALUES (120041, 20003, to_date('2022-01-08', 'yyyy-mm-dd'))
INTO receipt VALUES (120042, 20004, to_date('2022-01-09', 'yyyy-mm-dd'))
INTO receipt VALUES (120043, 20005, to_date('2022-01-11', 'yyyy-mm-dd'))
INTO receipt VALUES (120044, 20006, to_date('2022-01-11', 'yyyy-mm-dd'))
INTO receipt VALUES (120045, 20007, to_date('2022-01-11', 'yyyy-mm-dd'))
INTO receipt VALUES (120046, 20008, to_date('2022-01-12', 'yyyy-mm-dd'))
INTO receipt VALUES (120047, 20009, to_date('2022-01-14', 'yyyy-mm-dd'))
INTO receipt VALUES (120048, 20010, to_date('2022-01-14', 'yyyy-mm-dd'))
INTO receipt VALUES (120049, 20011, to_date('2022-01-16', 'yyyy-mm-dd'))
INTO receipt VALUES (120050, 20012, to_date('2022-01-17', 'yyyy-mm-dd'))
INTO receipt VALUES (120051, 20013, to_date('2022-01-18', 'yyyy-mm-dd'))
INTO receipt VALUES (120052, 20014, to_date('2022-01-18', 'yyyy-mm-dd'))
INTO receipt VALUES (120053, 20015, to_date('2022-01-21', 'yyyy-mm-dd'))
INTO receipt VALUES (120054, 20016, to_date('2022-01-21', 'yyyy-mm-dd'))
INTO receipt VALUES (120055, 20017, to_date('2022-01-22', 'yyyy-mm-dd'))
INTO receipt VALUES (120056, 20018, to_date('2022-01-23', 'yyyy-mm-dd'))
INTO receipt VALUES (120057, 20019, to_date('2022-01-24', 'yyyy-mm-dd'))
INTO receipt VALUES (120058, 20020, to_date('2022-01-24', 'yyyy-mm-dd'))
INTO receipt VALUES (120059, 20021, to_date('2022-01-24', 'yyyy-mm-dd'))
INTO receipt VALUES (120060, 20022, to_date('2022-01-25', 'yyyy-mm-dd'))
INTO receipt VALUES (120061, 20023, to_date('2022-01-26', 'yyyy-mm-dd'))
INTO receipt VALUES (120062, 20024, to_date('2022-01-26', 'yyyy-mm-dd'))
INTO receipt VALUES (120063, 20025, to_date('2022-01-27', 'yyyy-mm-dd'))
SELECT * FROM dual;
/* Sample data for 'warehouse' */
INSERT ALL
INTO warehouse VALUES (20001, 1, 1, to_date('2022-01-08', 'yyyy-mm-dd'), to_date('2022-01-10', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20001, 2, 2, to_date('2022-01-08', 'yyyy-mm-dd'), to_date('2022-01-10', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20002, 3, 4, to_date('2022-01-09', 'yyyy-mm-dd'), to_date('2022-01-11', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20003, 4, 1, to_date('2022-01-10', 'yyyy-mm-dd'), to_date('2022-01-12', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20004, 5, 2, to_date('2022-01-11', 'yyyy-mm-dd'), to_date('2022-01-13', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20005, 6, 3, to_date('2022-01-13', 'yyyy-mm-dd'), to_date('2022-01-15', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20005, 7, 1, to_date('2022-01-13', 'yyyy-mm-dd'), to_date('2022-01-15', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20005, 8, 2, to_date('2022-01-13', 'yyyy-mm-dd'), to_date('2022-01-15', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20006, 9, 1, to_date('2022-01-14', 'yyyy-mm-dd'), to_date('2022-01-16', 'yyyy-mm-dd'), 3)
INTO warehouse VALUES (20007, 10, 2, to_date('2022-01-13', 'yyyy-mm-dd'), to_date('2022-01-15', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20008, 11, 3, to_date('2022-01-14', 'yyyy-mm-dd'), to_date('2022-01-16', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20008, 12, 1, to_date('2022-01-14', 'yyyy-mm-dd'), to_date('2022-01-16', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20009, 13, 1, to_date('2022-01-15', 'yyyy-mm-dd'), to_date('2022-01-17', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20010, 14, 2, to_date('2022-01-16', 'yyyy-mm-dd'), to_date('2022-01-18', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20011, 15, 5, to_date('2022-01-18', 'yyyy-mm-dd'), to_date('2022-01-20', 'yyyy-mm-dd'), 3)
INTO warehouse VALUES (20012, 16, 2, to_date('2022-01-19', 'yyyy-mm-dd'), to_date('2022-01-21', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20013, 17, 2, to_date('2022-01-20', 'yyyy-mm-dd'), to_date('2022-01-22', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20014, 18, 1, to_date('2022-01-20', 'yyyy-mm-dd'), to_date('2022-01-22', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20015, 19, 3, to_date('2022-01-23', 'yyyy-mm-dd'), to_date('2022-01-25', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20016, 20, 6, to_date('2022-01-23', 'yyyy-mm-dd'), to_date('2022-01-25', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20017, 21, 3, to_date('2022-01-24', 'yyyy-mm-dd'), to_date('2022-01-26', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20018, 22, 4, to_date('2022-01-25', 'yyyy-mm-dd'), to_date('2022-01-27', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20019, 23, 8, to_date('2022-01-26', 'yyyy-mm-dd'), to_date('2022-01-28', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20020, 24, 2, to_date('2022-01-26', 'yyyy-mm-dd'), to_date('2022-01-28', 'yyyy-mm-dd'), 3)
INTO warehouse VALUES (20021, 25, 3, to_date('2022-01-27', 'yyyy-mm-dd'), to_date('2022-01-29', 'yyyy-mm-dd'), 2)
INTO warehouse VALUES (20022, 26, 5, to_date('2022-01-28', 'yyyy-mm-dd'), to_date('2022-01-30', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20023, 27, 10, to_date('2022-01-29', 'yyyy-mm-dd'), to_date('2022-01-31', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20024, 28, 1, to_date('2022-01-30', 'yyyy-mm-dd'), to_date('2022-02-01', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20025, 29, 2, to_date('2022-02-01', 'yyyy-mm-dd'), to_date('2022-02-14', 'yyyy-mm-dd'), 1)
INTO warehouse VALUES (20025, 30, 3, to_date('2022-02-01', 'yyyy-mm-dd'), to_date('2022-02-14', 'yyyy-mm-dd'), 1)
SELECT * FROM dual;