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
Is sql dba a good career? : SQL DBA
What is write ahead logging in sql server?
What is difference between table and view?
What are the packages in pl sql?
What is the difference between stored procedure and view?
What are the possible values for the boolean data field?
What are different types of keys?
Can we use pl sql in sql server?
What can sql server reporting services do?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What are tuples in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
How is use pl and sql?
what is the difference between $message and $$message? : Sql dba
what are all different types of collation sensitivity? : Sql dba
