Re: RE: SQL question
- From: MARK BRINSMEAD <mark.brinsmead@xxxxxxx>
- To: mark.powell@xxxxxxx
- Date: Thu, 02 Feb 2006 15:21:12 -0700
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@xxxxxxx>
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@xxxxxxxxxxxxx
> [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Muller
> Sent: Thursday, February 02, 2006 3:46 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
