oracle11g - Dsiplaying white space when value is null for a view Oracle/SQL -

i new oracle , sql. wondering though if there way can display empty string when value null.

i rather value blank having (null) show up. realized nvl2(name,name,' ') "name" trick almost. works changes value ' '. not trying change null ' ' display on view. possible?

thank in advance.

this work:

select     case when name null ' ' else name end     test; 

http://sqlfiddle.com/#!9/6191fb/5