What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

What is the use of function "module procedure" in pl/sql?

0 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

how to rename an existing table in mysql? : Sql dba

0 Answers  

---

What is varray in pl sql?

0 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

How can check sql version from command line?

0 Answers  

---

How to use boolean type in select statement?

0 Answers  

---

What is a stored procedure ?

9 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

What is pl sql architecture?

0 Answers  

---