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