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.