Math
Overview
Mathematical functions and Operators in Oxla are designed to perform mathematical calculations and manipulate integer or floating-point numbers. Oxla supports the following math functions:
| Function | Description |
|---|---|
| ABS() | This function returns the absolute value of an argument, regardless of whether it is positive or negative |
| CBRT() | This function returns the cube root of a given number |
| CEIL() | This function rounds up to the nearest positive or negative integer value greater than or equal to the argument |
| EXP() | This function returns the exponential value of a number specified in the argument |
| FLOOR() | This function returns a number rounded down that is less than or equal to the specified argument |
| GREATEST() | This function extracts the greatest or largest value from a set of values. |
| LEAST() | This function returns the least or smallest value in a list of values |
| LN() | This function returns the exponential value of its argument |
| LOG() | This function returns the base-10 logarithm or logarithm of the specified base of a given number |
| POWER() | This function returns the value of a number raised to the power of another number specified in the arguments |
| RANDOM() | This function returns a random number between 0 (inclusive) and 1 (exclusive) |
| ROUND() | This function rounds numbers to the nearest integer or to a specified number of decimal places |
| SIGN() | This function returns -1 for negative arguments, 1 for positive arguments or 0 if the argument is 0 |
| SIN() | This function returns the trigonometric sine value of a specified angle in radians |
| SQRT() | This function returns the square root of its argument |
| BITWISE SHIFT LEFT | This operator manipulate the bits of integer values by shifting them left |
| BITWISE SHIFT RIGHT | This operator manipulate the bits of integer values by shifting them right |
| TO_CHAR() from Number | Formats a number into a string using a given format |