SQL Functions

In this section, we will understand how functions work in Oxla, how to create a function command, learn about inputs and return types and explore various functions usage.

The following table summarizes the functions supported by Oxla:

Function Name	Description
BOOLEAN FUNCTIONS	Evaluate logical conditions and return TRUE, FALSE OR NULL
NUMERIC FUNCTIONS	Perform mathematical operations on numeric data, such as rounding, exponentiation calculation
STRING FUNCTIONS	Manipulate string data for text processing, including concatenation, substring extraction and case conversion
TIMESTAMP FUNCTIONS	Handle data and time values including extracting components, adding intervals and comparing timestamps
TRIGONOMETRIC FUNCTIONS	Perform calculations using trigonometric ratios, such as sine, cosine and tangent
JSON FUNCTIONS	Manipulate and query JSON data stored in the database, including extracting values and creating JSON objects
AGGREGATE FUNCTIONS	Summarize a set of values and return a single result, such as calculating sums, averages and counts
WINDOW FUNCTIONS	Operate over a subset of rows defined by a windowing clause, enabling ranking, aggregation and row numbering within result sets
OTHER FUNCTIONS	Includes a variety of specialized functions not categorized elsewhere