oracle查询正规表达示
程序员文章站
2022-01-15 11:56:46
...
<!--StartFragment -->
select regexp_substr(content,'^【[^【】]+】|【[^【】]+】$',1,1) 签名,status,count(*)
from table
where CREATE_TIME>=trunc(sysdate)
and status='0'
group by regexp_substr(content,'^【[^【】]+】|【[^【】]+】$',1,1),status
order by 3 desc
from table
where CREATE_TIME>=trunc(sysdate)
and status='0'
group by regexp_substr(content,'^【[^【】]+】|【[^【】]+】$',1,1),status
order by 3 desc