OraFAQ Forum: Client Tools » escape/quote Ampersand (&) because no variable substitution

Home » Other » Client Tools » escape/quote Ampersand (&) because no variable substitution

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

escape/quote Ampersand (&) because no variable substitution [message #502275]

Tue, 05 April 2011 09:26

oranooob
Messages: 88
Registered: May 2009

Member

Hi

I wish to replace the string "Benutzername&Kontakt" with nothing.

SELECT REPLACE (role_owner, 'Benutzername&Kontakt', '')
  FROM JC_NAME_62
 WHERE jc_name LIKE 'SAP_R4_BIN5\_%' ESCAPE '\'

But my Toad prompts me always to fill in the variable. I don't wish to do that, I wish to escape the &

Report message to a moderator

Re: escape/quote Ampersand (&) because no variable substitution [message #502277 is a reply to message #502275]

Tue, 05 April 2011 09:29

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

There will be a setting in TOADs preferences somewhere to switch that off.
Otherwise you could use the chr function to put the & in. TOAD won't notice that way.

Report message to a moderator

Re: escape/quote Ampersand (&) because no variable substitution [message #502280 is a reply to message #502277]

Tue, 05 April 2011 09:38

oranooob
Messages: 88
Registered: May 2009

Member

thanks

Does this means the same SQL would work in SQLplus? Its only a toad problem?

Report message to a moderator

Re: escape/quote Ampersand (&) because no variable substitution [message #502281 is a reply to message #502280]

Tue, 05 April 2011 09:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Does this means the same SQL would work in SQLplus? Its only a toad problem?
what happens when you actually try it YOURSELF?

Report message to a moderator

Re: escape/quote Ampersand (&) because no variable substitution [message #502299 is a reply to message #502280]

Tue, 05 April 2011 11:09

Michel Cadot
Messages: 68510
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

oranooob wrote on Tue, 05 April 2011 16:38

thanks

Does this means the same SQL would work in SQLplus? Its only a toad problem?

Yes.

Regards
Michel

Report message to a moderator

Re: escape/quote Ampersand (&) because no variable substitution [message #502356 is a reply to message #502299]

Wed, 06 April 2011 01:35

Littlefoot
Messages: 21783
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As of the original question: the answer might depend on TOAD version, but - generally - you should right-click in the Editor window and set (or not) the "Prompt for substitution variables" mark.

Report message to a moderator

Previous Topic:	how to execute stored Procedure with cursor with in pl/sql
Next Topic:	Having multiple input values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 02 19:00:42 CDT 2023