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!

CEIL and FLOOR opeartions decimal numbers

PadmaMay 26 2011 — edited Sep 14 2012
Hi All

I want to round up and round down numbers using Pl/SQL

Oracle provides inbuilt functiion for these (CEIL and FLOOR) but they return whole numbers.
I want to round up/down decimal numbers

Ex. say 100.533457 if we round up this to 3 decimals the output is 100.534

if round down out put should be 100.553

pls tell me how to this using pl/sql

Tx
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2012
Added on May 26 2011
14 comments
29,073 views