what is global tempory table?



what is global tempory table?..

Answer / 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

More Oracle Apps Technical Interview Questions

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

0 Answers   Satyam,


What do you understand by concurrent programs?

0 Answers  


what is organization id

3 Answers  


LOCKS?

1 Answers  


What is instead of trigger in where we will use?

0 Answers  






What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,


Tell me some interface tables on ordermangement.

1 Answers   Zensar,


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,


Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,


What are the validations you don in .CTL file in inbound interface process?

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)