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 procedure how to return a value

3 Answers  

---

I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.

3 Answers   IBM,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

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

3 Answers  

---

where the accounting related data is stored ?

2 Answers  

---

---

what is meant by anchoring?

3 Answers  

---

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers  

---

Where I can download D2K software?

2 Answers  

---

what is lexical parameter?

3 Answers   TCS,

---

name all status attributes.

1 Answers   Scan Steel,

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---