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 ] );
Here