...

Database Managment - Oracle

Back to Course

Lesson Description


Lession - #1411 Oracle Local Temporary tables


Oracle Local Temporary tables

In Oracle, nearby brief tables are unmistakable inside modules. These tables are characterized and checked to the meeting where you made it.
Syntax

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

Parameters table_name: The boundary table_name indicates the neighborhood brief table that you need to make. column1, column2,... column_ n: It determines your desired segment make in the neighborhood brief table. Each segment should have a datatype and ought to be characterized as NULL or NOTNULL. On the off chance that the worth is left clear, it is of course treated as NULL.