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 is structural independence and why is it important?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is a sql instance vs database?
Why schema is used in sql?
What are analytical functions in sql?
Does sql*plus also have a pl/sql engine?
How show all rows in sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Does truncate table reset auto increment?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is pivot in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is a dirty read sql?
What is function and procedure?
Show how functions and procedures are called in a pl/sql block.
