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.