In Oracle Database, the TRUNC(number) function returns a given number, truncated to a given number of decimal places.
Oracle also has a TRUNC(date) function, which is used on dates. This article is solely about the TRUNC(number) function, which is used on numbers.
In Oracle, the SIGN() function returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive, and also depending on whether the argument is of type NUMBER or a floating-point number.
In Oracle, the TANH() function returns the hyperbolic tangent of its argument.
In Oracle, the TAN() function returns the tangent of its argument, where the argument is an angle expressed in radians.
In Oracle, the NANVL() function allows us to deal with NaN values by specifying another number to return in its place.
The way it works is, it accepts two arguments. If the first argument is NaN (not a number), it returns the second argument. If the first argument is a number, then it simply returns that number.
Note that this function is useful only for floating-point numbers of type BINARY_FLOAT or BINARY_DOUBLE.
In Oracle, the SQRT() function returns the square root of its argument.
In Oracle, the SINH() function returns the hyperbolic sine of its argument.
In Oracle, the SIN() function returns the sine of its argument, where the argument is an angle expressed in radians.
In Oracle, the POWER() function returns its first argument raised to the power of its second argument.
In Oracle, the REMAINDER() function returns the remainder of its first argument divided by its second.
It’s similar to the MOD() function, except that it uses ROUND() in its calculation, whereas MOD() uses FLOOR() in its calculation.