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 cursor in pl sql?
Does sql view stored data?
What are the limitations of sql express?
What is the use of function "module procedure" in pl/sql?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Is sql database free?
What is inner join in sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What does the argument [or replace] do?
what is rollback? : Sql dba
What is dynamic query?
What is the difference between a subquery and a join?
Can we join two tables without common column?
What schema means?
What is a temporal data type?
