Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is Temp Table and type of temp table?

Question Posted / sumanamara


What is Temp Table and type of temp table?..

Answer / shwetha n k

GLOBAL TEMPORARY TABLES in Oracle are tables that are created distinct within the Oracle sessions.
Oracle support two types of temporary tables.
•Global Temporary Tables : Available since Oracle 8i and subject of this article.
•Private Temporary Tables : Available since Oracle 18c. Discussed here.
you can create GTT table with on commit delete rows or on commit preserved rows.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How do I use google cloud in sql?

0 Answers  

Is coalesce faster than isnull?

0 Answers  

What does sign mean sql?

0 Answers  

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

will function return more than one value how

9 Answers   Accenture,




What is meant by cursor in sql?

0 Answers  

What is a merge query?

1 Answers  

diff b/w function and procedure?

9 Answers   iFlex,

Is oracle and sql same?

0 Answers  

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

Differentiate between pl/sql and sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories