Query: vcn_subnet

select
  display_name as "Name",
  cidr_block as "IPv4 CIDR Block",
  ipv6_cidr_block as "IPv6 CIDR Block",
  id as "OCID",
  availability_domain as "Availability Domain",
  subnet_domain_name as "Subnet Domain Name",
  prohibit_public_ip_on_vnic as "Prohibit Public IP on VNIC"
from
  oci_core_subnet
where
  vcn_id = $1
order by
  display_name;