select *
from ttt
where (substr(substr(code, length(code) - 4 + 1, 4),1,2) =substr(substr(code, length(code) - 4 + 1, 4),3,2)
or (substr(substr(code, length(code) - 4 + 1, 4),1,1) =substr(substr(code, length(code) - 4 + 1, 4),2,1)
and substr(substr(code, length(code) - 4 + 1, 4),3,1) =substr(substr(code, length(code) - 4 + 1, 4),4,1)))
and substr(substr(code, length(code) - 4 + 1, 4),1,1) in ('6','8','9')
and substr(substr(code, length(code) - 4 + 1, 4),4,1) in ('6','8','9')
from ttt
where (substr(substr(code, length(code) - 4 + 1, 4),1,2) =substr(substr(code, length(code) - 4 + 1, 4),3,2)
or (substr(substr(code, length(code) - 4 + 1, 4),1,1) =substr(substr(code, length(code) - 4 + 1, 4),2,1)
and substr(substr(code, length(code) - 4 + 1, 4),3,1) =substr(substr(code, length(code) - 4 + 1, 4),4,1)))
and substr(substr(code, length(code) - 4 + 1, 4),1,1) in ('6','8','9')
and substr(substr(code, length(code) - 4 + 1, 4),4,1) in ('6','8','9')
解决方案 »
- [急切求助]Select调用Function,这个Function还可以写数据库么?
- oracle存储过程包与包主体实例,求助。。。。
- 哪里有oracle数据库设计文档下载?
- 碰到一个比较棘手的问题,动态sql超过32K
- 问个sql问题 急急急急急急!!!
- 求一个存储过程
- 初学oracle,一个很菜的问题
- BLOB字段读写,急
- 用尽的 Resultset 这个提示?
- 【oracle】查询sendTime字段大于当前系统时间20分钟,小于3天的数据,求帮助。
- 女朋友强烈要求我。。。。。。 但是 我不认输 进者给分 免费放送经典的娱乐搞笑 各位兄弟姐妹 你们辛苦了 工作之余 记得休息哦
- 各位大侠指点
select code,
substr(substr(code, length(code) - 4 + 1, 4), 1, 1) col1,
substr(substr(code, length(code) - 4 + 1, 4), 2, 1) col2,
substr(substr(code, length(code) - 4 + 1, 4), 3, 1) col3,
substr(substr(code, length(code) - 4 + 1, 4), 4, 1) col4
from tttt)
where ((col1 = col2 and col3=col4) or (col1 = col3 and col2=col4))
and col1 in ('6','8','9')
and col4 in ('6','8','9')