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: exporting big table
Next Topic: where can i find other loading tools?
Goto Forum:
  


Current Time: Wed Aug 23 10:43:38 CDT 2017

Total time taken to generate the page: 0.01658 seconds