Global Temporary tables

Global temporary tables are distinct within SQL sessions.

The syntax for creating a global temporary table is:

CREATE GLOBAL TEMPORARY TABLE table_name ( ...);

For Example

CREATE GLOBAL TEMPORARY TABLE supplier
( supplier_id numeric(10) not null,
  supplier_name varchar2(50) not null,
  contact_name varchar2(50)
);

This would create a global temporary table called supplier.