How to select directory name from datafile

[tamilselvan]

select substr(file_name, 1, instr(file_name, '/',-1)) PATH
from dba_data_files ;

Tamil