Temporary Table « Table « Oracle PL/SQL Tutorial

6.20.Temporary Table
6.20.1.create global temporary table
6.20.2.Global temporary table and connection
6.20.3.create global temporary table transaction_tab on commit delete rows
6.20.4.Create a temporary table whose rows will be deleted at the end of a session by specifying ON COMMIT PRESERVE ROWS
6.20.5.Using Varrays in Temporary Tables