本文介绍了从oracle存储过程中的目录中删除文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试识别特定目录中的所有文件并将其删除.我知道有一个用于此的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存储过程中的目录中删除文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-22 09:37