We try to generate csv file from table: V_SR01_LAYER_REV which have:
select SPECFILE ||','|| SPEC_REV ||','|| CUSTOMER_DEVICE || ',' || CHIP_CODE ||',' || LAYER_NO ||',' || SCANNER_FILE || ',' || REV || ','|| TOOL || ',' || BARCODE ||',' || XXX_MASK_VISINSP || ',' || PRIME_DIE_REV || ',' || CREATE_DATE || ',' || FIELD_LOCATION from V_SR01_LAYER_REV
We need to generat csv file base on CHIP_CODE.
Below show the example:
select * from V_SR01_LAYER_REV where CHIP_CODE = '12B3';
All the output will be keep in the filename: 12B2.csv as csv format.
The real problem now, this table have Output: 819 chip code;
select count(DISTINCT CHIP_CODE) from V_SR01_LAYER_REV order by CHIP_CODE;
How can we write the script generate it weekly?
