Create Global Temporary Table

Today..i have used global temporary table to backup my system….

global temporary tables are very useful on session basis…

can have a session safe calculations using global temporary tables.

Two ways to create global temporary tables:

1.CREATE GLOBAL TEMPORARY TABLE TEMP_table( PRIMEID  NUMBER ) ON COMMIT PRESERVE ROWS;

2.CREATE GLOBAL TEMPORARY TABLE TEMP_table( PRIMEID  NUMBER ) ON COMMIT DELETE ROWS;