OraFAQ Forum: SQL & PL/SQL » NULL column value loading in sql loader

Home » SQL & PL/SQL » SQL & PL/SQL » NULL column value loading in sql loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NULL column value loading in sql loader [message #2127]

Sun, 23 June 2002 13:47

PANKAJ
Messages: 24
Registered: June 2001

Junior Member

Hi,

I have a table of single column NAME. I want to load rows through sql loader. some records contains NULL values.
To load these values I wrote control file as follows.

LOAD DATA
INFILE 'ETS.DAT'
BADFILE 'ETS.BAD'
INTO TABLE ETS
(NAME CHAR(01:60) NULLIF name=BLANKS)

When I tried to load still NULL rows are not loaded.
Can anybody help me.
Thanks

Report message to a moderator

Re: NULL column value loading in sql loader [message #2128 is a reply to message #2127]

Sun, 23 June 2002 14:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Im not very sure, anyhow try this syntax

LOAD DATA
INFILE 'ETS.DAT'
BADFILE 'ETS.BAD'
INTO TABLE ETS
(name  POSITION(01:60) Char NULLIF name=BLANKS)

Report message to a moderator

Previous Topic:	what is the NOLOGGING effect on Table
Next Topic:	ORA-01031: insufficient privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 12:38:32 CDT 2024