Help about Sql loader [message #275632] |
Mon, 22 October 2007 02:43 |
balaji23_d
Messages: 123 Registered: February 2007
|
Senior Member |
|
|
hi,
I have one doubt
This is my script
LOAD DATA
INFILE 'COSTCENTER.TXT'
REPLACE
INTO TABLE OMF_API_COSTCENTER
(CCN_CODE POSITION(1:30),
CCN_DESC POSITION(31:60),
CCN_LINE_OF_BUS_CD POSITION(61:90)"nvl(:ccn_line_of_bus_cd,NULL)",
CCN_LINE_OF_BUS_DESC POSITION(91:120),
CST_ID POSITION(121:135) "CSTCEN_SEQNUM.nextval"
After run this script in Unix environment, I got one error
"Expecting valid column specification, "," or ")", found end of file.
I want to insert the nulls whereever the no values in table
please help this query
|
|
|
|
|