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,

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

Why is sql better than hql?

0 Answers  

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What is the trigger in sql?

0 Answers  

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

What is the use of partition by in sql?

0 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

How do I find sql profiler?

0 Answers  

---

What is the process of copying data from table a to table b?

0 Answers  

---