Oracle GLOBAL TEMPORARY TABLES.

Preamble

Oracle PLSQL GLOBAL TEMPORARY TABLES are tables that are created for individual Oracle sessions.

Oracle CREATE GLOBAL TEMPORARY TABLE syntax:

CREATE GLOBAL TEMPORARY TABLE table_name
( column1 datatype [ NULL | NOT NULL ],
column2 datatype [ NULL | NOT NULL ],
…
column_n datatype [ NULL | NOT NULL ]
);

Parameters or arguments

• table_name – The name of the table you want to create.
• column1, column2, … column_n – The columns that you want to create in the global time table. Each column must have a data type. The column must be defined as NULL or NOT NULL, and if this value remains empty, the database takes on the default value of NULL.

Let’s consider the example of Oracle CREATE GLOBAL TEMPORARY TABLE:

CREATE GLOBAL TEMPORARY TABLE suppliers
( supplier_id numeric(10) NOT NULL,
supplier_name varchar2(50) NOT NULL,
contact_name varchar2(50)
);

This example will allow Oracle to create a global temporary table with a name.

GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.