Toad World® Forums

Display Null Value As

Is there a way in Toad Data Point to show a null value as a specific string? The Oracle SQL Developer equivalent would be Tools > Preferences > Database > Advanced “Display Null Value As”.

You can do that programmatically.

Option 1:

, CASE WHEN SCHEMA.FIELDNAME IS NULL THEN NULL END

Option 2:

, CASE WHEN SCHEMA.FIELDNAME IS NULL THEN ‘’ END