Oracle Cloud · SQL

SQL inserts to load Oracle Cloud CIDRs into a database table. 1,089 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 ('38.104.155.92/31', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('40.233.0.0/19', '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 ('51.170.32.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('51.170.80.0/20', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('51.170.128.0/20', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('51.170.152.0/21', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('62.115.179.220/31', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('62.115.179.228/31', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.110.64.0/19', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.110.96.0/20', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.110.112.0/21', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.110.120.0/21', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.181.132.0/24', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.181.136.0/22', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.181.140.0/23', 'IPv4');
INSERT INTO `oracle_ips` (`ip_address`, `ip_type`) VALUES ('64.181.144.0/23', 'IPv4');
… (1072 more lines)