Is there a way that I can display a NULL result from a query as some sort of alternate text in vsql?
Oracle has a feature in SQL*Plus where I type SET NULL = 'N/A' and from that point on all NULLs are replaced with the text 'N/A'.
Example in Oracle:
Code: Select all
SQL> SET NULL = 'N/A'
SQL> SELECT NULL mycol FROM dual;
mycol
-----
N/A