Yes, it probably would.

But depending on the circumstances, it might be an
even better job for the initialisation parameter
db_file_name_convert.

Depending on what the original poster is trying to
achieve (e.g., clone a devel database from
production) proper use of this parameter *might*
make the SQL Question unnecessary...


----- Original Message -----
From: "Powell, Mark D" <mark.powell@(protected)>
Date: Thursday, February 2, 2006 2:37 pm
Subject: RE: SQL question

> Wouldn't that be a job for the replace function? See SQL manual
>
> replace(column,'target','replacement')
>
> HTH -- Mark D Powell --
>
>
>
>
> ________________________________
>
>  From: oracle-l-bounce@(protected)
> [oracle-l-bounce@(protected)
>  Sent: Thursday, February 02, 2006 3:46 PM
>  To: oracle-l@(protected)
>  Subject: SQL question
>  
>  
>  How can I use sql (decode I think) to do the following;
>  
>  select file_name from dba_data_files;
>  
>  
>  /u02/oradata/elfd/arch_closet_idx_01.dbf
>  
>  21 rows selected.
>  
>  SQL> l
>  
>  Now I want to change the /elfd/ (sid) to /elfp/ in each string.
>  
>  Any idea (decode). I tried translate and replace but only
> manages to return the (new) sid value of elfp.
>  --
>  Johan Muller
>  Oracle DBA
>  (214) 676 2147 anytime.
>  
>  "Democracy is two wolves and a lamb voting on what to have for
> lunch.
>  Liberty is a well-armed lamb contesting the vote." --Benjamin
> Franklin
>  
>  
>
>

--
http://www.freelists.org/webpage/oracle-l