| creating control file [message #355817] |
Mon, 27 October 2008 13:56  |
sai1
Messages: 3
Registered: October 2008
|
Junior Member |
|
|
Hi
My input file's each record looks like this 1@123@23@
or
1@123@@23
Now i have to sqlload the file contents to a table of 4 columns
I created a control file which does that :
LOAD DATA
INFILE LOAD.txt'
INSERT
INTO TABLE apple
FIELDS TERMINATED BY "@"
(SNo,Count,Value,Text_Value)
When i sqlload it is loading all the records which look like this 1@123@@23
that means its inserting values into columns SNo , Count and Text_Value
But if my input record is 1@123@23@ it is not loading this record to my table
what should i correct in my control file to load all the records which look like the above mentioned ones.
thanks
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
