weixin_40126548的博客

原创 oracle计算字段中某字符出现个数

select a.序号,a.txt,regexp_count(a.txt,'_') as 个数 from (select 1 as 序号,'cs_123_145' as txt from dual。select 1 as 序号,'cs_123_145' as txt from dual。select 2 as 序号,'cs_13' as txt from dual;select 2 as 序号,'cs_13' as txt from dual。比如如下数据，想查询txt字段中包含'_'的字符数。