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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is delete faster than truncate?
What is dbo in sql?
What do we need to check in database testing?
Can you inner join the same table?
what is a composite primary key ? : Sql dba
how would you enter characters as hex numbers? : Sql dba
What is an intersect?
What is sql and also describe types of sql statements?
how to calculate the difference between two dates? : Sql dba
State few characteristics of pl/sql?
What is mutating table error?
What is pl sql script?
How many commands are there in sql?
What is pl sql in dbms?
What is not equal in sql?