Home » SQL & PL/SQL » Client Tools » REPLACE (9i)
REPLACE [message #487070] Wed, 22 December 2010 06:09 Go to next message
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.
Re: REPLACE [message #487071 is a reply to message #487070] Wed, 22 December 2010 06:27 Go to previous messageGo to next message
pablolee
Messages: 2876
Registered: May 2007
Location: Scotland
Senior Member
Lookup SET DEFINE OFF
Re: REPLACE [message #487075 is a reply to message #487071] Wed, 22 December 2010 07:16 Go to previous messageGo to next message
vishalk
Messages: 33
Registered: October 2010
Member

it work.
but i want run in toad.
it is possible or not?
Re: REPLACE [message #487076 is a reply to message #487075] Wed, 22 December 2010 07:20 Go to previous messageGo to next message
pablolee
Messages: 2876
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
Re: REPLACE [message #487077 is a reply to message #487076] Wed, 22 December 2010 07:33 Go to previous messageGo to next message
Littlefoot
Messages: 21439
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/
Re: REPLACE [message #487212 is a reply to message #487076] Thu, 23 December 2010 22:57 Go to previous messageGo to next message
Frank
Messages: 7880
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...
Re: REPLACE [message #487249 is a reply to message #487212] Fri, 24 December 2010 06:10 Go to previous message
pablolee
Messages: 2876
Registered: May 2007
Location: Scotland
Senior Member
Very Happy I think that that would deserve a LMGTFY link Very Happy
Previous Topic: error in PLSQL Developer
Next Topic: PL SQL Developer SLOW LOGIN
Goto Forum:
  


Current Time: Fri Oct 19 02:15:32 CDT 2018