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!

Need to get only decimal values upto 2 digits?

994122Jan 5 2015 — edited Jan 5 2015

Hi,

I need to get value from -111.34 the out put should be 34 and if the value is like this (-111) then out put should be 00

Where i am passing values as order_number=1234 then the above is need to be work

Thanks

This post has been answered by John Stegeman on Jan 5 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2015

Added on Jan 5 2015

14 comments

794 views