Recover dropped oracle procedure

--- recover the dropped/changed procedure PROCEDURE_SALES 

select text from dba_source
     as of timestamp systimestamp - interval '15' minute 
     where name='PROCEDURE_SALES' and type = 'PACKAGE BODY'
order by line asc;

Articolul original:
http://uhesse.wordpress.com/2009/06/03/retrieve-old-versions-of-procedures-with-flashback-query/