I need a PL/SQL script which uses UTL_FILE to identify archive logs which can be deleted. I need to delete 30 day old archive log.
There is no way you could get this information using UTL_FILE. The only way to do this from the database is by using external functions/procedures or some database java functions/procedures.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?