oracle8.1.6 select content_symlink.resolve(:template_id) from dual select content_item.get_path(:template_id, :root_id) from dual select content_item.get_title(item_id) title, item_id, use_context from cr_item_template_map where template_id = :template_id order by use_context select t.tree_level, t.context_id, content_item.get_title(t.context_id) as title from ( select context_id, level as tree_level from acs_objects where context_id <> 0 connect by prior context_id = object_id start with object_id = :template_id ) t, cr_items i where i.item_id = t.context_id order by tree_level desc