Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Row Terminator in SQL*Loader
Hi Anybody,
I have to load large memo field(s) data from SQL Server to Oracle 7.3 these memo fields have all sorts of character in them including linefeed and carriage return. When SQL Server exports the data, one can specify a ROW TERMINATOR. How can we specify ROW TERMINATOR in .CTL file of SQL*LOADER.
If SQL*LOADER does not have concept of row terminator, then how does one load large text fields with linefeed and carriage returns.
Thanks Received on Thu Jun 11 1998 - 08:38:13 CDT