sql reg_substr

</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       221
192.168.32.235       235
192.168.32.215       215
192.168.32.232       232
192.168.32.217       217
192.168.32.233       233
192.168.32.219       219
192.168.32.63        63
192.168.32.61        61
192.168.32.62        62
192.168.32.60        60
192.168.32.68        68
192.168.32.65        65
192.168.32.67        67
192.168.32.64        64
192.168.32.173       173
192.168.32.171       171
192.168.32.174       174
192.168.32.171       171
192.168.32.170       170
IP                   REGEXP_SUBSTR(IP,'[0-9]{1,3}',
-------------------- --------------------------------------------------------------------------------
192.168.32.169       169
192.168.32.6         6
192.168.32.5         5
192.168.32.167       167
192.168.32.168       168
192.168.32.115       115
26 rows selected