How to fetch file path from a folder through PL/SQL We upload files on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible.

If possible, please suggest what should I do.
Mr. Kyte wrote about accessing os-file-information utilizing the preprocessor directive a while ago. Perhaps this is what you are after. 

query the operating system