Overriding the variable character

[abrusko]

HI,

How do I override the variable character (&)
in a literal string in an insert statement?

Thx,
Andy

 

[D.]

Hi,

Only way is to SET DEFINE to something else.

Eg. SET DEFINE $

Then you use the '$' chanracter instead of '&' for variable substitution.

Cheers,
D.

 

[ScottMattes]

create table test( fld1 varchar2(30) );

insert into test values( 'asdf' );

insert into test values( '&fdsa' ); -- you get a prompt

insert into test values( '\&hello world' ); -- do do not get a prompt

 

[abrusko]

Great...thanks guys...Appreciate the help!

Andy