8.1.4.116

SELECT ID_CODE
,BUILD_TYPE
, TO_NUMBER(SUBSTR(VER,1,2),'XX')
||'.'||TO_NUMBER(SUBSTR(VER,3,2),'XX')
||'.'||TO_NUMBER(SUBSTR(VER,5,2),'XX')
||'.'||TO_NUMBER(SUBSTR(VER,7,2),'XX') AS INNER_VER
FROM (SELECT DECODE(SUBSTR(VER,1,2),'03','企业版','05','安全版','02','标准版','其他') AS BUILD_TYPE
,RAWTOHEX(CAST(SUBSTR(VER,3) AS INT)) AS VER
FROM (SELECT REGEXP_SUBSTR(ID_CODE,'[^-]+',1,1) AS VER)
);
可以通过这个语句查询。