What is Temp Table and type of temp table?
Answer Posted / 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 View All Answers
Does sql use python?
What are the indexing methods?
How can a pl sql block be executed?
Explain polymorphism in pl/sql.
What is a variable in sql?
What are tables and fields?
What makes a good primary key?
Why do we use cursors?
what is an extent ? : Sql dba
What are the different ways to optimize a sql query?
Why indexing is needed?
explain what is mysql? : Sql dba
What is the purpose of using pl/sql?
Which command is used to delete a package?
Does sql*plus also have a pl/sql engine?