OPAL Misc FunctionsΒΆ
Miscellaneous functions are those that do not fit in the other categories.
Function |
Description |
---|---|
Returns a new array that contains only the distinct elements from the input array after removing duplicate elements. |
|
Specify the ordering as ascending when processing data. |
|
Return the first non-null argument or null if all are null. |
|
Specify the ordering as descending when processing data. |
|
Specify the approximate relative time frame for a window context. |
|
Specify the exact relative time frame for a window context. |
|
Return the second argument if condition# is true, otherwise return third argument. |
|
Return the second argument if the first argument has the null value. |
|
Specify the ordering as nulls first when processing data. |
|
Specify the ordering as nulls last when processing data. |
|
|
|
Specify the ordering when processing data. |
|
Return an array with the elements of the input array in sorted order. |
|
Returns a null value of type variant. |