举例,我们用股票来举例,插入任意股票,我们这里假设十只,要求10只不同的股票、从2016-2018年,不同价格,从100-900share)
标柱你的格式为 ‘COG','IT',104.02,560,195.00,TODATE(NOV 28, 2018', 'MON DD,YYYY));
answer:
insert into stock_data values('TCS', 'IT',234.12,100,174.00,TO_DATE('DEC 04, 2018', 'MON DD, YYYY'));
insert into stock_data values('ASD', 'Infra',334.12,200,275.00,TO_DATE('DEC 03, 2018', 'MON DD, YYYY'));
insert into stock_data values('INFY', 'IT',104.92,300,175.00,TO_DATE('NOV 12, 2018', 'MON DD, YYYY'));
insert into stock_data values('CVS', 'Pharma',174.70,400,155.00,TO_DATE('DEC 1, 2018', 'MON DD, YYYY'));
insert into stock_data values('DLF', 'Infra',454.89,500,165.00,TO_DATE('NOV 03, 2018', 'MON DD, YYYY'));