Toad World® Forums

Display NULL values


#1

If you have the “Display NULL values as (null)” option turned on, you normally see the “(Null)” value in a slight orange color, but if it’s the first column has a null value, it’s displayed as the default font color.

Just execute the following SQL and you will notice

SELECT NULL c1, ‘asd’ c2 FROM DUAL
UNION ALL
SELECT ‘asd’ c1, NULL c2 FROM DUAL

Regards

select null c1, ‘asd’ c2
from dual


#2

Hi rsanchez,

Thank you for reporting this issue.

Yes I can see it works as you said, the first column doesn’t show orange color for NULL value.

I have raised PT#52100759 for it, once we fix it will let you know.

Thanks,

Shirly


#3

thanks!