可通过regexp_count函数快速实现查询
函数用法:
regexp_count(参数1,参数2)
参数1:需要检索的字段名(列名)
参数2:需要检索的字符
比如如下数据,想查询txt字段中包含'_'的字符数
测试数据:
select 1 as 序号,'cs_123_145' as txt from dual
union all
select 2 as 序号,'cs_13' as txt from dual;
实现方法:
select a.序号,a.txt,regexp_count(a.txt,'_') as 个数 from (
select 1 as 序号,'cs_123_145' as txt from dual
union all
select 2 as 序号,'cs_13' as txt from dual
) a;
原创不易,如对您有帮助,请点赞关注,不定时更新干货~~~