Oracle _ single row function _ numeric Function
1. abs (x)
Used to obtain the absolute value of x
2. ceil (x)
Returns the smallest integer greater than or equal to x.
3. floor (x)
Used to obtain the maximum integer less than or equal to x
4. mod (x, y)
Used to calculate the remainder obtained by dividing x by y.
5. power (x, y)
Used to calculate the Power y of x
6. round (x, y)
Used to calculate the rounded result of x
Optional Parameter y: indicates the number of decimal places to be rounded up. If y is not specified, x is rounded up at 0 decimal places.
If y is negative, x is rounded to the | y | bit on the left of the decimal point.
7. sign (x)
Used to obtain the x symbol
If x is negative,-1 is returned. If x is positive, 1 is returned. If x is 0, 0 is returned.
8. sqrt (x)
Used to calculate the square root of x
9. trunc (x)
Used to calculate the result of x Truncation
Optional Parameter y: specifies the number of decimal places to be truncated. If y is not specified, x is truncated at 0 decimal places.
If y is a negative number, x is truncated at | y | bit on the left of the decimal point.