ora7oledbscript.sql

LOB objects for oracle database,inserting them to database

INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3061, 'Monitor 19/SD', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2245, 'Monitor 19/SD/M', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3331, 'Monitor 21/HR', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2252, 'Monitor 21/HR/M', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3064, 'Monitor 21/SD', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3350, 'Plasma Monitor 10/LE/VGA', '10 inch low energy plasma monitor, VGA resolution'
, 11, 102053, 630, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3054, 'Plasma Monitor 10/XGA', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2430, 'Compact 400/LQ', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1791, 'Industrial 700/HD', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2302, 'Inkjet B/6', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1797, 'Inkjet C/8/HQ', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2459, 'LaserPro 1200/8/BW', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2254, 'HD 10GB /I', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3353, 'HD 10GB /R', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3069, 'HD 10GB /S', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2253, 'HD 10GB @5400 /SE', '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_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3354, 'HD 12GB /I', '12GB capacity harddisk drive (internal). Supra drives eliminate the risk of firmware incompatibility. Backward compatibility: You can mix or match Supra2 and Supra3 devices for optimized solutions and future growth.'
, 13, 102053, 478, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3072, 'HD 12GB /N', '12GB hard disk drive for Narrow Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.'
, 13, 102053, 507, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3334, 'HD 12GB /R', '12GB Removable hard disk drive. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity. Supra7 Universal disk drives are the second generation of high performance hot plug drives sharing compatibility across corporate servers and external storage enclosures.'
, 13, 102050, 512, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3071, 'HD 12GB /S', '12GB hard disk drive for Standard Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.'
, 13, 102055, 553, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2255, 'HD 12GB @7200 /SE', '12GB capacity hard disk drive (external) SCSI, 7200 RPM. These drives are intended for use in today''s demanding, data-critical enterprise environments and can be used 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, 102051, 628, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1743, 'HD 18.2GB @10000 /E', 'External hard drive disk - 18.2 GB, rated up to 10,000 RPM. These drives are intended for use in today''s demanding, data-critical enterprise environments and are ideal for use in RAID applications.'
, 13, 102055, 661, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2382, 'HD 18.2GB@10000 /I', '18.2 GB SCSI hard disk @ 10000 RPM (internal). Supra7 Universal disk drives provide an unequaled level of investment protection and simplification for customers by enabling drive compatibility across many enterprise platforms.'
, 13, 102051, 731, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3399, 'HD 18GB /SE', '18GB SCSI external hard disk drive. Supra5 Universal hard disk drives provide the ability to hot plug between various servers, RAID arrays, and external storage shelves.'
, 13, 102057, 706, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3073, 'HD 6GB /I', '6GB capacity hard disk drive (internal). Supra drives eliminate the risk of firmware incompatibility.'
, 13, 102055, 197, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1768, 'HD 8.2GB @5400', 'Hard drive disk - 8.2 GB, rated up to 5,400 RPM. Supra drives eliminate the risk of firmware incompatibility. Standard serial RS-232 interface.'
, 13, 102050, 306, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2410, 'HD 8.4GB @5400', '8.4 GB hard disk @ 5400 RPM. Reduced cost of ownership: Drives can be utilized across enterprise platforms. This hot pluggable hard disk drive is required to meet your rigorous standards for reliability and performance.'
, 13, 102053, 319, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2257, 'HD 8GB /I', '8GB capacity hard disk drive (internal). Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Backward compatibility: You can mix Supra2 and Supra3 devices for optimized solutions and future growth.'
, 13, 102053, 338, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3400, 'HD 8GB /SE', '8GB capacity SCSI hard disk drive (external). Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 255MB/s.'
, 13, 102053, 337, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3355, 'HD 8GB /SI', '8GB SCSI hard disk drive, internal. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity. '
, 13, 102051, 314, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1772, 'HD 9.1GB @10000', 'Hard disk drive - 9.1 GB, rated up to 10,000 RPM. These drives are intended for use in data-critical enterprise environments. Ease of doing business: you can easily select the drives you need regardless of the application in which they will be deployed.'
, 13, 102055, 393, 'obsolete'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2414, 'HD 9.1GB @10000 /I', '9.1 GB SCSI hard disk @ 10000 RPM (internal). Supra7 disk drives are available in 10,000 RPM spindle speeds and capacities of 18GB and 9.1 GB. SCSI and RS-232 interfaces.'
, 13, 102050, 399, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2415, 'HD 9.1GB @7200', '9.1 GB hard disk @ 7200 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.'
, 13, 102053, 309, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2243, 'Monitor 17/HR/F', 'Monitor 17 inch (16 viewable) high resolution, flat screen. High density photon gun with Enhanced Elliptical Correction System for more consistent, accurate focus across the screen, even in the corners.'
, 11, 102053, 302, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3065, 'Monitor 21/D', 'CRT Monitor 21 inch (20 viewable). Digital OptiScan technology: supports resolutions up to 1600 x 1200 at 75Hz. Dimensions (HxWxD): 8.3 x 18.5 x 15 inch. The detachable or attachable monitor-powered Platinum Series speakers offer crisp sound and the convenience of a digital audio player jack. Just plug in your digital audio player and listen to tunes without powering up your PC.'
, 11, 102051, 875, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3155, 'Monitor Hinge - HD', 'Monitor Hinge, heavy duty, maximum monitor weight 30 kg'
, 11, 102050, 42, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3234, 'Monitor Hinge - STD', 'Standard Monitor Hinge, maximum monitor weight 10 kg'
, 11, 102055, 34, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2236, 'Plasma Monitor 10/TFT/XGA', '10 inch TFT XGA flatscreen monitor for laptop computers'
, 11, 102050, 863, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1782, 'Compact 400/DQ', '400 characters per second high-speed draft printer. Dimensions (HxWxD): 17.34 x 24.26 x 26.32 inch. Interface: RS-232 serial (9-pin), no expansion slots. Paper size: A4, US Letter.'
, 12, 102057, 108, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1792, 'Industrial 600/DQ', 'Wide carriage color capability 600 characters per second high-speed draft printer. Dimensions (HxWxD): 22.31 x 25.73 x 20.12 inch. Paper size: 3x5 inch to 11x17 inch full bleed wide format.'
, 12, 102057, 180, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2453, 'Inkjet C/4', 'Inkjet Printer, color (with two separate ink cartridges), 6 pages per minute black and white, 4 pages per minute color, resolution 600x300 dpi. Interface: Biodirectional IEEE 1284 compliant parallel interface and RS-232 serial (9-pin) interface 2 open EIO expansion slots. Memory: 8MB 96KB receiver buffer.'
, 12, 102050, 174, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3127, 'LaserPro 600/6/BW', 'Standard black and white laserprinter, resolution 600 dpi, 6 pages per second. Interface: Centronics parallel, IEEE 1284 compliant. Memory: 8MB 96KB receiver buffer. MS-DOS ToolBox utilities for SPNIX AutoCAM v.17 compatible driver.'
, 12, 102057, 444, 'orderable'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2359, 'LCD Monitor 9/PM', 'Liquid Cristal Display 9 inch passive monitor. Enjoy the productivity that a small monitor can bring via more workspace on your desk. Easy setup with plug-and-play compatibility.'
, 11, 102053, 206, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1726, 'LCD Monitor 11/PM', 'Liquid Cristal Display 11 inch passive monitor. The virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.'
, 11, 102053, 122, 'under development'); 
commit;

SET SCAN OFF