SQL LOAD [message #452763] |
Fri, 23 April 2010 18:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
singhabm
Messages: 4 Registered: July 2007 Location: India
|
Junior Member |
|
|
Hi All,
I have a file with 5 columns like:
001 David 40 1234567 RTS
002 Franc 20 999889 MBQ
003 Ralph 30 8876599 ITD
I have to load this file into table which has only four columns
which are:
describe emp
name varchar2 (25),
deptno number,
lan_number number (10),
Irc_code varchar2 (20)
So for this I have to remove the first columns from the file.
Is there any way I can do it by using sql loader?
What condition should I specify in control file ?
I think for using filler, column name must be specified.
Please reply and thanks in advance.
|
|
|
|
|
Re: SQL LOAD [message #452820 is a reply to message #452765] |
Sat, 24 April 2010 23:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
singhabm
Messages: 4 Registered: July 2007 Location: India
|
Junior Member |
|
|
Hi,
Thanks for the quick reply..
i have a concern that by adding
filler_1 filler
in my control file, do i have to alter my table.
because my table emp has 4 columns but file has 5 columns.
Please reply
|
|
|
|
|
Re: SQL LOAD [message #452993 is a reply to message #452820] |
Mon, 26 April 2010 13:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
singhabm wrote on Sun, 25 April 2010 00:34Hi,
Thanks for the quick reply..
i have a concern that by adding
filler_1 filler
in my control file, do i have to alter my table.
because my table emp has 4 columns but file has 5 columns.
Please reply
I would re-read Barbara's post. It should be clear.
|
|
|
Re: SQL LOAD [message #453026 is a reply to message #452993] |
Mon, 26 April 2010 14:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Gee, it literally takes a few minutes to perform that test. There's really no need to be worried about it or have doubts as it is just too freaking simple to try it.
I wonder if that silly "Yes" vote scared the OP away from filler.
|
|
|