Search code examples
sqlplsqltoad

How to escape ampersand in TOAD?

When I try to insert a value which has '&' in TOAD I get a prompt for a substitution variable.

So when I try:

insert into x values('hello & world');

it throws a prompt for substituting the variable 'world'.

I have tried right clicking in the editor and disabling prompt for substitution variables but this seems to work only for Execute Statement (F9) It doesn't work for Execute as script(F5).

I am also aware of using chr(38) like:

insert into x values('hello '||chr(38)||'world');

but I do not want this. Is there something else that will help me run the script?

Solution

  • Try putting set define off at the beginning of your script. It should work with F5:

    set define off;
insert into x values('hello & world'); 
set define on;