Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External Table BLANKS vs NULL

807294Oct 22 2010 — edited Oct 24 2010
Hi,

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
This post has been answered by Solomon Yakobson on Oct 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2010
Added on Oct 22 2010
6 comments
1,097 views