Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Replace string, help!
Hi!
Thanks, I use 'replace' but I have another problem with this strings.
Original:
MY CAR (DUBLIN) MY CAR (VIENNA) MY CAR (SPAIN)
Replace String (result)
MY OLD CAR (DUBLIN) MY OLD CAR (VIENNA) MY OLD CAR (SPAIN)
Only I can replace any words of the string, but when I use 'replace' command:
REPLACE ('MY CAR ','MY CAR ','MY OLD CAR ');
Result:
MY OLD CAR
MY OLD CAR
MY OLD CAR
But... The another string??? (DUBLIN) (VIENNA) (SPAIN) ???
Thx.... Received on Fri Feb 16 2001 - 01:11:23 CST