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,

---

Which are the different case manipulation functions in sql?

0 Answers  

---

Can we use loop in sql?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

What are the possible values for the boolean data field?

0 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

How many types of cursors supported in pl/sql?

0 Answers  

---

what is “go” in t-sql? : Transact sql

0 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

How do you optimize a stored procedure query?

0 Answers  

---

What is forward declaration in pl sql?

0 Answers  

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---