GLOBAL TEMPORARY TABLE Vs TEMPORARY TABLE
In Oracle, there is no difference between temporary table and global temporary tables . When we create a temporary table in an Oracle database, it is automatically global, and you are required to include the "Global" key word.
The SQL standard, which defines how the term "GLOBAL TEMPORARY TABLE" is interpreted, allows for either a LOCAL or GLOBAL scope. This would allow for either a user specific table (LOCAL) or everyone (GLOBAL). Oracle implements only the GLOBAL version.
The data we put into an Oracle Temporary table is specific to our session only. That is, only you can see your data even if there are 500 users all using the same table, and your data is deleted from the table when you disconnect (or when you commit the current transaction) depending upon table settings.
To know about Global temporary table http://quickoraclelearning.blogspot.in/2012/11/lesson-33-global-temporary-tables-gtt.html
In Oracle, there is no difference between temporary table and global temporary tables . When we create a temporary table in an Oracle database, it is automatically global, and you are required to include the "Global" key word.
The SQL standard, which defines how the term "GLOBAL TEMPORARY TABLE" is interpreted, allows for either a LOCAL or GLOBAL scope. This would allow for either a user specific table (LOCAL) or everyone (GLOBAL). Oracle implements only the GLOBAL version.
The data we put into an Oracle Temporary table is specific to our session only. That is, only you can see your data even if there are 500 users all using the same table, and your data is deleted from the table when you disconnect (or when you commit the current transaction) depending upon table settings.
To know about Global temporary table http://quickoraclelearning.blogspot.in/2012/11/lesson-33-global-temporary-tables-gtt.html
No comments:
Post a Comment