create global temporary table gtt ( x int ) on commit delete rows 

insert into gtt values (1) 

select * from gtt 

declare 
   pragma autonomous_transaction; 
begin 
   insert into gtt values ( 2 ); 
   commit; 
end; 

select * from gtt