Home » SQL & PL/SQL » Client Tools » In Toad Escape of "&" Character
In Toad Escape of "&" Character [message #271839] Wed, 03 October 2007 02:24 Go to next message
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

Re: In Toad Escape of "&" Character [message #271841 is a reply to message #271839] Wed, 03 October 2007 02:34 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: In Toad Escape of "&" Character [message #271842 is a reply to message #271839] Wed, 03 October 2007 02:44 Go to previous message
anil_sapra
Messages: 35
Registered: May 2006
Location: DELHI
Member

It worked..
Thank you very much Maaher.

Regards,

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


Current Time: Sun Dec 04 02:29:11 CST 2016

Total time taken to generate the page: 0.08155 seconds