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 |
find the third highest salary?
What is oracle and pl sql?
What are the parameter modes supported by pl/sql?
What are the limitations of sql express?
Does inner join return duplicate rows?
What is the full form of sql?
How do I run sql?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
Explain exception handling in pl/sql?
What is autocommit sql?
How do I kill a query in postgresql?
what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
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)