oracle 截取数据

SELECT /*+parallel(16)*/

REGEXP_SUBSTR(A,'\d+.\d+.\d+.\d+') AS A,
REGEXP_SUBSTR('[36.23.208.87]|[06:a9:80:9a:c7:f5]|[mobile]|[13306513045]|[hdd]','\d+.\d+.\d+.\d+') AS A
REGEXP_SUBSTR('[36.23.208.87]|[06:a9:80:9a:c7:f5]|[mobile]|[13306513045]|[hdd]','[0-9A-Za-z][0-9A-Za-z]-[0-9A-Za-z][0-9A-Za-z]-[0-9A-Za-z][0-9A-Za-z]-[0-9A-Za-z][0-9A-Za-z]-[0-9A-Za-z][0-9A-Za-z]-[0-9A-Za-z][0-9A-Za-z]') AS B,
REGEXP_SUBSTR('TDX-IP:183.226.202.210-MAC:0018F3BDE83D-HHD:[HHD]-MOBILE:[MOBILE]','[0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z][0-9A-Za-z]') AS V,
REGEXP_SUBSTR('WW_IP:111.10.34.37 NW_IP:192.168.1.101 MAC:F0-79-59-0E-7A-4E HDD:3725942555','[0-9A-Za-z][0-9A-Za-z]:[0-9A-Za-z][0-9A-Za-z]:[0-9A-Za-z][0-9A-Za-z]:[0-9A-Za-z][0-9A-Za-z]:[0-9A-Za-z][0-9A-Za-z]:[0-9A-Za-z][0-9A-Za-z]') AS B
FROM DUAL;