Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

List Files from Directory using PL/SQL

User910243567Jan 25 2017 — edited Jan 25 2017

We have requirement to fetch list of files from specific directory on Server. Can you please let me know if it can be done through PL/SQL.

Direcotry: /u01/Test

Files: Test20170120.csv, Test20170121.csv, Test20170122.csv.

PL/SQL Object should fetch the oldest date file starting with TEST. In this case 'Test20170120.csv'.

Thanks for your inputs.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2017
Added on Jan 25 2017
2 comments
2,310 views