ora8oledbscript.sql

LOB objects for oracle database,inserting them to database

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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3060, 'Monitor 17/HR',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3057, 'Monitor 17/SD',EMPTY_BLOB(), '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'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3061, 'Monitor 19/SD',EMPTY_BLOB(), 'CRT Monitor 19 inch (18 viewable) short depth. High-contrast black screen coating: produces superior contrast and grayscale performance. The newly designed, amplified professional speakers with dynamic bass response bring all of your multimedia audio experiences to life with crisp, true-to-life sound and rich, deep bass tones. Plus, color-coded cables, simple plug-and-play setup and digital on-screen controls mean you are ready to set your sights on outrageous multimedia and the incredible Internet in just minutes.'
, 11, 102050, 23, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2245, 'Monitor 19/SD/M', EMPTY_BLOB(),'Monitor 19 (18 Viewable) short depth, Monochrome. Outstanding image performance in a compact design. A simple, on-screen dislay menu helps you easily adjust screen dimensions, colors and image attributes. Just plug your monitor into your PC and you are ready to go.'
, 11, 102051, 422, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3331, 'Monitor 21/HR', EMPTY_BLOB(), '21 inch monitor (20 inch viewable) high resolution. This monitor is ideal for business, desktop publishing, and graphics-intensive applications. Enjoy the productivity that a large monitor can bring via more workspace for running applications.'
, 11, 102057, 785, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2252, 'Monitor 21/HR/M',EMPTY_BLOB(), 'Monitor 21 inch (20 viewable) high resolution, monochrome. Unit size: 35.6 x 29.6 x 33.3 cm (14.6 kg) Package: 40.53 x 31.24 x 35.39 cm (16.5 kg). Horizontal frequency 31.5 - 54 kHz, Vertical frequency 50 - 120 Hz. Universal power supply 90 - 132 V, 50 - 60 Hz.'
, 11, 102055, 715, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3064, 'Monitor 21/SD',EMPTY_BLOB(), 'Monitor 21 inch (20 viewable) short depth. Features include a 0.25-0.28 Aperture Grille Pitch, resolution support up to 1920 x 1200 at 76Hz, on-screen displays, and a conductive anti-reflective film coating.'
, 11, 102050, 909, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3350, 'Plasma Monitor 10/LE/VGA',EMPTY_BLOB(), '10 inch low energy plasma monitor, VGA resolution'
, 11, 102053, 630, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3054, 'Plasma Monitor 10/XGA',EMPTY_BLOB(), '10 inch standard plasma monitor, XGA resolution. This virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.'
, 11, 102053, 519, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2430, 'Compact 400/LQ',EMPTY_BLOB(), '400 characters per second high-speed letter-quality printer. Dimensions (HxWxD): 12.37 x 27.96 x 23.92 inch. Interface: RS-232 serial (25-pin), 3 expansion slots. Paper size: A2, A3, A4.'
, 12, 102057, 143, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1791, 'Industrial 700/HD',EMPTY_BLOB(), '700 characters per second dot-matrix printer with harder body and dust protection for industrial uses. Interface: Centronics parallel, IEEE 1284 compliant. Paper size: 3x5 inch to 11x17 inch full bleed wide format. Memory: 4MB. Dimensions (HxWxD): 9.3 x 16.5 x 13 inch.'
, 12, 102057, 239, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2302, 'Inkjet B/6',EMPTY_BLOB(), 'Inkjet Printer, black and white, 6 pages per minute, resolution 600x300 dpi. Interface: Centronics parallel, IEEE 1284 compliant. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A3, A4, US legal. No expansion slots.'
, 12, 102050, 121, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1797, 'Inkjet C/8/HQ',EMPTY_BLOB(), 'Inkjet printer, color, 8 pages per minute, high resolution (photo quality). Memory: 16MB. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A4, US Letter, envelopes. Interface: Centronics parallel, IEEE 1284 compliant.'
, 12, 102050, 288, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2459, 'LaserPro 1200/8/BW',EMPTY_BLOB(), 'Professional black and white laserprinter, resolution 1200 dpi, 8 pages per second. Dimensions (HxWxD): 22.37 x 19.86 x 21.92 inch. Software: Enhanced driver support for SPNIX v4.0; MS-DOS Built-in printer drivers: ZoomSmart scaling technology, billboard, handout, mirror, watermark, print preview, quick sets, emulate laserprinter margins.'
, 12, 102050, 568, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2254, 'HD 10GB /I',EMPTY_BLOB(), '10GB capacity hard disk drive (internal). These drives are intended for use in today''s demanding, data-critical enterprise environments and are ideal for use in RAID applications. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.'
, 13, 102055, 371, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3353, 'HD 10GB /R',EMPTY_BLOB(), '10GB Removable hard disk drive for 10GB Removable HD drive. Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 160MB/s.'
, 13, 102055, 413, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3069, 'HD 10GB /S',EMPTY_BLOB(), '10GB hard disk drive for Standard Mount. Backward compatible with Supra5 systems, users are free to deploy and re-deploy these drives to quickly deliver increased storage capacity. Supra drives eliminate the risk of firmware incompatibility.'
, 13, 102051, 350, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2253, 'HD 10GB @5400 /SE',EMPTY_BLOB(), '10GB capacity hard disk drive (external) SCSI interface, 5400 RPM. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system. Supra drives eliminate the risk of firmware incompatibility.'
, 13, 102053, 322, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES (