| sql loader - insert records base on condition. [message #73554] |
Thu, 20 May 2004 19:45  |
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  |
 |
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 ;.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
