ora7oledbscript.sql

LOB objects for oracle database,inserting them to database

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); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2465,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), NULL, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2466,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 576, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2467,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 960, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2468,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2800, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2469,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 144, 102050); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2470,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 144, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2471,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 960, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2472,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1840, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2473,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2000, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2474,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), NULL, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2475,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 960, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2476,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 192, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2477,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 144, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2478,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), NULL, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2479,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), NULL, 102051); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2480,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1840, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2481,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 48, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2482,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 48, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2483,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 48, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2484,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), NULL, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2485,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 80, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2486,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 400, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2487,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 80, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2488,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 80, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2489,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 48, 102055); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2490,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 80, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2491,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 675, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2492,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 36000, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2493,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 240, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2494,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 400000, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2495,  TO_Date( '06/12/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 101, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2496,  TO_Date( '06/14/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 1239, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2497,  TO_Date( '06/14/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 46, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2498,  TO_Date( '06/14/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 900000, 102057); 
INSERT INTO ORDERS ( ORDER_ID, ORDER_DATE, ORDER_TOTAL, SUPPLIER_ID ) VALUES ( 
2499,  TO_Date( '06/15/2001 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 900000, 102057); 
commit;


REM *********************************************************************
PROMPT Inserting Sample Data into PRODUCT_INFORMATION table and Commit 
REM *********************************************************************
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3060, 'Monitor 17/HR', 'CRT Monitor 17 inch (16 viewable) high resolution. Exceptional image performance and the benefit of additional screen space. This monitor offers sharp, color-rich monitor performance at an incredible value. With a host of leading features, including on-screen display controls.'
, 11, 102057, 10, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3057, 'Monitor 17/SD', 'CRT Monitor 17 inch (16 viewable) short depth. Delivers outstanding image clarity and precision. Gives professional color, technical engineering, and visualization/animation users the color fidelity they demand, plus a large desktop for enhanced productivity.'
, 11, 102051, 320, 'under development');