Query: compute_instance_vnic

select
  vnic_name as "VNIC Name",
  private_ip as "Private IP",
  public_ip as "Public IP",
  time_created as "Time Created",
  hostname_label as "Hostname Label",
  is_primary as "Primary",
  mac_address as "MAC Address"
from
  oci_core_vnic_attachment
where
  instance_id = $1 and public_ip is not null;