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.

Can we write a distributed query and get some data which is located on other server and oracle database?

1176

---

Why is the need for data conversion transformations?

978

---

What is the difference between row_number and dense_rank?

826

---

Determine how to use the inserted and deleted pseudo tables?

929

---

Can we store videos inside the sql server table?

908

---

How do we know if any query is retrieving a large amount of data or very little data?

920

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

933

---

Explain the disadvantages/limitation of the cursor?

915

---

Which tcp/ip port does the sql server run on? How can it be changed?

994

---

how to control the amount of free space in your index pages? : Sql server database administration

982

---

What happens if null values are involved in boolean operations?

941

---

Characterize join and name diverse sorts of joins?

909

---

What is acid properties?

1019

---

What is unpivot?

968

---

Why use identity in sql server?

1009

---