What is Temp Table and type of temp table?
- 1 Answers
- 2355 Views
- HP, SLK, I also Faced
- E-Mail Answers
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
how is exception handling handled in mysql? : Sql dba
What does truncate mean in sql?
What is string join?
What is varchar data type in sql?
What is delimiter sql?
what is uncommittable transactions? : Transact sql
what is the difference between cluster and non cluster index? : Sql dba
What is #table in sql?
How global cursor can be declare with dynamic trigger ?
What is the difference between microsoft access and sql?
What is procedure and function?
What is a nested table in word?
Can instead of triggers be used to fire once for each statement on a view?
What are the triggers associated with image items?
Which table is left in join?
