8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Misc » Here

List Files in a Directory From PL/SQL and SQL : Comparison of Methods

This article compares the methods available to list files in a directory on the database server.

They are presented in my preferred order, but all are viable alternatives. This article includes the pros and cons of each method, but these are also included in the articles themselves.

External Table

This method is described here.

Pros of this method are.

Cons of this method are.

Java

This method is described here.

Pros of this method are.

Cons of this method are.

DBMS_BACKUP_RESTORE

This method is described here.

Pros of this method are.

Cons of this method are.

DBMS_SCHEDULER

This method is described here.

Pros of this method are.

Cons of this method are.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.