Home » RDBMS Server » Server Utilities » to accept the column which has newline character into the table using sql loader
to accept the column which has newline character into the table using sql loader [message #190820] Fri, 01 September 2006 07:23
deepti_07
Messages: 13
Registered: January 2006
Junior Member
Hi,

I have my input file as

362921|JUSTIN Master Servi|INSTALL|

362857|LAURA Master Service|INSTALL|

364141|SIMI
Master Service Call|INSTALL|

364199|KEAN
Master Service Call Nu|INSTALL|

364250|JERRY
Master Service|INSTALL|

As one can see that, the last three records have the second
column with an embedded newline character.

Can someone help me to build the sql control file such that it
will load the second column even if it has a newline character embedded?

Thanks in advance

Deepti


Previous Topic: Loading 3,500,000 records
Next Topic: imp from 9i to 8i
Goto Forum:
  


Current Time: Sat Dec 03 12:09:38 CST 2016

Total time taken to generate the page: 0.09135 seconds