SELECT * FROM dual WHERE REGEXP_LIKE('5e:0:0:0:0:0:5668:eeee','^((?:[\da-fA-F]{0,4}:[\da-fA-F]{0,4}){2,7})(?:/\%)?$');Oracle匹配ipv6正则时,无法匹配问题
^(?:[\da-fA-F]{0,4})?(::?[\da-fA-F]{0,4}){1,7}(?:/\%)?$