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
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;
        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
        Liberty is a well-armed lamb contesting the vote." --Benjamin

Other related posts: