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!
Hi ,
I have a requirement to round off values as follows
93.45 -- should be 94
93.4 -- should be 93
93.8 -- should be 94
I have written a query as follows and works fine.
select round(round( (93.451),1)) from dual;
Do you have any other suggestions?