Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL to read date modified of a textfile
PL/SQL to read date modified of a textfile [message #263267] Wed, 29 August 2007 09:35 Go to next message
shall42
Messages: 8
Registered: October 2006
Junior Member
Example I need to use SQL/PL to read the date
from a text file

C:\myfile.TXT 8/29/2007 8:00AM

This is on an NT box and I have Oracle 9i.
My goal is to create a procedure to run once a day
that would delete all files that were over 2 days old.

Suggestions?

TIA
Steve

Re: PL/SQL to read date modified of a textfile [message #263287 is a reply to message #263267] Wed, 29 August 2007 10:48 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On AskTom, for instance "reading files in a directory -- how to get a list of available files" but there are many other threads on the subject.
Just use the search field.

Regards
Michel
Previous Topic: CompositeKey
Next Topic: EXPLAIN PLAN doesn't show view names
Goto Forum:
  


Current Time: Fri Dec 02 18:25:35 CST 2016

Total time taken to generate the page: 0.11147 seconds