mardi 4 août 2015

regular expression in oracle to get a range of ip address from 100.64.*.* to 100.127.*.*?

i need a regular expression in oracle to get a range of IP address from 100.64.*.* to 100.127.*.* ?

for example if i have

1) 100.63.22.55 
2) 100.64.102.558 
3) 100.123.22.12 
4) 100.127.22.55 
5) 100.128.221.55

regular expression should pick the below ip address

2) 100.64.102.558 
3) 100.123.22.12 
4) 100.127.22.55 

Aucun commentaire:

Enregistrer un commentaire