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 case function?
Explain how to use transactions efficiently : transact sql
Explain the components of sql?
How do I remove sql plus from windows 10?
What normalization means?
what's the difference between a primary key and a unique key? : Sql dba
how to see the create table statement of an existing table? : Sql dba
Is sql a case sensitive language?
Can there be more than one function with a similar name in a pl/sql block?
Is pl sql a scripting language?
What are all the different normalizations?
What is the primary key?
What is snowflake sql?
What are the operators in sql?
How does cross join work in sql?
