SELECT REGEXP_SUBSTR('hello my phone is 520 ', '[0-9]+') FROM dual;
+号是指匹配多个
SELECT REGEXP_SUBSTR ('i like beijing tiananmen ', '(\S*)(\s)', 1, 2) FROM dual;
*也是匹配多个字符,(1,2)从第一个开始截取第二个。
SELECT REGEXP_SUBSTR('hello my phone is 520 ', '[0-9]+') FROM dual;
+号是指匹配多个
SELECT REGEXP_SUBSTR ('i like beijing tiananmen ', '(\S*)(\s)', 1, 2) FROM dual;
*也是匹配多个字符,(1,2)从第一个开始截取第二个。