OPAL Misc Functions

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

Function	Description
array_distinct	Returns a new array that contains only the distinct elements from the input array after removing duplicate elements.
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.
nullsfirst	Specify the ordering as nulls first when processing data.
nullslast	Specify the ordering as nulls last when processing data.
on	on is a special function used to specify the join condition for some join verbs.
order_by	Specify the ordering when processing data.
sort_array	Return an array with the elements of the input array in sorted order.
variant_null	Returns a null value of type variant.