Friday, July 13, 2012

Get distinct datafile paths.

Code:

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

No comments:

Post a Comment