Skip to Main Content

Oracle Database Discussions

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!

Sql loader NULLIF problem

696876May 1 2009 — edited May 2 2009
hi i am trying to load data into a table in my warehouse and while doing so i am trying to set a nefault value for all blank fields. i am using the following command file

LOAD DATA
INFILE 'C:\APP\PENDO\ORADATA\TEST\dissertation.txt' "STR '\r\n'"
APPEND
INTO TABLE PENDO19.SSCUSTOMER1
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
CUSTID1 CHAR NULLIF (CUSTID1 = "unknown"),
CUSTNAME1 CHAR NULLIF (CUSTNAME1 = "unknown") ,
CUSTPHONE1 CHAR NULLIF (CUSTPHONE1 = "unknown"),
CUSTSTREET1 CHAR NULLIF (CUSTSTREET1 = "unknown"),
CUSTCITY1 CHAR NULLIF (CUSTCITY1 = "unknown"),
CUSTSTATE1 CHAR NULLIF (CUSTSTATE1 = "unknown"),
CUSTZIP1 CHAR NULLIF (CUSTZIP1 = "unknown"),
CUSTNATION1 CHAR NULLIF (CUSTNATION1 = "unknown")
)

the data is successfully loaded into the warehouse but without any transformation of null values.

Can anyone help me please

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2009
Added on May 1 2009
6 comments
8,999 views