oracle 10g 以上 遍歷檔案

jidongzheng發表於2011-01-26
Oracle 10g

轉:

CREATE OR REPLACE PROCEDURE list_directory
(directory VARCHAR2)
IS
ns VARCHAR2(1024);
v_directory VARCHAR2(1024);
BEGIN
v_directory := directory;
SYS.DBMS_BACKUP_RESTORE.SEARCHFILES(v_directory, ns);
FOR each_file IN (SELECT fname_krbmsft AS name FROM x$krbmsft) LOOP
DBMS_OUTPUT.PUT_LINE(each_file.name);
END LOOP;
END;
/

[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/197458/viewspace-1045202/，如需轉載，請註明出處，否則將追究法律責任。

相關文章