Home > PL/SQL, SQL, Technical > Create Global Temporary Table

Create Global Temporary Table

March 29, 2012

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;

Advertisements
Categories: PL/SQL, SQL, Technical
%d bloggers like this: