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 Suneel Reddy

6 Answers   Target,

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

when normalization is required

3 Answers   HCL,

---

what is dbms? : Sql dba

0 Answers  

---

what is global table

7 Answers   iFlex,

---

---

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,

---

What is normalisation in sql?

0 Answers  

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

what is 'mysqldump'? : Sql dba

0 Answers  

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---