Oracle Temporary Table | Oracle Local Temporary Table - oracle tutorial - sql tutorial
What is oracle temporary table ?
- In Oracle, local temporary tables are distinct within modules.
- These tables are defined and scoped to the session in which you created it.
oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql
Declare local temporary table
- 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