日期:2014-05-17 浏览次数:21126 次
String queryString = " from TProject where nvl(submit,'no') <> 'yes'
------解决方案--------------------
String queryString = " from TProject where nvl(submit,'no') = 'no' ";
------解决方案--------------------
from TProject where nvl(submit,'no') = 'no'
就是
select * from TProject where submit is null;
------解决方案--------------------
CREATE TABLE TProject
(
ID NUMBER(4),
sub VARCHAR2(20)
);
INSERT INTO TProject VALUES(1, 'yes');
INSERT INTO TProject VALUES(2, 'no');
INSERT INTO TProject VALUES(3, NULL);