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.

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---

What is the interface?

3 Answers  

---

why do we validate the records while developing interface?

3 Answers   TCS,

---

in procedure how to return a value

4 Answers  

---

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---

how to initialize applications?

2 Answers  

---

can we pass bind variablein lexical parameter?

1 Answers   BirlaSoft,

---

PL/SQL stored procedure parameters?

7 Answers  

---

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

1 Answers   TCS,

---

HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION

1 Answers   TCS,

---

where we can check the status of po.

4 Answers  

---