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