问题描述
我正在尝试识别特定目录中的所有文件并将其删除.我知道有一个用于此的Java过程,但是我正在寻找纯PL/SQL中的某些东西.
I am trying to identify all files in a particular directory and delete them. I know that there is a Java procedure for this but I am looking for something in pure PL/SQL.
如果我无法获取文件列表并删除它们,那么我不介意删除/删除目录并重新创建它.如果有人可以指导我,这将有很大帮助.
If I am not able to get the list of files and delete them, then I would not mind deleting/dropping the directory and creating it again. If someone can guide me on this it will be of great help.
推荐答案
您可以使用调度程序作业来创建目录列表: http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr1.php#returning_stdout_and_stderr
You can use a scheduler job for creating a directory listing: http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr1.php#returning_stdout_and_stderr
这篇关于从oracle存储过程中的目录中删除文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!