sql reg_substr

来源：互联网发布：seo能自学吗编辑：程序博客网时间：2024/04/30 05:18
</pre><pre name="code" class="sql">SQL> select ip, regexp_substr(ip,'[0-9]{1,3}',11)  from machine_info;IP                   REGEXP_SUBSTR(IP,'[0-9]{1,3}',-------------------- --------------------------------------------------------------------------------192.168.32.221       221192.168.32.235       235192.168.32.215       215192.168.32.232       232192.168.32.217       217192.168.32.233       233192.168.32.219       219192.168.32.63        63192.168.32.61        61192.168.32.62        62192.168.32.60        60192.168.32.68        68192.168.32.65        65192.168.32.67        67192.168.32.64        64192.168.32.173       173192.168.32.171       171192.168.32.174       174192.168.32.171       171192.168.32.170       170IP                   REGEXP_SUBSTR(IP,'[0-9]{1,3}',-------------------- --------------------------------------------------------------------------------192.168.32.169       169192.168.32.6         6192.168.32.5         5192.168.32.167       167192.168.32.168       168192.168.32.115       11526 rows selected
0 0