Answer / bunty

dbms_output.put_line can be used in Packages, Procedures or
triggers to display message or variable values which can be
used as debugging tool.

Cheers,
Bunty

Does sql*plus have a pl/sql engine?

0 Answers  

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

What is the need of a partition key?

0 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What are sql queries used for?

0 Answers  

---

What is the purpose of a sql?

0 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 difference between count 1 and count (*) in a sql query?

0 Answers  

---

What are the operators used in select statements?

0 Answers  

---

How do I view a sql trace file?

0 Answers  

---