| sql loader URGENT! [message #74164] |
Fri, 24 September 2004 04:11 |
Jolanda
Messages: 68
Registered: September 2004
|
Member |
|
|
I have asked this question before, but it was misunderstood, so thats why I am posting it again!
I have a flat file which I want to process and insert in oracle database tables.
Every record in the file start with REC>,
something like:
number varchar2(4000) number
REC> 123 hello 456
REC> 124 "hello this is a long string, and that's why a carriage /CR return is used" 678
REC>
Is it possible to let sql loader know that it should ignore everything between " and " , because it is just a string and that the next record is the line which starts with REC>
I have read some documentation and this problem can be solved with logical and physical records using the CONTINUEIF statement, but till now I was not very succesfull.
Anyone had the same problem and knows the solution?
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
