Hi, my friends.
Tell amp-TA how with SQL (preferably) or PL/SQL implementations of the occurrence of specific IP addresses in a particular range?
Simply put, it is necessary to determine to which subnet belongs to a specific IP address:
There is a table ip_networks format
RANGE_BEGIN RANGE_END RANGE_NAME
10.160.1.0 10.160.1.125 MSK
10.160.1.126 10.160.1.254 SPB
... and many more...
and you want to display in the select query field value RANGE_NAME for each IP address from the long list.
My head is spinning something very long with the use of BETWEEN, FOR, and CASE, but I suspect that this problem is somehow more elementary must be addressed...
It is you hope...