Display Null Query Result With an Alternate Text

[Jbaskin]

Hi,

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

[id10t]

Hi!

vsql has inner help - `\?`

Code: Select all

dbadmin=> \pset null 'N/A'
Null display is "N/A".
dbadmin=> select NULL from DUAL;
 ?column? 
----------
 N/A
(1 row)

[Jbaskin]

Thanks, skwa! That's exactly what I needed!