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
Write the command to remove all players named sachin from the players table.
Can you rollback after commit?
Can we enter data in a table in design view?
Is id a reserved word in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is int identity in sql?
what is 'mysqlimport'? : Sql dba
How do you use a while loop in pl sql?
What is difference between joins and union?
What is minus?
What are different sql data types?
what is an alias command? : Sql dba
What are all different types of collation sensitivity?
What are the types of views in sql?
Which join is like inner join?