| sql*loader [message #69073] |
Wed, 24 October 2001 06:36  |
Dev
Messages: 28
Registered: May 2001
|
Junior Member |
|
|
There are 4 columns in table, but the data file gives value for 5 columns, i want to ignore the value of second column and load only 1,3,4 & 5 FROM the data file. Does any one know how to do this. This is a delimited data file
----------------------------------------------------------------------
|
|
|
|
| Re: sql*loader [message #69074 is a reply to message #69073] |
Wed, 24 October 2001 07:43  |
Tom Sullivan
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
Use the FILLER keyword. For example:
load data
infile 'emps.dat'
into table emp truncate
fields terminated by ","
(emp,deptno FILLER,ename,sal)
HTH...Tom
----------------------------------------------------------------------
|
|
|
|
| Re: sql*loader [message #69092 is a reply to message #69074] |
Sun, 28 October 2001 17:56 |
diaz
Messages: 58
Registered: October 2001
|
Member |
|
|
hmmm.. i still don't understand bout the FILLER thing.. can you give some explanation pls ?
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
