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 parallel hint?
what is the difference between primary key and unique key? : Sql dba
Which operator is used in query for pattern matching?
How to revise and re-run the last sql command?
Can a foreign key be null?
Do stored procedures prevent sql injection?
How do I enable sql encryption?
How do I upgrade sql?
How many rows can sqlite handle?
how to increment dates by 1 in mysql? : Sql dba
What is the difference between execution of triggers and stored procedures?
What are the sql commands?
What are literals in sql server?
What is a sql schema used for?
What does inner join mean?
