About
Set null defines how nulls are displayed in a oracle result set :
set null text
Use the NULL clause of the COLUMN command to override the setting of the NULL variable for a given column. The default output for a null is blank (“”).
SQL Plus - Set Null
