Query: vcn_dhcp_options

select
  display_name as "Name",
  lifecycle_state as "Lifecycle State",
  op ->> 'type' as "Option Type",
  op -> 'searchDomainNames' as "Search Domain Names",
  op -> 'customDnsServers' as "Custom DNS Servers",
  op ->> 'serverType' as "Server Type"
from
  oci_core_dhcp_options,
  jsonb_array_elements(options) as op
where
  vcn_id = $1
order by
  display_name;