select 'is' from dual where '001001' not in (select substr(class,1,length(class)-3) from tbname)
union all
select 'not' from dual where '001001' in (select substr(class,1,length(class)-3) from tbname)
union all
select 'not' from dual where '001001' in (select substr(class,1,length(class)-3) from tbname)
解决方案 »
- oracle一步实现更新操作
- oracle 查找包含某字符的function或procedure
- Oracle选题征稿
- create index..(bsm asc) 与create index ..(bsm)的区别
- ps = conn.prepareStatement(sql,1005,1008);
- 求助:判断表tb是否存在,存在则删除
- 写了个存储过程,有些问题,大家帮忙看看
- type_scroll_sensitive 和 type_scroll_insensitive真的不相同吗?
- 我的sql语句中的表如果有双引号就可以,没有的话就会抱不存在?
- Asp.NET调用存储过程报PLS-00201: identifier must be declared错误的问题
- 函数
- 为什么会出现这种错误,我的SQL语句是正确的?在线等。
(select count(*) from tbname where class like '001002001%' and length(class)=length('001002001')),0,'final class','not final') from dual;