Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Local temporary table and a
Global temporary table? How is each one used?
- 2 Answers
- 19963 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is rs.exe utility?
What is SQL Azure Data sync?
How can I know what locks are running on which resource?
How to update muliple row in single query?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to select all columns of all rows from a table with a select statement in ms sql server?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is replace and stuff function in sql server?
What is meant by datasource?
What are the rendering extensions of ssrs?
What is the usage of the sign function?
What objects does the fn_my_permissions function reports on? : sql server security
Does union all remove duplicates?
Mention what are the core components of ssrs?
