-
I want to insert data in a table through SqlLoader and one field(Varchar2) contains data with carriage return.How can I insert the data with carriage return ?
I tried the options from Metalink but they are not working.
Can anybody please guide me ?
Thanks ,
Vasant
-
Can you strip carriage return off the field? It may be coded with ASCII control-M or one of these methods:
Dec Oct Hex Binary Description
013 015 0D 00001101 ^M ^m CR cr carriage-return c-M c-m \r
Use position statment to exclude carriage return.
-
I have a file at work that may help, but I will not be in work until Tuesday.