正确的判断:
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 不同。
正确的判断:
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 不同。