在Oracle中怎么判断字段是否为空

[yul26]

在Oracle中有没有函数判断字段是否为空，就像SQLServer中的IsNull一样，急，谢谢

[mydeer]

nvl()

[smallcrocodile]

is null
nvl()

[beckhambobo]

is null

[BlueSuperMan]

is null

[chanet]

select * from table1 where field1 is null;

[pengdali]

select * from table1 where field1 is null;

select * from table1 where field1 is not null;




isnull:



select nvl(xx,'默认') from table1;

[zltion]

nvl(data,1);
not colnum is null;