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 the difference between cluster and non cluster index? : Sql dba
Why join is faster than subquery?
How many commands are there in sql?
Does normalization improve performance?
How to write html code in pl sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
who introduced sql?
Does sap use sql?
Do prepared statements prevent sql injection?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Should I use mbr or gpt?
What are different categories of sql commands?
explain about mysql and its features. : Sql dba
what is recursive stored procedure? : Sql dba
Explain what is sql?