日期:2014-05-17 浏览次数:20976 次
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);