Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

scope of exception handling in plsql

4 Answers   Wipro,

---

Explain cursor types?

0 Answers  

---

Is not null in sql?

0 Answers  

---

What is the current version of postgresql?

0 Answers  

---

---

Explain the difference between rename and alias?

0 Answers  

---

What is the difference between clustered and non-clustered indexes?

0 Answers  

---

What is trigger in sql? Explain

0 Answers  

---

Where do we use pl sql?

0 Answers  

---

Where not exists in sql?

0 Answers  

---

How to start oracle sql developer?

0 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---