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

Does sql support programming?

0 Answers  

what is a field in a database ? : Sql dba

0 Answers  

explain mysql aggregate functions. : Sql dba

0 Answers  

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,




what is isam? : Sql dba

0 Answers  

How do I run a pl sql program?

0 Answers  

when a procedure /package is getting invalidated?

4 Answers   TCS,

what is External tables? explain with examples

2 Answers   TCS,

What is relationship? How many types of relationship are there?

0 Answers  

what is HASH join?

2 Answers   Genpact, HCL,

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,

For more SQL PLSQL Interview Questions Click Here
Categories