Query: mysql_db_system_endpoint

select
  e ->> 'hostname' as "Hostname",
  e ->> 'ipAddress' as "IP Address",
  e ->> 'modes' as "Modes",
  e ->> 'port' as "Port",
  e ->> 'portX' as "PortX",
  e ->> 'status' as "Status"
from
  oci_mysql_db_system,
  jsonb_array_elements(endpoints) as e
where
  id = $1;