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 |
What is plpgsql language?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is raid? How does it help storage of databases?
How many developers work on postgresql?
there are .......different types of serializability
What does where 1/2 mean in sql?
What is sql clause?
how to get @@error and @@rowcount at the same time? : Sql dba
What are sql data types?
What are the possible values for the boolean data field?
Which are the different case manipulation functions in sql?
What is implicit cursor in pl sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)