External Table BLANKS vs NULL
807294Oct 22 2010 — edited Oct 24 2010Hi,
I need help. I create an external table with load when condition and most of the data appears in the external table except for those with COL1 that is blanks/null.
First row is not in external table that make sense.
However, why second row is not in external table? How to make it available in external table? I used load when col1=BLANKS but no record.
CSV file
abc,1,2,3
,2,3,4
vdb,1,2,3
qwe,1,2,3
CREATE TABLE TEST
(COL1 VARCHAR2(50),
COL2 VARCHAR2(50),
COL3 VARCHAR2(50),
COL4 VARCHAR2(50))
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER DEFAULT DIRECTORY "INPUTS_DIR" ACCESS PARAMETERS (
RECORDS DELIMITED BY '\r\n' LOAD WHEN
(
COL1 != 'abc'
)
NOBADFILE NOLOGFILE NODISCARDFILE FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"'
AND '"')
LOCATION ( 'test1.csv' )
)
REJECT LIMIT UNLIMITED;
Thanks,
AL