Oracle Topics

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:- 
  

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


Parameters
  1. table_name:-The parameter table_name specifies the local temporary table that you want to create.
  2. 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.