Antw: SQL question : How to retrieve the File_name without

Hi Philippe,

eat this:

select substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','/',-1)+1) from dual;

hth,
Guido

>>> philippe.nguyen_at_cetelem.fr 23.07.2003 09.59 Uhr >>>
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 ! Received on Wed Jul 23 2003 - 02:15:01 CDT