Interested to Buy Any Domain ? << Click Here >> for more details...
What is Temp Table and type of temp table?
- 1 Answers
- 2961 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
how many tables will create when we create table, what are they? : Sql dba
What are three advantages to using sql?
What are the packages in pl sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
what does the t-sql command ident_current does? : Transact sql
What is normalization in a database?
How does a self join work?
What is the difference between row level and statement level trigger?
What is column?
what is the difference between delete and truncate statement in sql? : Sql dba
What is a record in pl/sql?
What is sql analyzer?
What are the different datatypes available in PL/SQL?
How do temporal tables work?
What is difference between left and right outer join?
