Function Expressions

Function expressions enable you to use any built-in SQL function as an expression.

The syntax for a function expression is as follows:

function_name ( [ expr [, expr ]... ] )

The following are some valid functional expressions:

• LENGTH('OCEANBASE')

• ROUND(1234.5678, 2)

• NOW()

• CONCAT(first_name, ' ', last_name)

• ABS(salary - 5000)

Function expressions support the use of window functions. The syntax for window functions is as follows:

function_name ( [ expr [, expr ]... ] ) OVER ( window_spec )

For more information about window functions, see Analytical functions.