Online Documentation for SQL Manager for Oracle
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:
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.
This group specifies action performed over the table data on commit:
This option is specified for a transaction-specific temporary table. Oracle will truncate the table (delete all its rows) after each commit.
This option is specified for a session-specific temporary table. Oracle will truncate the table (delete all its rows) when you terminate the session.