Function expressions

Function expressions allow you to use any built-in SQL function or a custom function as an expression.

The following are some valid built-in function expressions:

• LENGTH('OCEAN1BASE')

• ROUND(1234.5678*49)

• SYSDATE

A custom function expression may call:

• A function in a custom package, type, or standalone custom function

• A custom function or operator

The following are some valid custom function expressions:

• circle_area(radius)

• payroll.tax_rate(emp_name)

• hr.emp.comm_pct@remote(dependents, empid)

• DBMS_LOB.getlength(col_name)

• my_function(a_column)

When you use a custom function as an expression, you can use positional notation, name notation, and mixed notation. For example, the following notations are correct:

CALL my_function(arg1 => 3, arg2 => 4) ...
CALL my_function(3, 4) ...
CALL my_function(3, arg2 => 4) ...