Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:
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).
Share information about yourself, create your own public profile at Received on Mon Sep 18 2000 - 19:27:46 CDT
![]() |
![]() |