Query: vcn_cidr_blocks

select
  b as "CIDR Block",
  power(2, 32 - masklen(b :: cidr)) as "Total IPs"
from
  oci_core_vcn,
  jsonb_array_elements_text(cidr_blocks) as b
where
  id = $1
union all
select
  b as cidr_block,
  power(2, 128 - masklen(b :: cidr)) as num_ips
from
  oci_core_vcn,
  jsonb_array_elements_text(ipv6_cidr_blocks) as b
where
  id = $1;