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 are profile options?

4 Answers   Accenture,

---

FLEX FIELDS?

2 Answers  

---

wht is format triger?

4 Answers  

---

what is the diff between custom.pll and form personalization? Tell me one example?

4 Answers   Oracle,

---

in procedure how to return a value

2 Answers   Wipro,

---

tell me the scenarios of the independent in reports

0 Answers   Accenture, IBM,

---

what are the different calculation columns available in reports?

1 Answers  

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---

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

3 Answers  

---

What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,

---