oracle number类型null值的大小验证:
select null a From dual
union
select 1 a From dual
union
select 3 a From dual
union
select 5 a From dual
union
select 10 a From dual
)
select * from temp where 1=1
-- and a = null --无结果
-- and a is not null --查询到null记录
and a<11 --查不到null记录
总结:null比任何数值大