Home » SQL & PL/SQL » Client Tools » urgent reqirement (TOAD10G)
urgent reqirement [message #584713] Fri, 17 May 2013 01:13 Go to next message
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 #584714 is a reply to message #584713] Fri, 17 May 2013 01:16 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is, most probably, not a Forms question, is it? Therefore, I'm moving it into our SQL forum. If you use some other tool, say so.
SQL> select 'AT&T' from dual;
Enter value for t:

'A
--
AT

SQL> set define off
SQL> /

'AT&
----
AT&T

SQL>
Re: urgent reqirement [message #584746 is a reply to message #584713] Fri, 17 May 2013 06:59 Go to previous messageGo to next message
Roachcoach
Messages: 1198
Registered: May 2010
Location: UK
Senior Member
set define off
Re: urgent reqirement [message #584756 is a reply to message #584746] Fri, 17 May 2013 07:47 Go to previous message
Littlefoot
Messages: 19525
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".
Previous Topic: Where does DBMS_OUTPUT.PUT_LINE() output go (in Toad) ?
Next Topic: Number Data Type Column does not display number as it was entered
Goto Forum:
  


Current Time: Sat Aug 30 03:41:06 CDT 2014

Total time taken to generate the page: 0.21040 seconds