Home » RDBMS Server » Server Utilities » How to write set define off statement in control file of sqldr
How to write set define off statement in control file of sqldr [message #378872] Fri, 02 January 2009 03:56 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi,

I need to insert data which contains '&' as values. So need to set set define off in control file.


set define off
load data
infile 'c:\data1.dat' 
append into table log_temp
fields terminated by ","
trailing nullcols
(
name1 ,
name2
)
set define on




Here below is my control file.

Any help really appreciated.

Thanks in advance
Re: How to write set define off statement in control file of sqldr [message #378877 is a reply to message #378872] Fri, 02 January 2009 04:05 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SqL*Loader don't care of &.
"set define" is a SQL*Plus command, it is needed because & is meaningful for SQL*Plus, not for SQL*Loader.

Regards
Michel
Previous Topic: SQL Loader query
Next Topic: Error while exporting
Goto Forum:
  


Current Time: Sun Aug 20 14:23:32 CDT 2017

Total time taken to generate the page: 0.00665 seconds