获取数据文件目录和文件名的sql

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

 

SUBSTR(FILE_NAME,1,INSTR(FILE_

--------------------------------------------------------------------------------

/paic/g2bh8070/dev/of/data/oradata/fmsbkstg/

 

SQL> select substr(file_name,instr(file_name,'/',-1)+1) from dba_data_files where rownum<2;

 

SUBSTR(FILE_NAME,INSTR(FILE_NA

--------------------------------------------------------------------------------

system11.dbf

 

SQL> select file_name from dba_data_files where rownum<2;

 

FILE_NAME

--------------------------------------------------------------------------------

/paic/g2bh8070/dev/of/data/oradata/fmsbkstg/system11.dbf

 

SQL>

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15779287/viewspace-675318/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15779287/viewspace-675318/