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
- DECLARE LOCAL TEMPORARY TABLE table_name
- ( column1 datatype [ NULL | NOT NULL ],
- column2 datatype [ NULL | NOT NULL ],
- column_n datatype [ NULL | NOT NULL ]
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.