What is the different between GLOBAL temporary table and LOCAL temporary table?
I know that the Local temporary table is session scoped. When is session end, the table will be drop automatic.But what about the GLOBAL temporary table? Seems it likes a real table, you need to drop it manually? What is the scenario if you are using the GLOBAL temporary table? Thanks, Martin