Answer / mkumar.it

select no, name,
case amount/abs(amount) when 1 then amount else 0 end credit,
case amount/abs(amount) when -1 then amount else 0 end Debit
from account

Answer / saravana sundar

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

Answer / ehtesham malik

Select no,name, 0 Debit, amount Credit
from temp
where amount >0
union
Select no,name, amount Debit, 0 Credit
from temp
where amount < 0

Answer / shailesh

SELECT NO,NAME,DECODE(GREATEST
(AMOUNT,0),0,AMOUNT,0) "DEBIT",DECODE(GREATEST
(AMOUNT,0),0,0,AMOUNT) "CREDIT" FROM ACCOUNT

Answer / john bershan

@ mkumar.it

the query which you have posted will work if the amount
value is greater than zero and will not work in the case
when the vale s zero as it will throw divisor is equal to
zero.please check it.

Answer / suresh kumar somayajula

Select No,Name,to_char(Sal,'$9999.99') amount from emp;

Can we perform dml on view?

0 Answers  

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

what is the command for user data type?

2 Answers  

How to call DDL statements from pl/sql?

5 Answers  

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

What are views in sql?

0 Answers  

What are reports usually used for?

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

Can we create foreign key without primary key?

0 Answers  

What operating systems are supported by oracle sql developer?

0 Answers