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). Global temporary tables created with a double "##" are visible to all sessions.
3). Global temporary tables are dropped when the session that created it ends,and all other sessions have stopped referencing it.
Asked In: Many Interviews |