CODEWITHSUNDEEP
sqlplsqltoad
Utham Radipe
Utham Radipe

Reputation: 343

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?

Upvotes: 24

Views: 50491

Answers (4)

LNM
LNM

Reputation: 1

I use toad 16.1 and disabling on editor "Substitution Variable Prompting = none" works all the time

Upvotes: 0

Sujeet
Sujeet

Reputation: 121

In TOAD version 12.120.39 Right click in Editor and Click in Substitution Variable Prompting and select none

This worked for me.

Upvotes: 12

uffa14
uffa14

Reputation: 165

set define off doesn't work in TOAD just in sqlplus.

You can disable substitution variable support by right-clicking in the Editor and unchecking the “Prompt for Substitution Variables” item. It works with F9 execution but not with F5 (script) execution. With F5 you need to add "set define off" in the first line then launch with F5!! (hope this help it was very hard to find for me)

Upvotes: 8

Andrea
Andrea

Reputation: 12355

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;

Upvotes: 37

Related Questions