Answer Posted / pooja
Global temporary tables
All data stored in a global temporary table is private to
the session that has inserted (or updated) it.
Other sessions can't see this data. Global temporary tables
come in two flavors:
on commit preserve rows and on commit delete rows.
DDLs (such as drop table) on a on commit preserve rows lead
to a ORA-14452
when the session has already made a DML on the table.
Object tables
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How many types of functions are there in sql?
what tools available for managing mysql server? : Sql dba
How do I run a script in sql developer?
What is relationship? How many types of relationship are there?
what is a composite key ? : Sql dba
What is record variable?
How to place comments in pl/sql?
what is a table in a database ? : Sql dba
What is view? Can we update view
What are the types of records?
What are the basic sql commands?
How do I delete a trigger?
Which is faster view or stored procedure?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is hibernate and its relation to sql?
