Query: compartment_table

select
  c.name as "Name",
  c.lifecycle_state as "Lifecycle State",
  c.time_created as "Time Created",
  t.name as "Tenancy Name"
from
  oci_identity_compartment as c
  left join oci_identity_tenancy as t on t.id = c.tenant_id;