Print      Open PDF Version of Online Help


Previous Topic

Next Topic

IfNull

The 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.

Syntax

IfNull(expr1, expr2)

Result Type

The 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.

Arguments

The following table describes the arguments for the function.

Argument

Description

expr1

A field name or expression.

expr2

The field name or expression that is returned if expr1 is NULL.

Related Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.