Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Subtracting two columns

944524Jul 2 2015 — edited Jul 3 2015

I am using below query to subtract two columns is there a way forward to handle negative subtraction

select col_1 - col_2 from table;

if 0-25 then return as +25 instead of -25 or anything subtracting lesser should consider maximum value to be subtracted

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2015
Added on Jul 2 2015
2 comments
5,629 views