Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:

Re:

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 19 Sep 2000 00:27:46 GMT
Message-Id: <10623.117304@fatcity.com>


Christine,

I'm hoping you mean find all rows, not all columns. If so, it's fairly easy.

There is a 'replace' command in SQL, you can use that.

update <tablename> set <column>=

         replace(<column>,'E:\Jun30backup\','\\ServerName\backup\')\
      where <column> like '%E:\Jun30backup\%';


should do the trick.

Rachel

>From: Christine Turner <christine.turner_at_ips-sendero.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: Mon, 18 Sep 2000 13:46:51 -0800
>
>Hello All.........
>
>I have an interesting request from a co-worker of mine. Listed below is a
>sub-set of data from a table in one of our databases. The request was a
>basic search and replace. Find all columns with the string "E:\Jun30
>backup\" in them and replace it with "\\ServerName\backup\".
>
>PATH_NAME
>------------------------------------------------------------------------
>-----------
>E:\April30 backup\daily_gl_baleom.prn
>E:\May30 backup\dailyglbal.prn
>E:\Jun30 backup\BORROWALS30.LST
>E:\Jun30 backup\dda30.LST
>E:\Jun30 backup\loans30.LST
>
>Anyone have ANY ideas???? I'm a little stumped so any help is appreciated.
>
>Thanks!!!
>Christine Turner
>DBA
>IPS Sendero
>Scottsdale, Arizona
>
>--
>Author: Christine Turner
> INET: christine.turner_at_ips-sendero.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Mon Sep 18 2000 - 19:27:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US