select sno,name,decode(sign(amount),1,0,amount)debit,decode (sign(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
Suneel Reddy

Question Posted / saravana sundar

6 Answers
8492 Views
Target, I also Faced
E-Mail Answers

Answer Posted / saravana sundar

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

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use sql*plus built-in timers?

1201

how would concatenate strings in mysql? : Sql dba

1095

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3570

What is the difference between sql and t sql?

1036

What are the different types of constraints?

1187

discuss about myisam key cache. : Sql dba

1022

What are sql queries used for?

1024

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1582

what is data control language? : Sql dba

1028

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

929

How can we optimize a sql query?

1052

What is sql keyword?

1004

Is oracle and sql same?

1013

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

980

What is the usage of when clause in trigger?

1057