Query: vcn_route_table

select
  display_name as "Route Table Name",
  lifecycle_state as "Lifecycle State",
  r ->> 'cidrBlock' as "CIDR Block",
  r ->> 'destination' as "Destination",
  r ->> 'destinationType' as "Destination Type",
  r ->> 'networkEntityId' as "Network Entity ID"
from
  oci_core_route_table,
  jsonb_array_elements(route_rules) as r
where
  vcn_id = $1
order by
  display_name;