sql查询test表中字段card 为null的语句:
select * from test where card is null;
查询test表中字段card 不为null的语句:
select * from test where card is not null;
但是在oracle中,如果字段时字符串类型,空字符串本身就代表null,所以不能用<>、!=、=等来比较空字符串所以
查询test表中字段card为空字符串的语句:
select * from test where card is null;
查询test表中字段card为空格字符串的语句:
select * from test where replace(card,' ','') is null;