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 !
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