Replacing Null 


Sometimes a column returns null values. By using the Oracle SQL function NVL, null values can be replaced with another value.

Note: The following example only applies to data retrieved from an Oracle database.

  1. Right-click on the column in the Elements tree.

  2. Select Edit from the pop-up menu.

  3. In the Expression field, type:

    NVL(%1,0)

  4. Click Save.

Note: Sometimes a null value has a meaning different from zero, such as "value unknown". Make sure you understand how the data is meant to be interpreted before replacing values!

See also:

Creating a Column Element

Column Element Tab