OraFAQ Forum: Client Tools

Home » Other » Client Tools » REPLACE (9i)

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

REPLACE [message #487070]

Wed, 22 December 2010 06:09

vishalk
Messages: 33
Registered: October 2010

Member

Hi..
I want replace '&' with any character.
But when i use '&' in select statement.
then it ask the value.
any one can help.
how it can be solve.

Report message to a moderator

Re: REPLACE [message #487071 is a reply to message #487070]

Wed, 22 December 2010 06:27

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Lookup SET DEFINE OFF

Report message to a moderator

Re: REPLACE [message #487075 is a reply to message #487071]

Wed, 22 December 2010 07:16

vishalk
Messages: 33
Registered: October 2010

Member

it work.
but i want run in toad.
it is possible or not?

Report message to a moderator

Re: REPLACE [message #487076 is a reply to message #487075]

Wed, 22 December 2010 07:20

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

I doon't use toad, but it took me less than 1 minute to find the answer on google. I'll give you a hint, you want to find out how to SET DEFINE OFF in TOAD DYOBR

Report message to a moderator

Re: REPLACE [message #487077 is a reply to message #487076]

Wed, 22 December 2010 07:33

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

Senior Member
Account Moderator

Heh, Googling with your keywords, the very first link is my own answer. It is still beautiful, after all those weeks /forum/fa/1683/0/

Report message to a moderator

Re: REPLACE [message #487212 is a reply to message #487076]

Thu, 23 December 2010 22:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

pablolee wrote on Wed, 22 December 2010 14:20

I doon't use toad, but it took me less than 1 minute to find the answer on google. I'll give you a hint, you want to find out how to SET DEFINE OFF in TOAD DYOBR

hehe, I sense a reply coming that a google for "SET DEFINE OFF IN TOAD DYOBR" did not resolve any hits...

Report message to a moderator

Re: REPLACE [message #487249 is a reply to message #487212]

Fri, 24 December 2010 06:10

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

I think that that would deserve a LMGTFY link Very Happy

Report message to a moderator

Previous Topic:	error in PLSQL Developer
Next Topic:	PL SQL Developer SLOW LOGIN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 15 17:19:57 CDT 2025