select level from dual connect by level <=5;
select regexp_count('ab,de,fg',',') from dual;
select regexp_count('ab$cd$ef','\$') from dual;
select length(regexp_replace('ab,de,fg','[^,]')) from dual;
select content from tb_cy_content where regexp_like(content,'^[0-9a-zA-Z]+$'); -- regexp_like(a,'b')对应like '%A%'
select regexp_replace('Mia Hart,Doug Grant','([A-Z])([^A-Z]*)([A-Z])([^A-Z,]*)','\1.\3') as sx from dual;
select regexp_substr('ab,cd,ef','[^,]+',1,3) from dual;
select regexp_substr('ab,cd,ef,gh','[^,]+',1,level),level from dual connect by level<=(length(translate('ab,cd,ef,gh',','||'ab,cd,ef,gh',','))+1);
select deptno,sum(sal),listagg(ename,',') within group (order by ename) from emp group by deptno;
create or replace view v319 as select 'ef,xy,ij' as c1 from dual;
select c1,listagg(sss,',') within group (order by sss) from
(select regexp_substr(c1,'[^,]+',1,level) sss,level,c1 from v319 connect by level<=regexp_count(c1,',')+1) group by c1 ;
串
最新推荐文章于 2023-01-24 00:13:16 发布