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
which tcp/ip port does sql server run on? : Sql dba
what is the difference between join and union? : Sql dba
Is it possible to sort a column using a column alias?
How to read xml file in oracle pl sql?
what is datawarehouse? : Sql dba
What are pl sql procedures?
how to drop an existing view in mysql? : Sql dba
Can we rollback truncate?
Is left join inner or outer by default?
what are all different types of collation sensitivity? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Name the different types of indexes in sql and define them.
How does one load ebcdic data? : aql loader
What is benefit of creating memory optimized table?
How do you determine the current isolation level? : Transact sql
