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
- 19956 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
optimization techinques
Why do we need normalization?
how many bits ip address consist of? : Sql server database administration
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What are the advantages of policy management?
What are the key configuration files for sql server reporting services ?
What is the sql profiler?
What are the requirements to use odbc connections in php scripts?
What is the importance of a recovery model?
What is default constraint in ms sql server?
How to locate and take substrings with charindex() and substring() functions?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is reportserver and reportservertempdb ?
Explain go command in sql server?
Are resultset updatable?
