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
What is t-sql? : Transact sql
how do you control the max size of a heap table? : Sql dba
Can you selectively load only those records that you need? : aql loader
How do I run a sql script?
What is the difference between function, procedure and package in pl/sql?
Define union, minus, union all, intersect ?
what is a stored procedure? : Sql dba
What are dml commands?
how is myisam table stored? : Sql dba
Can we use ddl statements in stored procedure?
How can check sql version from command line?
How bulk collect improves performance?
Is sql scripting language?
What is difference between sql and mysql?
What is blind sql injection?