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!

Remove decimals

user263656Jan 30 2009 — edited Jan 30 2009
Hi guys
You might probably find this very easy but please forgive me if you do. I have a value with decimal places and I want to remove those decimals. What command do I use to do this?
 <select 12.54 from dual> 
The select above returns 12.54 and I want to return 1254. How do I do this?

Thanks for all your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2009
Added on Jan 30 2009
7 comments
372 views