Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 787 invoked from network); 2 Feb 2006 14:46:36 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2006 14:46:36 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD0F5290FAB; Thu, 2 Feb 2006 15:46:34 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08877-04; Thu, 2 Feb 2006 15:46:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 612BE28F66E; Thu, 2 Feb 2006 15:46:34 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2006 15:46:19 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 61501290FA6 for ; Thu, 2 Feb 2006 15:46:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08832-02 for ; Thu, 2 Feb 2006 15:46:19 -0500 (EST) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A408290D61 for ; Thu, 2 Feb 2006 15:46:19 -0500 (EST) Received: by wproxy.gmail.com with SMTP id i32so596150wra for ; Thu, 02 Feb 2006 12:46:16 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=QxJUAczU+V78Tz3BOiJmnrks2jpZyBD0f7KX83VhAhHOTI6qyoj8sX3ncMiz0h/NOk6EjvQcZRpVXPpT9y3uLhGoKFOqwFHFbatBR46jFtmMi50vuVaKw/05CS/Tk8rU9uUCm40CkA/s6ZNc0jzFur6Eq91OX4g5a+7N29MckXk= Received: by 10.64.243.3 with SMTP id q3mr185545qbh; Thu, 02 Feb 2006 12:46:16 -0800 (PST) Received: by 10.65.254.3 with HTTP; Thu, 2 Feb 2006 12:46:16 -0800 (PST) Message-ID: <3b9442840602021246r7358b7f8ye84da3472394c31c@mail.gmail.com> Date: Thu, 2 Feb 2006 14:46:16 -0600 From: Johan Muller To: oracle-l@freelists.org Subject: SQL question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24323_17769147.1138913176044" X-archive-position: 30730 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: johan.muller@gmail.com Precedence: normal Reply-To: johan.muller@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net ------=_Part_24323_17769147.1138913176044 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ------=_Part_24323_17769147.1138913176044 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 t= o return the (new) sid value of elfp.
--
Johan Muller
Oracle DBA<= br>(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 Fran= klin

------=_Part_24323_17769147.1138913176044-- -- http://www.freelists.org/webpage/oracle-l