Get distinct datafile paths.

Code:

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