17,377
社区成员
发帖
与我相关
我的任务
分享
with temp as
(
select '文化交流传播有限公司司' s from dual
union
select '文化交流传播有限公公司' s from dual
union
select '文化交流传播有限限司' s from dual
union
select '文化交流传播有有限司' s from dual
)
select *
from (select substr(s, rownum, 1) mid
from temp
connect by rownum <= length(s))
group by mid
having count(*) > 1;
Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0
Connected as cvbom6
SQL>
SQL> select substr(s, rownum, 1)
2 from (select '文化交流传播有限公司司' s from dual)
3 connect by rownum <= length(s);
SUBSTR(S,ROWNUM,1)
------------------
文
化
交
流
传
播
有
限
公
司
司
11 rows selected
SQL>
SQL> select *
2 from (select substr(s, rownum, 1) mid
3 from (select '文化交流传播有限公司司' s from dual)
4 connect by rownum <= length(s))
5 group by mid
6 having count(*) > 1;
MID
---
司
SQL>