Language Reference Guide : Language Elements : System-defined Functions
 
Share this page          
System-defined Functions
OpenROAD supports the following functions:
All SQL functions except for the table_key and object_key scalar functions
A non-SQL function, the field function
There are four types of SQL functions:
Scalar functions, which take single-valued expressions as their arguments, can be used in all OpenROAD statements and in all SQL statements that are used within OpenROAD.
Aggregate functions, which take a set of values (for example, the contents of a column in a table) as their arguments, can only be used in OpenROAD within SQL statements.
The ifnull function
The dbmsinfo function
These functions are described in the following subsections.