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

Collapse
4: Re: Community name from a package_id (response to 1)
Posted by Dirk Gomez on 10/27/03 07:24 PM
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);