PL/SQL - How to handle &

[wellster34]

Hi,

In PL/SQL, the & is used to a variable holder. So, if you tried to make a variable like:

test_tx := 'Test one & two';

it asks for the value of two when trying to execute the code.


Is there a way to make PL/SQL accept the text as is? So, basically ignoring the & so that the text keeps its original value?


Thanks for your time.

 

[wellster34]

I found a solution:

SET ESCAPE ON
SET ESCAPE "\"
test_tx := 'Test one \& two';


It works!!! yeah.

 

[SantaMufasa]

Wellster,

Another method (which I prefer) is

set define off

...then you do not need to "escape" your data.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.