Find Directory Path only from DBA_DATA_FILES in Oracle Database 19c

Run any below sql to find directory path 

1. SQL> select file_name,substr(file_name,1,length(file_name)-        instr(reverse(file_name),'\')) p from dba_data_files;

2. SQL> select substr(file_name, 1, instr(file_name, '/', -1, 1)) from dba_data_files;

3.  SQL>select file_name, regexp_substr(file_name,'^.*\\') dir from dba_data_files;