How to handle NULLs in external tables
Hi all,
I have the following tab-delimited data in my comps.txt file:
The following external table was created against the file:
I have the following tab-delimited data in my comps.txt file:
1 31 248161 "Company1"
2 31 248221 "Company2"
2 31 248301 "Company3"
248323 "Company4"
248403 "Company5"
1 "12" 248406 Company6
The following external table was created against the file:
CREATE TABLE EXT_COMPS ( C1 VARCHAR2(100 BYTE), C2 VARCHAR2(100 BYTE), C3 VARCHAR2(100 BYTE), C4 VARCHAR2(100 BYTE) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY MYDIR ACCESS PARAMETERS ( records delimited by newline badfile MYDIR:'COMPS%a_%p.bad' logfile MYDIR:'COMPS%a_%p.log' fields terminated by 0x'09' OPTIONALLY ENCLOSED BY '"' missing field values are null ( C1 CHAR, C2 CHAR , C3 CHAR , C4 CHAR) ) LOCATION (MYDIR:'comps.txt') ) REJECT LIMIT UNLIMITED
0