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