SET NULL

Syntax

SET NULL <text>;

Description

Defines the string for displaying NULL values in tables. Preset to an empty field. This setting is only used for columns that have not had a different representation of NULL values defined with the COLUMN statement.

Examples

SQL_EXA> set null EMPTY;
SQL_EXA> select NULL from dual;