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,

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

How to return an array from java to pl/sql?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

define sql

3 Answers   Zensar,

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

What are the different operators available in sql?

0 Answers  

---

How to return multiple records from procedure?

2 Answers  

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

What are the two parts of design view?

0 Answers  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---