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,

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---

How are functions and procedures called in PL/SQL?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

Explain what is rdbms?

0 Answers  

---

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

What is execute immediate?

0 Answers  

---

What port does sql server use?

0 Answers  

---

what is an associative array with example?

1 Answers  

---