select no, name, decode (sign(amount),1 , amount , 0) credit, decode (sig

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 / omi naik

5 Answers
7640 Views
Target, I also Faced
E-Mail Answers

Answer Posted / omi naik

select no, name,
decode (sign(amount),1 , amount , 0) credit,
decode (sign(amount),-1 , amount , 0) debit
from account

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which software is used for pl sql programming?

1034

What is application trigger?

1056

What is a ddl command?

1157

What is record in pl sql?

1140

What is db journal file?

1157

Which is faster union or join?

1027

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1052

explain the advantages and disadvantages of stored procedure? : Sql dba

1067

How to start oracle sql developer?

1076

Do we need to create index on primary key?

966

How to avoid duplicate records in a query?

1055

How many aggregate functions are available there in sql?

1018

What is sql resultset?

1043

How to run sql commands in sql*plus?

1255

Define commit?

1053