SELECT 1 FROM DUAL WHERE REGEXP_LIKE('14.232.230.251','^(([1-9]?[0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([1-9]?[0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$')
CHECK (REGEXP_LIKE(IPV4,'^(([1-9]?[0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([1-9]?[0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$'))
SELECT 1 FROM DUAL WHERE REGEXP_LIKE('20200229','^((2000|2400|2800|(19|2[0-9](0[48]|[2468][048]|[13579][26])))0229)$|^(((19|2[0-9])[0-9]{2})02(0[1-9]|1[0-9]|2[0-8]))$|^(((19|2[0-9])[0-9]{2})(0[13578]|10|12)(0[1-9]|[12][0-9]|3[01]))$|^(((19|2[0-9])[0-9]{2})(0[469]|11)(0[1-9]|[12][0-9]|30))$')
CHECK (REGEXP_LIKE('20200229','^((2000|2400|2800|(19|2[0-9](0[48]|[2468][048]|[13579][26])))0229)$|^(((19|2[0-9])[0-9]{2})02(0[1-9]|1[0-9]|2[0-8]))$|^(((19|2[0-9])[0-9]{2})(0[13578]|10|12)(0[1-9]|[12][0-9]|3[01]))$|^(((19|2[0-9])[0-9]{2})(0[469]|11)(0[1-9]|[12][0-9]|30))$'))
More than 3 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme