select nvl( '', 'Yes '''' is null' ) "Evaluate"
SQL> SQL> select nvl( '', 'Yes '''' is null' ) "Evaluate" 2 from dual 3 / Evaluate -------------- Yes '' is null 1 row selected. SQL> SQL> --