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 |
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 do you understand by concurrent programs?
what is organization id
LOCKS?
What is instead of trigger in where we will use?
What do you understand by soa and what are the benefits of using this architecture?
You are working with interfaces if client doesnot give any flat then what will u do?
Tell me some interface tables on ordermangement.
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?
Difference between set of books id and ledger id in r12 ?
What are the validations you don in .CTL file in inbound interface process?