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
Does sql profiler affect performance?
How exception handling is done in advance pl/sql?
how to use 'mysql' to run sql statements? : Sql dba
what are the differences between char and nchar? : Sql dba
How to call a javascript function from pl sql?
Do foreign keys improve performance?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
explain access control lists. : Sql dba
How do I run a script in sql developer?
How do I edit a stored procedure?
What are sql ddl commands?
what are date and time functions in mysql? : Sql dba
What is your daily office routine?
What is a table partition?
what is the difference between join and union? : Sql dba
