SQL question : How to retrieve the File_name without Directorie P

[NGUYEN Philippe (Cetelem)]

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

Re: SQL question : How to retrieve the File_name without Directorie P

[Daniel Fink]

Phillipe,
Look at using INSTR and SUBSTR to calculate the position of the last / and 
work from there.

Daniel

 NGUYEN Philippe (Cetelem) wrote:
 
 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 !
 Philippebegin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard