Interested to Buy Any Domain ? << Click Here >> for more details...
What is Temp Table and type of temp table?
- 1 Answers
- 2812 Views
- HP, SLK, I also Faced
- E-Mail Answers
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 |
How to start the command-line sql*plus?
What are the types of keys?
What does the file extension accdb stand for?
What is trigger in pl sql?
What is application trigger?
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
what is the difference between clustered and non clustered index in sql? : Sql dba
how will be date change into string
what are the authentication modes in sql server? : Sql dba
What are basic techniques of indexing?
Sql technical questions
What is an inconsistent dependency?
-
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)
