您好,因为不太清楚您那边的表结构以及数据,我这边简单测试了一下,是没问题的
create table t_test (id int, delete_flag varchar2(10));
insert into t_test values (1,‘0’);commit;
insert into t_test values (2,‘1’);commit;
insert into t_test values (3,‘0’);commit;
insert into t_test values (3,null);commit;
select * from t_test a where a.id = 1 and nvl(a.delete_flag,‘0’)= ‘0’;
这个delete_flag字段应该是标记位吧,能不能这样写
select * from t_test a where a.id = 1 and a.delete_flag is null;试一下,如果可以的话,可以发下表结构吗?
您好,因为不太清楚您那边的表结构以及数据,我这边简单测试了一下,是没问题的
create table t_test (id int, delete_flag varchar2(10));
insert into t_test values (1,‘0’);commit;
insert into t_test values (2,‘1’);commit;
insert into t_test values (3,‘0’);commit;
insert into t_test values (3,null);commit;
select * from t_test a where a.id = 1 and nvl(a.delete_flag,‘0’)= ‘0’;
这个delete_flag字段应该是标记位吧,能不能这样写
select * from t_test a where a.id = 1 and a.delete_flag is null;试一下,如果可以的话,可以发下表结构吗?