Forum .LRN Q&A: Re: Community name from a package_id

Collapse
Posted by Dirk Gomez on
This here looks ok:

select instance_name from
apm_packages apm
where apm.package_key = 'dotlrn'
and apm.package_id = 310111
and apm.package_id in (select  object_id
  from site_nodes
  connect by prior node_id = parent_id start with object_id =apm.package_id);