1. A local temporary table exists only for the duration of a connection or, if
defined inside a compound statement, for the duration of the compound
statement.
2. A global temporary table remains in the database permanently, but the rows
exist only within a given connection. When connection is closed, the data in
the global temporary table disappears. However, the table definition remains
with the database for access when database is opened next time.
No comments:
Post a Comment