Answer Posted / jijo
Global temporary tables are temporary table for perticular session.
Global temporary tables are two types,
1.Transaction wise temporary table
2.Session wise temporary tables.
In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.
In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
Do you know where we can check the status of po?
What is oracle soa suite and what are its different components?
tell my any difficult situtation you solved in your experience in your company?
Can you explain the difference between architecture followed in 10g & 11g?
In support project one ticket alloted which steps follows manualy tell me ?
In oracle application how do you debug or trace errors?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are file in oracle.
Is soa a part of oracle fusion middleware?
What are the different components of soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are do's and dont's of Interface?
what are the prerequisites for costing transactions?
How is choreography different from orchestration?
What are the benefits of using soa architecture?