Oracle Global Temporary Table

A temporary table is a table that holds data only for the duration of a session or transaction.


CREATE GLOBAL TEMPORARY TABLE xyz( column1,column2 ) ON COMMIT DELETE ROWS;


by executing below statement it automatically deletes the rows.

select column1,column2 from xyz;
commit;