Thursday, June 12, 2008
What is the difference between a local and a global variable?
A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection are closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.
Labels: Interview Questions