Oracle Local Temporary tables

In Oracle, local temporary tables are distinct within modules. These tables are defined and scoped to the session in which you created it.

Declare local temporary table

Syntax

snippet
DECLARE LOCAL TEMPORARY TABLE table_name
( column1 datatype [ NULL | NOT NULL ],
  column2 datatype [ NULL | NOT NULL ],
  ...
  column_n datatype [ NULL | NOT NULL ]
);

Parameters

table_name: The parameter table_name specifies the local temporary table that you want to create.

column1, column2,... column_ n: It specifies the column that you want create in the local temporary table. Every column must have a datatype and should be defined as NULL or NOTNULL. If the value is left blank, it is by default treated as NULL.

Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +