Hi Suneel, SELECT * FROM ACCOUNT; NO NAME AMOUNT ----- -

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

Question Posted / srinu

5 Answers
7064 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

Please Help Members By Posting Answers For Below Questions

What is pl sql and why it is used for?

1073

What is a temporal table?

882

Explain the purpose of %type and %rowtype data types?

876

How do I create an index in word?

968

What is thread join () in threading?

948

Why use triggers in sql?

897

What is difference between stored procedure and trigger?

1061

Can you sum a count in sql?

956

What is oracle sql developer?

994

What does t sql mean?

898

What are the types of dbms?

922

What are inner outer left and right joins in sql?

965

How do you modify a column in sql?

943

What is the use of count (*) in sql?

983

what is bcp? When does it used? : Sql dba

935