rasti.hil@hilandco.com +41 79 367-9677

Monday, 2 May 2011

Flashback package body

declare 
vclob clob;
begin
for c1 in (select text
            from all_source as of timestamp
             to_timestamp('02-05-2011 12:51:00', 'DD-MM-YYYY HH24:MI:SS')
                 where name = 'PACKAGE NAME'
                   and type = 'PACKAGE BODY'
                   and owner = 'SCHEMA NAME')
    
    loop
     vclob :=vclob||c1.text;
    end loop;
    insert into tempTable (v_clob) values (vclob);
end ;

No comments: