Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7381 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi Suneel,
SELECT * FROM ACCOUNT;
NO NAME AMOUNT
----- ----- ----------
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.00
4 JKLM -4000.00
5 MNOP 5000.00
SELECT NO,NAME,DECODE(SIGN(AMOUNT),1,TO_CHAR(AMOUNT,'9999.99'),-1,0) CREDIT,
DECODE(SIGN(AMOUNT),-1,TO_CHAR(AMOUNT,'9999.99'),1,0) DEBIT FROM ACCOUNT
/
NO NAME CREDIT DEBIT
------ ----- -------- --------
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.00 0
4 JKLM 0 -4000.00
5 MNOP 5000.00 0
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is scalar data type in pl sql?
Differentiate between syntax and runtime errors.
What is your daily office routine?
What is the cause of mutating table error and how can we solve it?
Where is pl sql used?
What is trigger price?
What's the difference between a primary key and a clustered index?
What is the difference between database trigger and stored procedure?
What is the mutating table and constraining table?
What is nosql vs sql?
Explain raise_application_error.
What is the difference between view and stored procedure?
Does asenumerable execute the query?
Name the different types of indexes in sql and define them.
Can we group by two columns in sql?
