SQL question

From: Johan Muller <johan.muller_at_gmail.com>
Date: Thu, 2 Feb 2006 14:46:16 -0600
Message-ID: <3b9442840602021246r7358b7f8ye84da3472394c31c@mail.gmail.com>

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 Received on Thu Feb 02 2006 - 14:46:16 CST