CEIL and FLOOR opeartions decimal numbers
PadmaMay 26 2011 — edited Sep 14 2012Hi 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