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
What is the purpose of normalization?
What does trigger mean in slang?
Which sql most popular?
Explain the steps needed to create the scheduled job?
What are the types of functions in sql?
What is data profiling in sql?
How to run pl sql program in mysql?
Can a foreign key have a different name?
When can we use the where clause and the having clause?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Why is %isopen always false for an implicit cursor?
how many ways to get the current time? : Sql dba
What steps server process has to take to execute an update statement?
define sql update statement ? : Sql dba
what are the different functions in sorting an array? : Sql dba
