Discussion in 'General' started by harshith, Nov 7, 2011.
What is the difference between temporary table and global temporary table?
A temporary table is owned by the person who created it and can only be accessed by that user. A global temporary table is accessible to everyone and will contain data specific to the session using it; multiple sessions can use the same global temporary table simultaneously. It is basically a global definition for a temporary table that all can benefit from.
thanks David Fitzjarrell
But In Oracle , temporary table is same as Global temporary table. You just cannot create a temp table without the keyword "global" in Oracle.
This is true but we do get questions regarding other databases and SQL Server/Sybase offer both local and global temporary tables. MySQL only offers local temporary tables.
Since the question was not database-specific (yes, I know this is for the most part an Oracle forum) I answered generically.