Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the various restrictions imposed on view in terms of dml?
Are left and right joins the same?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Write a unique difference between a function and a stored procedure.
What is the difference between the conventional and direct path loader? : aql loader
what is the difference between clustered and non clustered index in sql? : Sql dba
How to check if a column is nullable before setting to nullable?
What is forward declaration in pl sql?
Explain cursor types?
What are commit, rollback, and savepoint?
How to use distinct and count in sql query? Explain
What is the difference between local and global temporary table?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is primary key secondary key alternate key candidate key?
how to show all tables with 'mysql'? : Sql dba
