ora8oledbscript.sql

LOB objects for oracle database,inserting them to database

'5', 'Spanish'); 
INSERT INTO LANGUAGE ( LANGUAGE_ID, LANGUAGE_NAME ) VALUES ( 
'6', 'German'); 
INSERT INTO LANGUAGE ( LANGUAGE_ID, LANGUAGE_NAME ) VALUES ( 
'1', 'Dutch'); 
commit;



REM *********************************************************************
PROMPT Inserting Sample Data into SUPPLIER table and Commit 
REM *********************************************************************
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102050, 'ABC PRODUCTS LTD'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102051, 'PQR Computers'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102053, 'NEXGEN AGENCIES'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102055, 'XYZ PVT LTD'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102057, 'SUPER COMPUTERS'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102060, 'Y AXIS DEALERS'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102061, 'ZOOM TECH LTD'); 
INSERT INTO SUPPLIER ( SUPPLIER_ID, SUPPLIER_NAME ) VALUES ( 
102068, 'TELESOFT COMMUNICATIONS'); 
commit;



REM *********************************************************************
PROMPT Inserting Sample Data into ORDERS table and Commit 
REM *********************************************************************
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2436,  TO_Date( '09/02/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 6394.8, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2446,  TO_Date( '07/27/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 103679.3, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2447,  TO_Date( '07/27/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 33893.6, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2432,  TO_Date( '09/14/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 10523, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2433,  TO_Date( '09/13/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 78, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2359,  TO_Date( '01/08/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5543.1, 102068); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2390,  TO_Date( '11/18/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 7616.8, 102061); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2407,  TO_Date( '06/29/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2519, 102060); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2410,  TO_Date( '05/24/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 45175, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2411,  TO_Date( '05/24/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 15760.5, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2412,  TO_Date( '03/29/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 66816, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2413,  TO_Date( '03/29/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 48552, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2414,  TO_Date( '03/29/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 10794.6, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2415,  TO_Date( '03/29/1997 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 310, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2416,  TO_Date( '03/29/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 384, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2417,  TO_Date( '03/20/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1926.6, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2418,  TO_Date( '03/20/1996 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5546.6, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2419,  TO_Date( '03/20/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 31574, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2420,  TO_Date( '03/13/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 29750, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2421,  TO_Date( '03/12/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 72836, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2422,  TO_Date( '12/16/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 11188.5, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2423,  TO_Date( '11/21/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 10367.7, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2424,  TO_Date( '11/21/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 13824, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2425,  TO_Date( '11/17/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1500.8, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2426,  TO_Date( '11/17/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 7200, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2427,  TO_Date( '11/10/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 9055, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2428,  TO_Date( '11/10/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 14685.8, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2429,  TO_Date( '11/10/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 50125, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2430,  TO_Date( '10/02/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 29669.9, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2431,  TO_Date( '09/14/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5610.6, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2437,  TO_Date( '09/01/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 13550, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2438,  TO_Date( '09/01/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5451, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2439,  TO_Date( '08/31/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 22150.1, 102053); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2441,  TO_Date( '08/01/2000 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2075.2, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2442,  TO_Date( '07/27/1990 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 52471.9, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2443,  TO_Date( '07/27/1990 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 3646, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2444,  TO_Date( '07/27/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 77727.2, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2445,  TO_Date( '07/27/1990 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 5537.8, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2448,  TO_Date( '06/18/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1388, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2453,  TO_Date( '10/04/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 129, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2456,  TO_Date( '11/07/1998 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 3878.4, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2457,  TO_Date( '10/31/1999 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 21586.2, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2459,  TO_Date( '06/08/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1384, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2460,  TO_Date( '06/08/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 192, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2461,  TO_Date( '06/09/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 22, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2462,  TO_Date( '06/09/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1600, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2463,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2225, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2464,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 960, 102050);