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 !
> Philippe
begin: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
