-- Global temporary table which keeps records till session create global temporary table temp1( year number ) on commit preserve rows; SQL> insert into temp1 values ( 11 ); 1 row created. SQL> select * from temp1; YEAR ---------- 11 -- reconnect to session and check records SQL> connect /as sysdba Connected. SQL> select * … Continue reading Global temporary tables →