case语句报错帮忙看看
case when TableName.Colunme1 in (select aaa from Table1 ) then '1' when TableName.Colunme1 not in (select aaa from Table1 ) then '0' end
case when TableName.Colunme1 in (select aaa from Table1 ) then '1' when TableName.Colunme1 not in (select aaa from Table1 ) then '0' end
解决方案 »
- 新人求教,如何写存储过程???
- #程序读us7ascii字符集数据库,返回结果中文变成乱码的问题
- LINUX OCI8 配置 和 ORACLE 客户端安装
- 使用.. over (partition by..)遇到的问题
- 求个select语句
- win2003下的oracle10.2数据库实例有时会停掉,哪些方面找原因?
- 为什么oracle存储过程非要带参数???
- 调查问卷建库,每个问题一条记录,但每个问题可多选,显示时答案要分开显示,那位高人指点,如何处理?
- Oracle8i如何卸载???
- 关于oracle登录的问题!!~~
- 存储过程游标问题,高手来帮忙啊!
- oracle错误:SQLSTATE=23505 请高手帮忙!
case when EXISTS (select ‘0’ from Table1 WHERE aaa = TableName.Colunme1) then '1' ELSE when NOT EXISTS (select aaa from Table1 WHERE aaa = TableName.Colunme1) then '0' end
select decode((select count(*)
into i
from Table1
where aaa = TableName.Colunme1),
0,
0,
1)
from dual