Online Documentation for SQL Manager for Oracle

Global Temporary

A Global Temporary table is a temporary table and its definition is visible to all sessions with appropriate privileges. The data in a temporary table  are visible only to the session that inserts the data into the table.

The following type-specific properties can be set for Global Temporary tables:

Duration

The table segment and any data the table contains can be either session-specific or transaction-specific data. Use this group to specify whether the table segment and data are session- or transaction-specific.

On commit

This group specifies action performed over the table data on commit:

Delete rows

This option is specified for a transaction-specific temporary table. Oracle will truncate the table (delete all its rows) after each commit.

Preserve rows

This option is specified for a session-specific temporary table. Oracle will truncate the table (delete all its rows) when you terminate the session.