本文共 687 字，大约阅读时间需要 2 分钟。
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
转载地址：http://yaifo.baihongyu.com/