Oracle support to create a local temporary table with the help of 'LOCAL TEMPORARY' keyword. Oracle LOCAL TEMPORARY TABLES are distinct within modules and embedded SQL programs within Oracle sessions.
To create a local temporary table, use the following syntax:
Parameters:
tablename: The temporary table name that you want to create.
column1, column2: The columns that you wish to create in the local temporary table.
Note:
In the above example, we created local temporary table "tblTempCustomer".
To remove a temporary table, use the following syntax:
Parameters:
temptablename: The temporary table name that you want to remove.
Note:
In the above example, we removed a local temporary table called "tblTempCustomer".