-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathInsert-Data_Creation_Queries.sql
More file actions
256 lines (238 loc) · 25.8 KB
/
Insert-Data_Creation_Queries.sql
File metadata and controls
256 lines (238 loc) · 25.8 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
set define off;
INSERT ALL
INTO CUSTOMER_DETAILS VALUES (11489 , 'Megan Joseph' , '19-jun-1980' , 41, 2347905511 , 92133 , 'New York' , '41, Melvin street' , '22-FEB-2020' , 'Knight@1' , 'Safforn' , 'Balling')
INTO CUSTOMER_DETAILS VALUES (34749 , 'Wane Fox' , '11-NOV-1992' , 31, 2347865588 , 37553 , 'FLORIDA' , '22, Park Street' , '17-MAY-2019' , 'Toyyy777' , 'Sanban*8' , 'Yussss')
INTO CUSTOMER_DETAILS VALUES (55631 , 'Tejas Bawankar' , '11-JUL-1994' , 27, 8983122563 , 44043, 'Texas' , '71, Pandey layout' , '09-NOV-2019' , 'Aditi@04' , 'Mastaa' , 'Chobugomu')
INTO CUSTOMER_DETAILS VALUES (76231 , 'Siddharth Savant' , '19-JUL-1996' , 25, 9559240344 , 89645, 'California' , '55, South Nagar' , '26-SEP-2017' , 'Cloud@04' , 'Funnyman' , 'Rowbow2')
INTO CUSTOMER_DETAILS VALUES (90214 , 'Vaibhavi T' , '09-Oct-1996' , 25, 8149935345 , 77564 , 'Texas' , '71, Effco Way' , '14-OCT-2018' , 'Space@05' , 'Cutiepie' , 'Unicorn')
INTO CUSTOMER_DETAILS VALUES (87452 , 'Jack Columbus' , '01-jan-1988' , 32, 8149976541 , 72123 , 'Washington' , '89, Treat Streat' , '19-Jul-2021' , 'yahoo&5' , 'Lassi' , 'Beatit')
INTO CUSTOMER_DETAILS VALUES (31000,'Anne Maria','02-Apr-1980',41,8576870012,02130,'Arizona','75 Tent Street','13-Jan-2021','Tina@123','tiger','pet')
INTO CUSTOMER_DETAILS VALUES (31001,'Ted Mosby','03-Jun-1990',32,8576871655,41115,'New Jersey','34 Tremont Street','7-Aug-2019','Kitc@345','pune','mumbai')
INTO CUSTOMER_DETAILS VALUES (31002,'Bill Gates','04-Sep-1950',71,8547865532,02137,'New Mexico','94 Las Palmas RicoTower','05-Feb-2020','RIYA@me','travel','read')
INTO CUSTOMER_DETAILS VALUES (31003,'Hillary Clinton','05-Sep-1998',23,2347865539,67139,'Florida','51 Venus Ave','21-Jul-2017','Loik@hjk','love','friends')
INTO CUSTOMER_DETAILS VALUES (31004,'Gauri Pasarkar','10-Dec-1991',31,2347985511,92135,'New York','41 Melvin street','21-Feb-2020','ujki@wer','this','that')
INTO CUSTOMER_DETAILS VALUES (31005,'Sneha Chavan','10-Oct-1998',23,2347865578,37553,'Florida','22 Park Street','09-May-2019','Toyyy779','meera','mamacita')
INTO CUSTOMER_DETAILS VALUES (31006,'Ram Wajpe','05-Dec-2004',17,8983122565,74047,'Texas','71 Shivneri nagar','25-Nov-2020','Meer@tuu','school','college')
INTO CUSTOMER_DETAILS VALUES (31007,'Herika Koshti','06-Dec-1994',27,9759240344,86648,'California','58 North Nagar','28-Jun-2017','Cloud@04','florida','texas')
INTO CUSTOMER_DETAILS VALUES (31008,'Priyanka Singh','01-Feb-1965',56,7149935345,77597,'Texas','75 Alpha Street','03-Oct-2018','444@hjkk','america','india')
INTO CUSTOMER_DETAILS VALUES (31009,'Aarti Mehta','02-Mar-1977',44,8169976541,72233,'Washington','101 Harbour point','08-Jul-2021','Tvj@7899','mountain','tesla')
INTO CUSTOMER_DETAILS VALUES (13459,'Samual Adams','10-NOV-1993',28,6173456712,02120,'Massachussets','21, Barclay avenue','4-Jul-18','sam11','ponyback','sweater')
INTO CUSTOMER_DETAILS VALUES (43678,'Mary J','5-Dec-1990',31,8571234560,23412,'California','34, saint cakestreet ','16-Aug-17','23fgh','afgan','chair')
INTO CUSTOMER_DETAILS VALUES (13478,'Mihir Khanna','3-Jan-1985',36,7194567120,21001,'New York','45, baker street','1-Oct-17','yuper11','lamp','pen')
INTO CUSTOMER_DETAILS VALUES (45912,'Peter Parking','4-Feb-1980',41,6172347098,21304,'New York','45, marker corner street','12-Sep-13','walk123','switch','bottle')
INTO CUSTOMER_DETAILS VALUES (34157,'Manu Singh','27-Mar-1989',32,6178907222,51111,'Texas','67, yard hall street','22-Jan-13','456sd','sweater','lamp')
INTO CUSTOMER_DETAILS VALUES (14591,'Divya Sen','15-May-1999',22,3478902450,21334,'Texas','90,alps way','15-Feb-15','assdf','wall','spoon')
INTO CUSTOMER_DETAILS VALUES (23567,'Josie Blue','5-Dec-1990',31,8572341681,56001,'Virginia','567, wall mount road','12-Feb-18','josie12','garden','flag')
INTO CUSTOMER_DETAILS VALUES (72012,'Hose mathew','15-Jul-1992',29,6172345098,21333,'Washington','102, walking bistro way','18-Jun-15','san001','button','floor')
INTO CUSTOMER_DETAILS VALUES (20367,'Carrie Andres','24-May-1977',44,9071267000,60023,'Alaska','71,treat pathway ','16-Jan-20','laptop12','mouse','chain')
INTO CUSTOMER_DETAILS VALUES (11123,'Andrew Hanson','16-Jul-1950',71,9731230096,32201,'New Jersey','111, baker street ','10-Feb-14','gage456','mat','chakna')
INTO CUSTOMER_DETAILS VALUES (21000, 'Cristiano Ronaldo','05-FEB-1985',36,8578576969,21209,'Texas',' 34 Tremont Street','18-DEC-17', 'Cris123','striker','penalty')
INTO CUSTOMER_DETAILS VALUES (21001,'Kevin Owens','09-MAR-1987',34,9282920039,23099,'Massachussets','69, Mountain Street','29-MAR-16','Owns123','wall','lamp')
INTO CUSTOMER_DETAILS VALUES (21002, 'Kathy Mclerens', '09-APR-1987',34,2287882920,28892,'California','87, Google Street','30-MAR-16','kijuh','Laptop','Apple')
INTO CUSTOMER_DETAILS VALUES (21003, 'Hanny Osas','09-MAY-1998',23,2288292883,23829,'Illinois','98, Kreson pathway','28-FEB-12','Hanny167','Mango','Sauce')
INTO CUSTOMER_DETAILS VALUES (21004, 'Orland Sequal','10-OCT-1996',23,2663782883,21201,'Arizona','98, Amazon street', '29-MAY-20','haha981','Sun', 'Desert')
INTO CUSTOMER_DETAILS VALUES (21005,'Lionel Messi','10-OCT-1998',23,8837728248,98221,'Massachussets','34,Alphosus Street', '31-JAN-21','CrisNo2','GOAT','AlsoBest')
INTO CUSTOMER_DETAILS VALUES (21006,'Benjamin Cena','12-MAY-1974',50,3546738264,12131,'Washington','98, Hungtington Ave','23-SEP-16','hbb82','Feed','Instagram')
INTO CUSTOMER_DETAILS VALUES (21007,'Joseph Orton','12-JUN-1974',34,9917717713,31312,'Maryland','76, Solapur','15-SEP-19','nk82','Food','Pav Bhaji')
INTO CUSTOMER_DETAILS VALUES (21008,'Kane Williamson','03-JAN-1967',54,1772123781,13535,'Florida','87, The rock park','17-AUG-14','mbqi','Misal','Idli')
INTO CUSTOMER_DETAILS VALUES (21009,'MS Dhoni','03-FEB-1967',28,2663772899,35666,'North Carolina','34, Dou Lane','09-OCT-19','nns','Puranpoli','Dosa')
SELECT * FROM DUAL;
INSERT ALL
INTO MUTUAL_FUND_DETAILS VALUES ('MU1002' , 'L&T Midcap-Growth' , 'Medium' , 100.1)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1003' , 'Principal Emerging Bluechip Fund-Growth' , 'Low' , 181.2)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1004' , 'Franklin Build India Fund-Growth' , 'High' , 64.01)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1005' , 'IDFC Infrastructure Fund-Growth' , 'Medium' , 50)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1006' , 'Aditya Birla Sun Life Small Cap Fund' , 'High' , 105.5)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1007' , 'SBI Small Cap Fund' , 'Medium' , 120.3)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1008' , 'IDFC Tax Advantage (ELSS) Fund' , 'Low' , 68.01)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1009' , 'L&T Emerging Businesses Fund' , 'Low' , 70.76)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1010' , 'DSP BlackRock Natural Fund' , 'Medium' , 130.7)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1011' , 'ICICI Prudential Midcap 150 ETF' , 'High' , 117.4)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1012' , 'Quant Small Cap Fund' , 'Low' , 84.32)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1013' , 'Tata Digital India Fund' , 'High' , 175)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1014' , 'Sundaram Select Micro Cap' , 'Medium' , 128.4)
INTO MUTUAL_FUND_DETAILS VALUES ('MU1015' , 'Kotak Small Cap Fund' , 'Low' , 54.02)
SELECT * FROM DUAL;
INSERT ALL
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0000','MU1002', 31000,'20-Jan-21',30,99.12,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0001','MU1002', 31000,'21-Jan-21',20,100,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0002','MU1002', 31000,'21-Jan-21',20,100,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0003','MU1002', 31000,'15-Feb-21',10,97.12,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0004','MU1002', 31000,'24-Mar-21',20,96.67,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0005','MU1003', 31001,'12-Dec-19',10,179.65,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0006','MU1003', 31001,'15-May-20',15,178,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0007','MU1003', 31001,'25-Nov-20',28,170.9,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0008','MU1003', 31001,'1-Apr-21',13,182.13,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0009','MU1003', 31001,'5-Jul-21',15,183.9,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0010','MU1004', 31002,'15-Feb-20',102, 60.1,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0011','MU1004', 31002,'25-Feb-20',50, 65.02,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0012','MU1004', 31002,'18-Apr-20',70, 63.12,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0013','MU1004', 31002,'11-Jan-21',100, 66.3,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0014','MU1005', 31002,'2-Mar-20',900, 45.12,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0015','MU1005', 31002,'5-May-20',500, 46.12,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0016','MU1005', 31002,'21-Jun-20',304, 48.3,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0017','MU1005', 31002,'3-Apr-21',700, 53.55,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0018','MU1005', 31002,'14-May-21',600, 58,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0019','MU1006', 31003,'20-Aug-17',55, 101.34,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0020','MU1006', 31003,'17-Sep-17',46, 106.12,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0021','MU1006', 31003,'10-Mar-18',105, 95.12,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0022','MU1006', 31003,'29-Dec-18',89, 107.67,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0023','MU1006', 31003,'22-Aug-19',203, 98.32,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0024','MU1006', 31003,'18-Sep-19',170, 108.21,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0025','MU1007', 31004,'10-May-20',400, 119.16,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0026','MU1007', 31004,'29-Jan-21',356, 139.34,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0027','MU1009', 31004,'16-Mar-20',205, 65.43,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0028','MU1009', 31004,'18-Jul-20',303, 59.76,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0029','MU1009', 31004,'26-May-21',480, 87.63,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0030','MU1014', 31004,'13-Jul-20',16, 122.1,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0031','MU1014', 31004,'18-Aug-20',30, 124.14,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0032','MU1014', 31004,'14-Oct-20',58, 127.09,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0033','MU1014', 31004,'18-Mar-21',25, 145.16,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0034','MU1014', 31004,'9-Jun-21',29,150.14,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0035','MU1015', 31005,'23-Aug-19',104, 52.09,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0036','MU1015', 31005,'23-Feb-20',208, 49.14,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0037','MU1015', 31005,'19-Mar-21',137, 48.14,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0038','MU1015', 31005,'19-May-21',108, 58.15,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0039','MU1015', 31005,'22-Jul-21',99, 66.25,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0040','MU1008', 31006,'29-Nov-20',15, 54.15,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0041','MU1008', 31006,'17-May-21',60, 62.56,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0042','MU1008', 31006,'25-Jun-21',86, 61.09,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0043','MU1008', 31006,'4-Oct-21',46, 50.16,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0044','MU1008', 31006,'11-Nov-21',39, 57.26,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0045','MU1002', 31006,'17-Dec-20',180, 88.17,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0046','MU1002', 31006,'11-Sep-21',150, 204.67,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0047','MU1010', 31007,'2-Jul-17',200,129.1,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0048','MU1010', 31007,'6-Sep-17',109, 112.08,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0049','MU1010', 31007,'19-Oct-17',156, 100.8,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0050','MU1010', 31007,'16-Jan-21',109, 209,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0051','MU1010', 31007,'7-May-21',70, 223.17,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0052','MU1010', 31007,'12-Oct-21',106, 250.18,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0053','MU1012', 31008,'13-Nov-18',560, 81.08,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0054','MU1012', 31008,'28-Aug-19',444, 110.12,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0055','MU1011', 31008,'18-Jun-20',200, 116.19,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0056','MU1011', 31008,'7-Sep-21',190, 180.17,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0057','MU1011', 31009,'12-Jul-21',309, 110.13,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0058','MU1011', 31009,'10-Nov-21',301, 140.45,'S')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0059','MU1013', 31009,'22-Aug-21',100, 171.9,'B')
INTO MUTUAL_FUND_TRANSACTIONS VALUES ('MUF0060','MU1013', 31009,'1-Dec-21',98, 160.09,'S')
SELECT * FROM DUAL;
INSERT ALL
INTO STOCK_DETAILS VALUES ('STOCK001', 'Apple', 'AAPL', 'Technology', 164.94)
INTO STOCK_DETAILS VALUES ('STOCK002', 'Tesla' ,'TSLA', 'EV' ,1160.3)
INTO STOCK_DETAILS VALUES ('STOCK003', 'Moderna', 'MRNA','Pharma', 271.4)
INTO STOCK_DETAILS VALUES ('STOCK004', 'Alphabet', 'GOOGL','Technology', 2922.4)
INTO STOCK_DETAILS VALUES ('STOCK005', 'Amazon' , 'AMZN', 'E-commerce', 3580.41)
INTO STOCK_DETAILS VALUES ('STOCK006', 'Biogen', 'BIIB', 'Pharma', 250.13)
INTO STOCK_DETAILS VALUES ('STOCK007', 'T-Mobile' ,'TMUS', 'Telecom', 114.48)
INTO STOCK_DETAILS VALUES ('STOCK008', 'ElecArts' , 'EA', 'Electronic', 126.25)
INTO STOCK_DETAILS VALUES ('STOCK009', 'Intel' ,'INTC','Technology', 50)
INTO STOCK_DETAILS VALUES ('STOCK010', 'Nvidia', 'NVDA', 'Technology', 326.24)
INTO STOCK_DETAILS VALUES ('STOCK011', 'Dell', 'DELL', 'Technology',57.3)
INTO STOCK_DETAILS VALUES ('STOCK012', 'HP', 'HPQ', 'Technology', 35.44)
INTO STOCK_DETAILS VALUES ('STOCK013', 'Pfizer', 'PFE', 'Pharma', 50.89)
INTO STOCK_DETAILS VALUES ('STOCK014', 'JPMC', 'JPM', 'Banking', 116.89)
INTO STOCK_DETAILS VALUES ('STOCK015', 'Shopify', 'SHOP', 'EComm', 1628.67)
INTO STOCK_DETAILS VALUES ('STOCK016', 'Facebook', 'FB', 'Technology', 341.06)
INTO STOCK_DETAILS VALUES ('STOCK017', 'Adobe', 'ADBE', 'Technology', 668.32)
INTO STOCK_DETAILS VALUES ('STOCK018', 'NextEra', 'NEE', 'Energy', 87.32)
INTO STOCK_DETAILS VALUES ('STOCK019', 'FirstSolar', 'FSLR', 'Energy', 108.28)
INTO STOCK_DETAILS VALUES ('STOCK020', 'JNJ', 'JNJ', 'Pharma', 160.24)
SELECT * FROM DUAL;
INSERT ALL
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0001', 'STOCK001','CUST21000','20-Jan-21',100,170.89,'B','NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0002', 'STOCK001','CUST21000','21-NOV-21',100,172.76,'S','NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0003', 'STOCK002','CUST21000','20-NOV-20',130,1160.66,'B','NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0004', 'STOCK002','CUST21000','21-SEP-21',120,1162.44,'S','NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0005', 'STOCK003','CUST21001','21-FEB-21',60,275.44, 'B','NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0006', 'STOCK003', 'CUST21001','23-AUG-21',60, 274.66, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0007', 'STOCK004', 'CUST21001','22-MAY-20',20, 2922.44, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0008', 'STOCK004', 'CUST21001','11-AUG-21',15, 2930.44, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0009', 'STOCK005', 'CUST21002','20-FEB-20',30, 3480.65, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0010', 'STOCK005', 'CUST21002','20-SEP-21',30, 3580.44, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0011', 'STOCK006', 'CUST21002','15-SEP-19',75, 260.23, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0012', 'STOCK006', 'CUST21002','15-OCT-21',75, 245.56, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0013', 'STOCK007', 'CUST21003','29-APR-20',10, 110.67, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0014', 'STOCK007', 'CUST21003','27-MAY-21',10, 114.32, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0015', 'STOCK008', 'CUST21003','02-JUL-19',500,125.67, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0016', 'STOCK008', 'CUST21003','27-AUG-21',450,127.66, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0017', 'STOCK009', 'CUST21004','21-SEP-20',37, 49.32, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0018', 'STOCK009', 'CUST21004','18-MAY-21',25, 48.34, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0019', 'STOCK010', 'CUST21004','15-SEP-21',50, 320.56, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0020', 'STOCK010', 'CUST21004','16-OCT-21',25, 315.32, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0021', 'STOCK010', 'CUST21004','21-NOV-21',75, 322.56, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0022', 'STOCK011', 'CUST21005','19-FEB-20',1000,30.56, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0023', 'STOCK011', 'CUST21005','19-OCT-21',1000,57.11, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0024', 'STOCK012', 'CUST21005','19-AUG-19',700,40.34, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0025', 'STOCK012', 'CUST21005','28-OCT-20',600,35.52, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0026', 'STOCK012', 'CUST21005','30-OCT-20',100,50.45, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0027', 'STOCK013', 'CUST21006','19-JUN-20',140,47.45, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0028', 'STOCK013', 'CUST21006','19-SEP-20',100,49.59, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0029', 'STOCK013', 'CUST21006','20-OCT-21',200,54.87, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0030', 'STOCK013', 'CUST21006','20-NOV-21',40, 50.32, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0031', 'STOCK014', 'CUST21006','07-FEB-21',65, 110.76, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0032', 'STOCK014', 'CUST21006','11-NOV-21',65, 115.78, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0033', 'STOCK015', 'CUST21007','05-MAY-21',120,1500.76,'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0034', 'STOCK015', 'CUST21007','27-SEP-21',120,1628.65,'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0035', 'STOCK016', 'CUST21007','27-JAN-21',150,330.42, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0036', 'STOCK016', 'CUST21007','27-OCT-21',150,346.98, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0037', 'STOCK017', 'CUST21008','09-JUN-20',980,668.65, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0038', 'STOCK017', 'CUST21008','29-JUL-21',980,630.67, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0039', 'STOCK018', 'CUST21008','18-JAN-21',560,50.76, 'B', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0040', 'STOCK018', 'CUST21008','18-SEP-21',60, 80.78, 'S', 'NYSE')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0041', 'STOCK019', 'CUST21009','21-OCT-21',890,100.34, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0042', 'STOCK019', 'CUST21009','21-NOV-21',890,108.89, 'S', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0043', 'STOCK020', 'CUST21009','15-JAN-20',560,140.98, 'B', 'NASDAQ')
INTO STOCK_TRANSACTIONS VALUES ('STOCKTRANS0044', 'STOCK020', 'CUST21009','15-SEP-21',560,160.32, 'S', 'NASDAQ')
SELECT * FROM DUAL;
INSERT ALL
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012576', 'CR001', 'CUST11075', '24-Apr-21','CR002', 1000, 1.338, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012577', 'CR001', 'CUST87454', '6-Jul-21', 'CR002', 1500, 1.338, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012578', 'CR001', 'CUST11489', '7-Jul-21', 'CR006', 700, 0.013, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012579', 'CR001', 'CUST13478', '14-Aug-21','CR004', 800, 0.151, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012580', 'CR001', 'CUST14591', '23-Feb-21','CR009', 2000, 0.728, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012581', 'CR001', 'CUST72012', '5-Jan-21', 'CR002', 1700, 1.338, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012582', 'CR001', 'CUST43678', '14-Jan-21','CR010', 500, 1.08, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012583', 'CR001', 'CUST21002', '30-Sep-21','CR007', 300, 0.134, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012584', 'CR001', 'CUST21005', '22-Nov-21','CR009', 2500, 0.728, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012585', 'CR001', 'CUST21007', '18-Aug-21','CR011', 6000, 0.0132, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012586', 'CR001', 'CUST31002', '16-Mar-21','CR012', 3500, 0.008, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012587', 'CR001', 'CUST31005', '25-Mar-21','CR011', 400, 0.0132, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012588', 'CR001', 'CUST31007', '6-Oct-21', 'CR013', 900, 0.782, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012589', 'CR001', 'CUST31003', '17-Jun-21','CR014', 1000, 0.235, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012590', 'CR001', 'CUST11075', '25-Aug-21','CR002', 200, 1.4, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012591', 'CR001', 'CUST11075', '24-Jul-21','CR006', 1000, 0.013, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012592', 'CR001', 'CUST11075', '23-May-21','CR006', 400, 0.013, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012593', 'CR001', 'CUST11075', '25-Nov-21','CR006', 700, 0.013, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012594', 'CR001', 'CUST72012', '2-Jan-21', 'CR008', 2000, 0.717, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012595', 'CR001', 'CUST72012', '4-Apr-21', 'CR008', 2000, 0.818, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012596', 'CR001', 'CUST90214', '11-Jul-21','CR011', 5000, 0.0132, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012597', 'CR001', 'CUST90214', '7-Sep-21', 'CR013', 1000, 0.782, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012598', 'CR001', 'CUST90214', '16-Aug-21','CR011', 5000, 0.0512, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012599', 'CR001', 'CUST87452', '3-Jun-21', 'CR010', 500, 1.08, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012600', 'CR001', 'CUST87452', '3-Mar-21', 'CR005', 900, 1.134, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012601', 'CR001', 'CUST87454', '7-Oct-21', 'CR005', 900, 1.1, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012602', 'CR001', 'CUST87454', '7-Oct-21', 'CR010', 400, 1.2, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012603', 'CR001', 'CUST31009', '7-Jan-21', 'CR002', 600, 1.338, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012604', 'CR001', 'CUST31009', '8-Feb-21', 'CR002', 500, 1.45, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012605', 'CR001', 'CUST43157', '19-Jan-21','CR001', 800, 1, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012606', 'CR001', 'CUST11123', '7-May-21', 'CR012', 1500, 0.008, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012607', 'CR001', 'CUST31006', '5-Mar-21', 'CR006', 800, 0.014, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012608', 'CR001', 'CUST31007', '6-Mar-21', 'CR007', 550, 0.135, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012609', 'CR001', 'CUST43157', '19-Nov-21','CR001', 700, 1, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012610', 'CR001', 'CUST34749', '8-May-21', 'CR010', 600, 1.08, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012611', 'CR001', 'CUST45912', '17-Jul-21','CR005', 4000, 1.134, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012612', 'CR001', 'CUST21005', '8-Aug-21', 'CR013', 900 , 0.783, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012613', 'CR001', 'CUST45912', '29-Jul-21','CR005', 1000, 1.136, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012614', 'CR001', 'CUST31007', '7-Mar-21', 'CR007', 550, 0.15, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012615', 'CR001', 'CUST34749', '7-Oct-21', 'CR010', 600, 1.09, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012616', 'CR001', 'CUST11123', '8-May-21', 'CR012', 800, 0.009, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012617', 'CR001', 'CUST11123', '9-May-21', 'CR012', 500, 0.078, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012618', 'CR001', 'CUST11123', '17-Aug-21','CR012', 800, 0.9, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012619', 'CR001', 'CUST45912', '9-Sep-21', 'CR005', 1000, 1.5, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012620', 'CR001', 'CUST21005', '9-Dec-21', 'CR013', 900, 0.9, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012621', 'CR001', 'CUST11123', '19-Aug-21','CR012', 200 , 0.95, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012622', 'CR001', 'CUST43678', '5-Jun-21', 'CR015', 2300, 0.061, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012623', 'CR001', 'CUST43678', '8-Aug-21', 'CR015', 2300, 0.7, 'S')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012624', 'CR001', 'CUST21009', '18-Jul-21','CR003', 1700, 0.275, 'B')
INTO FOREIGN_EXCHANGE_TRANSACTIONS VALUES('CT0012625', 'CR001', 'CUST21009', '20-Nov-21','CR003', 1700, 0.3, 'S')
SELECT * FROM DUAL;