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 FUNCTIONSEvaluate logical conditions and return TRUE, FALSE OR NULL
MATH FUNCTIONSPerform mathematical operations on numeric data, such as rounding, exponentiation calculation
STRING FUNCTIONSManipulate string data for text processing, including concatenation, substring extraction and case conversion
TIMESTAMP FUNCTIONSHandle data and time values including extracting components, adding intervals and comparing timestamps
TRIGONOMETRIC FUNCTIONSPerform calculations using trigonometric ratios, such as sine, cosine and tangent
JSON FUNCTIONSManipulate and query JSON data stored in the database, including extracting values and creating JSON objects
AGGREGATE FUNCTIONSSummarize a set of values and return a single result, such as calculating sums, averages and counts
WINDOW FUNCTIONSOperate over a subset of rows defined by a windowing clause, enabling ranking, aggregation and row numbering within result sets
OTHER FUNCTIONSIncludes a variety of specialized functions not categorized elsewhere