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

Syntax

DECLARE LOCAL TEMPORARY TABLE table_name
( column1 datatype [ NULL | NOT NULL ],
  			column2 datatype [ NULL | NOT NULL ],
 			 ...
 			 column_n datatype [ NULL | NOT NULL ]
);
click below button to copy the code. By - oracle tutorial - team

Parameters

  • 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

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle Local Temporary Table