Numeric Functions

Name(parameters)	Parameter Domain	Description	Example
decimal(n, scale)	number, number1	return n with given scale	decimal(1/3, 2) = .33 decimal(1.5, 0) = 2 decimal(2.5, 0) = 2
floor(n)	number	return greatest integer <= n	floor(1.5) = 1 floor(-1.5) = -2
ceiling(n)	number	return smallest integer >= n	ceiling(1.5) = 2 ceiling(-1.5) = -1