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.

in which table sub inventory related information for item is stored?

3 Answers   chain sys, Scan Steel,

---

where u do setup of operating unit?

1 Answers   TCS,

---

what is item status? name the related table.

1 Answers   Scan Steel,

---

WHAT IS REFCURSOR IN ORACLE ?

6 Answers  

---

What is profile and what is level of profile option and it's hierarchy

1 Answers   IBM,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

Can we run a package with out specification?If yes how?

4 Answers  

---

where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---

tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,

---

What are basic steps for AIM?

2 Answers  

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---