Oracle Cloud · SQL

SQL inserts to load Oracle Cloud CIDRs into a database table. 1,078 CIDRs, refreshed daily.
// oracle_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `oracle_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `oracle_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('40.233.0.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('139.177.96.0/21', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('157.137.160.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.181.146.0/23', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('134.70.200.0/23', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('139.177.104.0/22', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('139.177.108.0/25', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('140.91.90.0/23', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('140.204.132.128/25', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('157.137.253.0/24', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('40.233.64.0/18', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('129.153.48.0/20', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('132.145.96.0/20', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('140.238.128.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('147.5.96.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('147.15.184.0/21', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('150.230.24.0/21', 'IPv4');
… (1061 more lines)