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 memory optimized table?
How do you create a unique index?
What is sql entity?
Can we call dml statement in function?
What are the different types of dbms?
Can we enter data in a table in design view?
What is $$ in sql?
what is unique key constraint? : Sql dba
What is the difference between delete and truncate commands?
does sql support programming? : Sql dba
What is query execution plan in sql?
What is procedure explain with program?
What is offset and limit in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Can we insert in sql function?
