Message-Id: <25988.339006@fatcity.com> From: "NGUYEN Philippe (Cetelem)" Date: Wed, 23 Jul 2003 09:02:34 +0200 Subject: SQL question : How to retrieve the File_name without Directorie P 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" SQL question : How to retrieve the File_name without Directorie Path ?

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--