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
What is compilation error in pl sql?
What normalization means?
Determine if oracle date is on a weekend?
what is sql profiler? : Sql dba
Does sql full backup truncate logs?
Does sql use python?
What are the types of triggers in sql?
How to place comments in pl/sql?
how do you know the version of your mysql server? : Sql dba
give the syntax of grant and revoke commands? : Sql dba
What is a design view?
Can we perform dml in function?
What is the clause we need to add in function body to return variable?
what is the use of set statement in tsql? : Transact sql
What is benefit of creating memory optimized table?
