只有MySql中有:
select ipaddress from table1 where inet_aton(ipaddress) > inet_ntoa("192.168.1.1") and inet_aton(ipaddress) < inet_aton("192.168.1.192") and ipaddress like "192.168.1.%";
oracle中就只能自己写了。
只有MySql中有:
select ipaddress from table1 where inet_aton(ipaddress) > inet_ntoa("192.168.1.1") and inet_aton(ipaddress) < inet_aton("192.168.1.192") and ipaddress like "192.168.1.%";
oracle中就只能自己写了。