OPAL Misc Functions

Miscellaneous functions are those that do not fit in the other categories.

Function	Description
any_null	Returns a null value of type any.
asc	Specify the ordering as ascending when processing data.
coalesce	Return the first non-null argument or null if all are null.
desc	Specify the ordering as descending when processing data.
frame	Specify the approximate relative time frame for a window context.
frame_exact	Specify the exact relative time frame for a window context.
if	Return the second argument if condition# is true, otherwise return third argument.
if_null	Return the second argument if the first argument has the null value.
make_object	Turn a sequence of name:value elements into an object.
on	on is a special function used to specify the join condition for some join verbs.
order_by	Specify the ordering when processing data.