Q:
What is the difference between a Local and a Global temporary table?
Answer
Local :
Only available to the current Db connection for current user and are cleared when connection is closed.
Multiple users can’t share a local temporary table.
Global:
Available to any connection once created. They are cleared when the last connection is closed.
Can be shared by multiple user sessions
View answer
Workspace
Report Error
Discuss