www.bullraider.com

Global Temporary Table

AddThis Social Bookmark Button
  • Global Temporary Table is a temporary relational table whose definition is available only to the session that insertedto it.
  • The ON COMMIT clause can be included to specify if the data in the temporary table is session specific( i.e ON COMMIT DELETE ROWS) or transaction-specfic (i.e ON COMMIT PRESERVE ROWS).
  • ON COMMIT DELETE ROWS is the default..............

The following example of creating a temporary table whose inserted data will be available throughout the session.
CREATE GLOBAL TEMPORARY TABLE emp_bonus_temp(id NUMBER(15), name char(15)) ON COMMIT PRESERVE ROWS;


Powered by Bullraider.com