1、创建测试表,
create table test_null(id varchar2(20),value varchar2(20));
2、插入测试数据;
insert into test_null values(1,'123');
insert into test_null values(2,'abc');
insert into test_null values(3,'');
insert into test_null values(4,'456');
3、查询表中全量数据;select t.*, rowid from test_null t;
4、编写语句,查询表中value为空的记录;
select t.*, rowid from test_null t where value is null;