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 is use of package in pl sql?
What is denormalization in a database?
what is cross join? : Sql dba
What is mutating sql table?
What is %s in sql?
How to Declare Fixed Length String Value In PL SQL
what is a primary key? : Sql dba
How to create an array in pl/sql?
What are literals in sql server?
What is difference between group by and partition by?
What is the sql query to display the current date?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What are sql indexes?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How run sql*plus commands that are stored in a local file?