Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subbu
Global temporary tables belongs to that session only
create global temporary table test_gbl
( l_number_no number,
l_char_vc varchar2(100)
) [on commit delete rows]
ON COMMIT DELETE ROWS:- It's a default one
If any commit will issued that total data of a table will
losses. But table is exit
To overcome this we have option
ON COMMIT PRESERVE ROWS:-
means, If commit will issue the data of a table willn't loss
up to end of the session. Is session ends the data will losses.
Regards
Subbu
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is difference between primary and secondary key?
What is varchar sql?
What is meant by truncate in sql?
What is duration in sql profiler trace?
What is foreign key in sql with example?
Can we use commit inside a trigger?
How can we store rows in PL/SQL using array?
Do we need to create index on primary key?
What is the use of desc in sql?
Why schema is used in sql?
What is trigger and types?
can a stored procedure call itself or recursive stored procedure? : Sql dba
Can we insert data into materialized view?
What is difference between hql and native sql?
What is the mutating table and constraining table?
