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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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 - extra field in data file, but need to use its value for another field
Next Topic: SQL Loader query
Goto Forum:
  


Current Time: Mon Dec 23 19:58:06 CST 2024