Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> External table and null value
HI, I know that I can specify that when a column in the flat file of my
external table is missing, the column will have a null value. Is it
possible to issue a NVL(NULLCOLUMN, '000000') on that column at table
creation so the column instead of containing null values would contain
'000000'?
Here is my DDL script:
CREATE TABLE STG_CAR_PRODUCT_PRICE_T
(
PRODUCT_ID VARCHAR2(10 BYTE), ITEM_PRICE1 NUMBER(8,2), ITEM_PRICE1 NUMBER(8,2),
DEFAULT DIRECTORY Products ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"' MISSING FIELD VALUES ARE NULL ) LOCATION ('PRODUCT_FILE.dat')
Thank you,
Ccote
Received on Wed Jul 13 2005 - 08:27:50 CDT