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.

what is organization id

3 Answers  

---

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 are triggers?

3 Answers  

---

where we can check the status of po.

4 Answers  

---

can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,

---

In which table or database definition we can find the link of organization and operation units.

2 Answers   IBM,

---

What are the Major differences bteween key flexfields ,descriptive flexfields

4 Answers   Sierra Atlantica, TechBulls,

---

why r u transer the data base tables to flat file and what is use

2 Answers  

---

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

---

how can we return morethan one parameters in procedure?

2 Answers  

---

what is mean by confine mode and flexi mode?

2 Answers  

---

what is aim methodolozy

1 Answers   Wipro,

---