OraFAQ Forum: Client Tools » In Toad Escape of "&" Character

Home » Other » Client Tools » In Toad Escape of "&" Character

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

In Toad Escape of "&" Character [message #271839]

Wed, 03 October 2007 02:24

anil_sapra
Messages: 35
Registered: May 2006
Location: DELHI

Member

Hi Masters,

I am using Toad. In some of my sql statements i have to use
"&" character for comparision of Fields.
For Example :-

SELECT * from table where col1 = 'F&A';

It asks values for "A". I want to escape this situation.

Pl. help me how to handle in Toad.

Regards,

Anil

Report message to a moderator

Re: In Toad Escape of "&" Character [message #271841 is a reply to message #271839]

Wed, 03 October 2007 02:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

* Right click in the editor and uncheck the "Prompt for substitution variables" option.

* Menu view-->toad options: go to the "execute/compile" node and uncheck the "Prompt for substitution variables" option.

MHE

Report message to a moderator

Re: In Toad Escape of "&" Character [message #271842 is a reply to message #271839]

Wed, 03 October 2007 02:44

anil_sapra
Messages: 35
Registered: May 2006
Location: DELHI

Member

It worked..
Thank you very much Maaher.

Regards,

Anil

Report message to a moderator

Previous Topic:	Tora on open suse 10.2
Next Topic:	SQL Developer Issue: DELETE key stopped working?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 09:12:59 CST 2025