== Retrieve sql definition of a dropped view ==

<code PLSQL>
SET PAGESIZE 0
SET LINESIZE 1000
SET LONG 1000000
SET LONGCHUNKSIZE 1000000
SET TRIMSPOOL ON
SET TRIM ON
 
SPOOL view_definition.sql
 
select text from dba_views as of timestamp timestamp'2025-03-26 15:00:00' where view_name = 'V_BALANCE_ALCO_HH_POST_PHOENIX';
 
SPOOL OFF
</code>