What is the difference between a Local temporary table and a
Global temporary table? How is each one used?

Answers were Sorted based on User's Feedback



What is the difference between a Local temporary table and a Global temporary table? How is each on..

Answer / sarvesh nakhate

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.

A global temporary table remains in the database
permanently, but the rows exist only within a given
connection. When connection is 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.

Is This Answer Correct ?    17 Yes 9 No

What is the difference between a Local temporary table and a Global temporary table? How is each on..

Answer / tarun kumnar basak

A Local Temporary table is almost the same as the Temporary
table in oracle. The main difference is that in oracle
you've to specify the keyword local in your query and also
Local Temporary table exists only for the user who is
created the table. So no other session can use/see the
temporary table.

Where as GTT is another kind of temporary table in oracle
which is by default the temporary table(if you don't
specify the keyword local). GTT can be used by every
user/schema which is connected to the DB irrespective of
each others session and without knowing what data resides
for a particular user. As soon as you log off from the
server the GTT also deleted. It is more kind of session
specific where the structure of the table is shared among
all users but not the data. Data remains private for each
users session and no Lock can be aquired on the table.

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Explain Trigger with an example?

2 Answers  


What is table-valued sub query?

0 Answers  


What is sql server schema compare? How we can compare two database schemas?

0 Answers  


Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,


What is a transaction and what are ACID properties?

3 Answers  






What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,


Explain relational data?

0 Answers  


Explain what is “asynchronous” communication in sql server service broker?

0 Answers  


What are 3 ways to get a count of the number of records in a table?

0 Answers  


What is the use of MOVE keyword in restore command

3 Answers   IBM,


Explain what is it unwise to create wide clustered index keys?

0 Answers  


What is measure group, measure? : sql server analysis services, ssas

0 Answers  


Categories