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.

Can you have two stored functions with in the same name?

3 Answers  

---

what is instead of trigger. what is the use of that?

3 Answers  

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

what is the difference between request group and request security in oracle apps?

1 Answers  

---

How to insert data into two tables using single control file?

3 Answers   Oracle, VTI,

---

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,

---

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,

---

What is a flexfield? List out its types.

0 Answers  

---

wht r the basetables of customer interface?

2 Answers  

---

What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,

---

How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  

---

Which is the best website to learn Oracle Apps?

2 Answers  

---