在Oracle中,如果表的某一条数据的字段A值为空,以A值为条件查询的话,不管条件是 A='XXX' 还是 A<>'XXX' 都查不到该条数据:
select * from table where A='XXX'
select * from table where A<>'XXX'
可以用nvl函数将A转换后再比较
select * from table where nvl(A,0)='XXX'
或者
select * from table where A is null or A='XXX'
select * from table where A='XXX'
select * from table where A<>'XXX'
可以用nvl函数将A转换后再比较
select * from table where nvl(A,0)='XXX'
或者
select * from table where A is null or A='XXX'