OraFAQ Forum: Client Tools » urgent reqirement

Home » Other » Client Tools » urgent reqirement (TOAD10G)

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

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 #584714 is a reply to message #584713]

Fri, 17 May 2013 01:16

Littlefoot
Messages: 21823
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>

Report message to a moderator

Re: urgent reqirement [message #584746 is a reply to message #584713]

Fri, 17 May 2013 06:59

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

set define off

Report message to a moderator

Re: urgent reqirement [message #584756 is a reply to message #584746]

Fri, 17 May 2013 07:47

Littlefoot
Messages: 21823
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".

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:13:21 CST 2025