2 from dual
3 connect by level <= length('1,2,2,2,2,2,1') -
4 length(replace('1,2,2,2,2,2,1', ',', '')) + 1;
CN
--------------------------
1
2
2
2
2
2
1
SQL> select decode(cn, 1, '相同', '不相同')
2 from (select count(distinct
3 regexp_substr('1,2,2,2,2,2,1', '[^,]', 1, level)) cn
4 from dual
5 connect by level <= length('1,2,2,2,2,2,1') -
6 length(replace('1,2,2,2,2,2,1', ',', '')) + 1)
7 ;
DECODE
------
不相同
SQL>
SQL> select decode(cn, 1, '相同', '不相同')
2 from (select count(distinct
3 regexp_substr('2,2,2,2,2', '[^,]', 1, level)) cn
4 from dual
5 connect by level <= length('2,2,2,2,2') -
6 length(replace('2,2,2,2,2', ',', '')) + 1)
7 ;
DECODE
------
相同