Global Temporary Table-
Global temp table are visible for all users and its is deleted when the created connection is closed.
e.g Create table ##<tab name>;
Local Temporary Table
Local Temp table are visible for only current user and its available when these in connection and they are deleted when connection closed.
e.g Create table #<tab name>;
Global temp table are visible for all users and its is deleted when the created connection is closed.
e.g Create table ##<tab name>;
Local Temporary Table
Local Temp table are visible for only current user and its available when these in connection and they are deleted when connection closed.
e.g Create table #<tab name>;
No comments:
Post a Comment