Why use triggers in sql?

0 Answers  

---

What is a clob in sql?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

What are the types of sql commands?

0 Answers  

---

What is trigger and how to use it in sql?

0 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

Where is all the data on the internet stored?

0 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What are the indexing methods?

0 Answers  

---

How do I find duplicates in a single column in 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,

---