1
Reply

What is difference between global temporary tables and local temporary tables?

rahul sharma

rahul sharma

Nov 21, 2012
3k
0

    1) denoted by # symbol. 2) valid for the current connection only. They are cleared as soon as the curent connection closes. 3)cannot be shared between multiple users.global: 1)denoted by ## symbol. 2)Available to all the connections once created. They are cleared when the last connection is closed. 3)can be shared betwen multiple users.

    Irshad Ahmad
    February 21, 2013
    0