Oracle Global Temporary Table - oracle tutorial - sql tutorial




Oracle global temporary table

Learn oracle - oracle tutorial - Oracle global temporary table - oracle examples - oracle programs

What is global temporary table in oracle ?

  • Temporary tables generally contain all of the features that ordinary tables have like triggers, join cardinality, information about rows and block etc.
  • the main difference is that the temporary tables can't have foreign keys related to other tables.
 process of global temporary tables

Syntax

CREATE GLOBAL 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 global temporary table that you want to create.
    • column1, column2, ... column_ n: It specifies the column that you want create in the global 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.

Example

  • The following example specifies how to create a global temporary table
CREATE GLOBAL TEMPORARY TABLE students
( student_id numeric(10) NOT NULL,
 			 student_name varchar2(50) NOT NULL,
  student_address varchar2(50)
);
click below button to copy the code. By - oracle tutorial - team
  • This will create a global temporary table called students

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 Global Temporary Table

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×