Oracle Global Temporary tablesTemporary 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. Syntax Parameterstable_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. ExampleThe following example specifies how to create a global temporary table This will create a global temporary table called students Next TopicOracle Local Temp Tables |