Display Null Value As

Toad Data Point
1

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

2

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