SELECT to_char(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 RAWTOHEX(CAST(SUBSTR(VER,3) AS INT)) AS VER FROM (SELECT REGEXP_SUBSTR(ID_CODE,'[^-]+',1,1) AS VER))
8.1.4.48