urgent reqirement [message #584713] |
Fri, 17 May 2013 01:13 |
|
ramyadavoracle@gmail.com
Messages: 22 Registered: May 2013 Location: Bangalore
|
Junior Member |
|
|
select * from patrun.amaprd where buy_nm like '%AT&T%';
select 'AT&T' from dual;
when ever run this query it will ask string value(&) if i enter this escape character(&) then only output will displayed otherwise the proper output will not displayed,but i want to no need to enter this escape character in the value option how to get this requirement,if any one knows please let me know this is urgent reqirement
[MERGED & MOVED by LF]
[Updated on: Fri, 17 May 2013 07:47] by Moderator Report message to a moderator
|
|
|
|
|
Re: urgent reqirement [message #584756 is a reply to message #584746] |
Fri, 17 May 2013 07:47 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It appears that it is a TOAD question, after all (so topic has been moved to our Client Tools forum).
In TOAD, right-click in Editor window and uncheck "Prompt for substitution variables".
|
|
|