Re: search replace

Chritine if search/replace is for a specific column then below mentioned shld work. But if it is to be applied to all columns in a table then just replace the column "PATH_NAME" for each column or use dbms_sql to dynamically replace column names.

update <<table>>

    set path_name = '\\ServerName\backup\' || substr(path_name,16 )     where path_name like 'E:\Jun30 backup\%'

-Mandar

• Original Message ----- From: "Christine Turner" <christine.turner_at_ips-sendero.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 18, 2000 2:46 PM

> 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).
Received on Mon Sep 18 2000 - 17:58:26 CDT