SQL question : How to retrieve the File

From: NGUYEN Philippe (Cetelem) <philippe.nguyen_at_cetelem.fr>
Date: Wed, 23 Jul 2003 09:02:34 +0200
Message-Id: <25988.339006@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C350E7.9386D0EF
Content-Type: text/plain;

charset="iso-8859-1"

Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files.
eg :'/oracle/d0/data/user.dbf' --> user.dbf Maybe using translate function ?
Thank in advance !
Philippe

------_=_NextPart_001_01C350E7.9386D0EF
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35">
<TITLE>SQL question : How to retrieve the File_name without Directorie Path ?</TITLE>
</HEAD>
<BODY>

Hi Gurus!
 a very simple problem for You :I just want to retrieve the .dbf name from file_name column in dba_data_files.
 eg :'/oracle/d0/data/user.dbf' --> user.dbf
 Maybe using translate function ? 
 Thank in advance !
 Philippe


</BODY>
</HTML>

------_=_NextPart_001_01C350E7.9386D0EF-- Received on Wed Jul 23 2003 - 02:02:34 CDT