Differentiate between a Local and a Global temporary table?

Answer:

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.