I have a requirement to convert the postive value to negative and negative value to positive, and if its 0, then leave it as it is. I can do it in sql, just need to know if there is a better way / alternative way to do this?
create table test_tab
(a number);
insert into test_tab values (10);
insert into test_tab values (-10);
insert into test_tab values (0);
insert into test_tab values (10.15);
insert into test_tab values (-10.15);
select a , decode(sign(a),-1,abs(a),1,-abs(a),0) "changed value" from test_tab;
Oracle Database - 11g
source
share