Oracle SQL
-
编辑 删除
NULL 和 ''
NULL 和 ''SELECT * FROM T1 WHERE B = '';SELECT * FROM T1 WHERE B IS NULL;
-
编辑 删除
like 通配符
create table t1(a int,b varchar2(10));insert into t1 values(1,'F');insert into t1 values(2,' F');insert into t1 values(3,'F ');insert into t1 values(4,'');insert into t1 values(5,NULL);SELECT * FROM T1;SELECT * FROM T1 WHERE B LIKE '%';SELECT * FROM T1 WHERE B LIKE '%F%';SELEC...
