Oracle LOCAL TEMPORARY TABLES.

Preamble

Oracle LOCAL TEMPORARY TABLES are different inside modules and embedded SQL programs within Oracle sessions.

LOCAL TEMPORARY TABLE syntax

DECLARE LOCAL 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 column that you want to create in the local time table. Each column must have a data type. The column must be defined as either NULL or NOT NULL, and if this value is left blank, the database takes the default value of NULL.

DECLARE LOCAL TEMPORARY TABLE suppliers_temp
( supplier_id number(10) NOT NULL,
supplier_name varchar2(50) NOT NULL,
contact_name varchar2(50)
);

This example will allow you to create a local temporary table in Oracle with the name suppliers_temp.

Oracle: New Feature Private Temporary Table

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.