IfNullThe IfNull function in Expression Builder returns the value from the first argument that is passed to the function. If the first argument returns NULL, the value from the second argument is returned. SyntaxIfNull(expr1, expr2) Result TypeThe result type of the IfNull function is the type of its first argument, even if the first argument is NULL. The second argument is converted to the type of the first argument before its value is returned. ArgumentsThe following table describes the arguments for the function.
Related TopicsSee the following topics for related Expression Builder information: |
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |