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
What types of commands can be executed in sql*plus?
What is the least restrictive isolation level? : Transact sql
What is sqlservr exe?
What is the difference between function and procedure in pl/sql?
Does access use sql?
What are the uses of sysdate and user keywords?
Can we create table inside stored procedure?
What is the use of nvl function?
How do I count rows in sql query?
What schema means?
How to run sql commands in sql*plus?
What is record in pl sql?
what is timestamp in mysql? : Sql dba
Explain spool.
How do you break a loop in pl sql?
