Query: vcn_subnet_tag

with jsondata as (
  select
    tags::json as tags
  from
    oci_core_subnet
  where
    id = $1 and lifecycle_state <> 'TERMINATED'
)
select
  key as "Key",
  value as "Value"
from
  jsondata,
  json_each_text(tags)
order by
  key;