Algebraic functions take one or more arguments of numeric data
types. Besides supporting numeric arguments, the CEIL and FLOOR functions
can also take character string arguments that can be converted to
DECIMAL values, and the ROUND and TRUNC functions can
also take DATE or DATETIME arguments.
Algebraic Functions
Element
Description
Restrictions
Syntax
base
Value to be raised to the power specified in exponent
Number of significant digits to replace with zero
in the returned value. Default is to return the rounded or truncated
integer part of the first argument.
Integer in range +32 to -32. Positive or unsigned
values are applied to the right of the decimal point, and negative
values are applied to the left.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.