ora8oledbscript.sql

LOB objects for oracle database,inserting them to database

3354, 'HD 12GB /I',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3072, 'HD 12GB /N',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3334, 'HD 12GB /R',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3071, 'HD 12GB /S',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2255, 'HD 12GB @7200 /SE',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1743, 'HD 18.2GB @10000 /E',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2382, 'HD 18.2GB@10000 /I',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3399, 'HD 18GB /SE',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3073, 'HD 6GB /I',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1768, 'HD 8.2GB @5400',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2410, 'HD 8.4GB @5400',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2257, 'HD 8GB /I',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3400, 'HD 8GB /SE',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3355, 'HD 8GB /SI',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1772, 'HD 9.1GB @10000',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2414, 'HD 9.1GB @10000 /I',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2415, 'HD 9.1GB @7200',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2243, 'Monitor 17/HR/F',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3065, 'Monitor 21/D',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3155, 'Monitor Hinge - HD',EMPTY_BLOB(), 'Monitor Hinge, heavy duty, maximum monitor weight 30 kg'
, 11, 102050, 42, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3234, 'Monitor Hinge - STD',EMPTY_BLOB(), 'Standard Monitor Hinge, maximum monitor weight 10 kg'
, 11, 102055, 34, 'under development'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2236, 'Plasma Monitor 10/TFT/XGA',EMPTY_BLOB(), '10 inch TFT XGA flatscreen monitor for laptop computers'
, 11, 102050, 863, 'planned'); 
INSERT INTO PRODUCT_INFORMATION ( PRODUCT_ID, PRODUCT_NAME,PRODUCT_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1782, 'Compact 400/DQ',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1792, 'Industrial 600/DQ',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2453, 'Inkjet C/4',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
3127, 'LaserPro 600/6/BW',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
2359, 'LCD Monitor 9/PM',EMPTY_BLOB(), '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_IMAGE, PRODUCT_DESCRIPTION, CATEGORY, SUPPLIER_ID, MIN_PRICE, PRODUCT_STATUS ) VALUES ( 
1726, 'LCD Monitor 11/PM',EMPTY_BLOB(), '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;



REM *********************************************************************
PROMPT Inserting Sample Data into PRODUCT_DESCRIPTIONS table and Commit 
REM *********************************************************************
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3054, '5', N'chr(Plasma Monitor 10/XGA)', N'chr(Monitor de 10 polegadas padr?o, resoluc?o XGA. Imagem com alta resoluc?o e possui imagem com intensidade de luz reduzida.)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
1782, '5', N'chr(Compact 400/DQ)', N'chr(Impressora com velocidade de 400 caracteres por segundo. Dimens?es: 17.34 x 24.26 x 26.32 polegadas. Interface: serial RS-232 (9 pinos) sem slots para expans?o. Tamanho de papel: A4, carta.)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2430, '5', N'chr(Compact 400/LQ)', N'chr(Impressora com velocidade de 400 caracteres por segundo, qualidade de carta. Dimens?es: 12.37 x 27.96 x 23.92 polegadas. Interface: serial RS-232 (25 pinos) com 3 slots para expans?o. Tamanho de papel: A2, A3, A4)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
1792, '5', N'chr(Industrial 600/DQ)', N'chr(mpressora com velocidade de 600 caracteres por segundo com maior numero de colunas. Dimens?es: 22.31 x 25.73 x 20.12 polegadas. Tamanho de papel: 3x5 polegadas a 11x17 polegas)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
1791, '5', N'chr(Industrial 700/HD)', N'chr(Impressora matricial com velocidade de 700 caracteres por segundo com protec?o contra poeira em caso de uso industrial. Interface: Centronics parallel, compativel com IEEE 1284. Tamanho de papel: 3x5 polegadas por 11x17 polegadas. Memoria: 4MB. Dimens?es:)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2302, '5', N'chr(Inkjet B/6)', N'chr(Impressora a jato de tinta, preto e branco, 6 paginas por minuto, resoluc?o de 600x300 dpi. Interface: Centronics parallel, compativel com IEEE 1284. Dimens?es: 7.3 x 17.5 x 14 polegas. Tamanho de papel: A3, A4. Sem slots para expans?o)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2453, '5', N'chr(Inkjet C/4)', N'chr(Impressora a jato de tinta, colorida (com dois cartuchos de tinta separados), 6 paginas por minuto em preto e branco e 4 paginas por minuto coloridas, resoluc?o de 600x300 dpi. Interface: compativel com Biodirectional IEEE 1284 e saida serial RS-232 (9 pi)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
1797, '5', N'chr(Inkjet C/8/HQ)', N'chr(Impressora a jato de tinta, colorida, 8 paginas por minuto, alta resoluc?o (qualidade de foto). Memoria: 16MB. Dimens?es: 7.3 x 17.5 x 14 polegadas. Tamanho de papel: A4, carta, envelope. Interface: Centronics parallel, compativel com IEEE 1284)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2459, '5', N'chr(LaserPro 1200/8/BW)', N'chr(Impressora a laser, branco e preto, profissional, resoluc?o de 1200 dpi, 8 paginas por segundo. Dimens?es: 22.37 x 19.86 x 21.92 polegadas. Software: drive compativel com SPNIX v4.0.) '); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3127, '5', N'chr(LaserPro 600/6/BW)', N'chr(Impressora a laser, branco e preto, padr?o, resoluc?o de 600 dpi, 6 paginas por segundo. Interface: Centronics parallel, compativel com IEEE 1284. Memoria: 8MB 96 KB de buffer de recebimento.  Utilitarios MS-DOS ToolBox compativel com SPINIX Auto CAM v.17)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2254, '5', N'chr(HD 10GB /I)', N'chr(isco rigido de 10GB (interno). E destinado a ambientes com dados criticos e s?o ideais para uso com RAID.)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3353, '5', N'chr(HD 10GB /R)', N'chr(Disco rigido removivel de 10GB. Os drives Supra7 proveem a mais recente tecnologia em termos de desempenho, aumentando a taxa de tranferencia para ate 160MB/s.)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3069, '5', N'chr(HD 10GB /S)', N'chr(isco rigido de 10GB. Compativel com sistemas Supra5. Os drives Supra eliminam o risco de incompatibilidade de firmware)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
2253, '5', N'chr(HD 10GB @5400 /SE)', N'chr(Disco rigido de 10GB (externo) interface SCSI, 5400 RPM. Os drives Supra eliminam o risco de incompatibilidade de firmware.)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3354, '5', N'chr(HD 12GB /I)', N'chr(isco rigido de 12GB (interno). Os drives Supra eliminam o risco de incompatibilidade de firmware. Compativel com vers?es anteriores. Possibilita a existencia de dispositivos Supra2 com Supra3 para soluc?es otimizadas e futuro crescimento)'); 
INSERT INTO PRODUCT_DESCRIPTIONS ( PRODUCT_ID, LANGUAGE_ID, TRANSLATED_NAME, TRANSLATED_DESCRIPTION ) VALUES ( 
3072, '5', N'chr(HD 12GB /N)', N'chr(isco rigido de 12Gb. Supra9 prove mecanismos que possibilitam a instalac?o e remoc?o de drives de modo on-line. Satisfaz padr?es de confiabilidade e performance)'); 
commit;

SET SCAN OFF