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 (“”).