Interested to Buy Any Domain ? << Click Here >> for more details...
What is Temp Table and type of temp table?
- 1 Answers
- 2953 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
Is pl sql still used?
What are the different ways to optimize a sql query?
What is $$ in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Which is faster joins or subqueries?
What is set transaction?
Are subqueries better than joins?
what are enums used for in mysql? : Sql dba
what is sql profiler? : Sql dba
Are stored procedures compiled?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How to process query result in pl/sql?
Can we join tables without foreign key?
What are the 3 types of behavioral triggers?
Why do we need pl sql?
