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
How do I run a sql trace?
i have some prob lem to tell me about my self in interview first round ...
Explain clause in sql?
How to Declare Fixed Length String Value In PL SQL
How many tables can you join in sql?
Explain what is table in a database?
How many times can we commit in a loop?
Can we use pl sql in mysql?
What are the two parts of design view?
how can we repair a mysql table? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
What is error ora-01000: maximum open cursors exceeded
Show the two pl/sql cursor exceptions.
Enlist some predefined exceptions?
What are the constraints available in sql?
