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)
解决方案 »
- 修改表记录时报record is locked by another user
- 怎么输入conn / as sysdba就登录数据库了?密码呢?
- 请教oracle按时间分组查询语句的写法
- Oracle中内连接和外连接如何同时使用?急!
- 一个连接oracle 中文乱码的问题
- 求sql语句....高分相送 急
- 紧急—通过ODBC方式在IIS记录日志,用SQL SERVER可以。但是用Oracle却不能导入?
- vtk-1000 无法连接到 managerment server mydb?
- 急急!!PB中连接oracle时提示“Error while retrieve text for error ora-12154”?
- 各位朋友帮个忙!我刚装完oracle9i可是进不去为什么?
- 函数
- 为什么会出现这种错误,我的SQL语句是正确的?在线等。
(select count(*) from tbname where class like '001002001%' and length(class)=length('001002001')),0,'final class','not final') from dual;