OraFAQ Forum: SQL & PL/SQL » Replace characters in a string using sql plus

Home » SQL & PL/SQL » SQL & PL/SQL » Replace characters in a string using sql plus

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

Replace characters in a string using sql plus [message #298220]

Tue, 05 February 2008 06:39

MarkGwilliam
Messages: 2
Registered: February 2008

Junior Member

I have approx 700,000 records containing a url within a CHAR field. I some how need to update part of the existing url within each field (the server name) to a new value. I am using sql plus and am a newbie to dba tasks. Can anyone point me in the right direction as to how I can achieve this?
Cheers
Mark

Report message to a moderator

Re: Replace characters in a string using sql plus [message #298223 is a reply to message #298220]

Tue, 05 February 2008 06:43

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

Senior Member
Account Moderator

Use the REPLACE function, such as

SQL> select replace('little.foot@old.hr', 'old', 'new') result
  2  from dual;

RESULT
------------------
little.foot@new.hr

SQL>

Report message to a moderator

Re: Replace characters in a string using sql plus [message #298226 is a reply to message #298220]

Tue, 05 February 2008 06:46

MarcS
Messages: 312
Registered: March 2007
Location: Antwerp

Senior Member

Have a look at TRANSLATE & REPLACE functions as described here

Ok, Littlefoot beat me to it Wink

[Updated on: Tue, 05 February 2008 06:46]

Report message to a moderator

Previous Topic:	Stop executing trigger
Next Topic:	For Loop coding problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 04:45:29 CST 2024