where条件中字段为空的判断

正确的判断：

select 1 as value from dual where 'a' is not null; 

错误的判断：

select 1 as value from dual where 'a'<>'';select 1 as value from dual where 'a'!='';均不能取得结果，与ms sql 不同。