> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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()](/sql-reference/sql-functions/math-functions/abs)                                  | This function returns the absolute value of an argument, regardless of whether it is positive or negative       |
| [CBRT()](/sql-reference/sql-functions/math-functions/cbrt)                                | This function returns the cube root of a given number                                                           |
| [CEIL()](/sql-reference/sql-functions/math-functions/ceil)                                | This function rounds up to the nearest positive or negative integer value greater than or equal to the argument |
| [EXP()](/sql-reference/sql-functions/math-functions/exp)                                  | This function returns the exponential value of a number specified in the argument                               |
| [FLOOR()](/sql-reference/sql-functions/math-functions/floor)                              | This function returns a number rounded down that is less than or equal to the specified argument                |
| [GREATEST()](/sql-reference/sql-functions/math-functions/greatest)                        | This function extracts the greatest or largest value from a set of values.                                      |
| [LEAST()](/sql-reference/sql-functions/math-functions/least)                              | This function returns the least or smallest value in a list of values                                           |
| [LN()](/sql-reference/sql-functions/math-functions/ln)                                    | This function returns the exponential value of its argument                                                     |
| [LOG()](/sql-reference/sql-functions/math-functions/log)                                  | This function returns the base-10 logarithm or logarithm of the specified base of a given number                |
| [POWER()](/sql-reference/sql-functions/math-functions/power)                              | This function returns the value of a number raised to the power of another number specified in the arguments    |
| [RANDOM()](/sql-reference/sql-functions/math-functions/random)                            | This function returns a random number between 0 (inclusive) and 1 (exclusive)                                   |
| [ROUND()](/sql-reference/sql-functions/math-functions/round)                              | This function rounds numbers to the nearest integer or to a specified number of decimal places                  |
| [SIGN()](/sql-reference/sql-functions/math-functions/sign)                                | This function returns -1 for negative arguments, 1 for positive arguments or 0 if the argument is 0             |
| [SIN()](/sql-reference/sql-functions/math-functions/sin)                                  | This function returns the trigonometric sine value of a specified angle in radians                              |
| [SQRT()](/sql-reference/sql-functions/math-functions/sqrt)                                | This function returns the square root of its argument                                                           |
| [BITWISE SHIFT LEFT](/sql-reference/sql-functions/math-functions/bitwise-shift-left)      | This operator manipulate the bits of integer values by shifting them left                                       |
| [BITWISE SHIFT RIGHT](/sql-reference/sql-functions/math-functions/bitwise-shift-left)     | This operator manipulate the bits of integer values by shifting them right                                      |
| [TO\_CHAR() from Number](/sql-reference/sql-functions/math-functions/to-char-from-number) | Formats a number into a string using a given format                                                             |