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.