RE: SQL question

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <johan.muller@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Feb 2006 16:37:18 -0500

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
[mailto: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
        
        

Other related posts: