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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How do I run a pl sql procedure in sql developer?
What is the difference between clustered and non-clustered index in sql?
Is ms sql traffic encrypted?
Is sql a oracle?
How do I get sql certification?
What are different functions in sql?
How do I truncate a word?
How do I make my sql query run faster?
What do you mean by stored procedures?
What are instead of triggers?
Is mariadb a nosql database?
How much does sql certification cost?
How do you drop a trigger?
What are the main features of cursor?
