计算单个字符在字符串中出现的次数:
select length('HELLO WORLD!')-length(replace('HELLO WORLD!','L','')) from dual;
--计算单个字符在字符串中出现的次数:
select length('10-11-30-22:dbsaleinst1_138-FRA')-length(replace('10-11-30-22:dbsaleinst1_138-FRA','-','')) from dual;
--截取最后一个'-'后面的字符串
select substr('10-11-30-22:dbsaleinst1_138-FRA',instr('10-11-30-22:dbsaleinst1_138-FRA','-',1,(length('10-11-30-22:dbsaleinst1_138-FRA')-length(replace('10-11-30-22:dbsaleinst1_138-FRA','-',''))))+1,50) instring from dual;