SQL question

  • From: Johan Muller <johan.muller@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 2 Feb 2006 14:46:16 -0600

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

Other related posts: