Oracle实现获得字符串中指定字符个数的方法

select  (length(csrq)-length(replace(csrq,'-',''))) from dual;

 

SELECT T.*,TO_NUMBER(SUBSTR(R.POINTSTR,INSTR(R.POINTSTR,',',-1,1)+1,LENGTH(R.POINTSTR)))/1000 AS RESULT
  FROM RES_SERVERINFO T, RES_SERVICESCOPE R
 WHERE IS_NUMBER(T.MAXRESID) = 1
   AND T.MAXRESID = R.SERVICESCOPE_ID
   AND LENGTH(R.POINTSTR) > 23
   AND LENGTH(R.POINTSTR) < 28
   AND COUNTCHARINSTRING(R.POINTSTR,',')=2
UNION
SELECT T.*,TO_NUMBER(SUBSTR(R.POINTSTR,INSTR(R.POINTSTR,',',-1,1)+1,LENGTH(R.POINTSTR)))/1000 AS RESULT
  FROM RES_SERVERINFO T, RES_SERVICESCOPE R
 WHERE IS_NUMBER(T.FREERESID) = 1
   AND T.FREERESID = R.SERVICESCOPE_ID
   AND LENGTH(R.POINTSTR) > 23
   AND LENGTH(R.POINTSTR) < 28
   AND COUNTCHARINSTRING(R.POINTSTR,',')=2