Re: RE: SQL question

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_at_eds.com> 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_at_freelists.org
> [oracle-l-bounce_at_freelists.org] On Behalf Of Johan Muller
> Sent: Thursday, February 02, 2006 3:46 PM
> To: oracle-l_at_freelists.org
> 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