sql loader - insert records base on condition. [message #73554] |
Thu, 20 May 2004 19:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ELok
Messages: 5 Registered: November 1998
|
Junior Member |
|
|
Dear All,
I have a plain text file which show records like this:
20040519;;
33333333
22222222
00000002;;
How can I write up the control file properly to insert only those record without ";;" to table?
TIA.
Regards,
Wandy
|
|
|
Re: sql loader - insert records base on condition. [message #73557 is a reply to message #73554] |
Fri, 21 May 2004 04:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/43710.gif) |
Barbara Boehmer
Messages: 9097 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
What datatype is the column in the table that you are loading into? If it is a number datatype, then the non-numeric values containing ; will automatically be rejected. If it is a varchar2 datatype, then you could load all of the data, then delete the values containing ;.
|
|
|