1
Reply

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

rahul sharma

rahul sharma

12y
3k
0
Reply

    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.