Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
windows/linux, what version of Oracle? – kevinsky Oct 4 '13 at 18:07
It's Oracle Database 11g Enterprise Edition Release - 64bit – Chinmay Oct 6 '13 at 10:40

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

share|improve this answer

I don't think it is necessary to use those APIs to do OS related work. it is important to note the GAP between OS and DB, DB should focus on data while other OS related work should be handled by OS, so here I would suggest define the interface well and pass the necessary information into the interface through OS calls.

share|improve this answer
Why? The OP says there will be just one file per week. I would just make the latest file available as an external table by using the preprocessor (as suggested by @Bjarte) to create a simlink to the latest file and have the external table look at the simlink. – Colin 't Hart Oct 6 '13 at 12:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.