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