| SQL Loader [message #53461] |
Mon, 23 September 2002 01:57  |
Nobby
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Guys
Can anyone help me with a SQL Loader Control script?
I have some data I want to load but I want it to skip the first column in the table which is a date. There is no date data. Is there a way of starting the insert from the second colum?
|
|
|
|
| Re: SQL Loader [message #53463 is a reply to message #53461] |
Mon, 23 September 2002 02:10  |
vikas
Messages: 29
Registered: November 2001
|
Junior Member |
|
|
pl. attach skip = 1 at the end of loader command statement. it will look like as
sqlldr username/pwd@string control=control.ctl skip=1.
it will skip the first record of the datafile.
regards
vikas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
