oracle8.1.6
select
0 as tree_level, '' as name , 'Home' as title
from
dual
UNION
select
t.tree_level, i.name, content_item.get_title(t.context_id) as title
from (
select
context_id, level as tree_level
from
acs_objects
where
context_id <> content_item.get_root_folder
connect by
prior context_id = object_id
start with
object_id = :item_id
) t, cr_items i
where
i.item_id = t.context_id
order by
tree_level
select
item_id, content_type
from
cr_items
where
item_id = content_item.get_id(:url, :content_root)
select
content_template.get_path(
content_item.get_template(:item_id, :context),:template_root) as template_url
from
dual
select
item_id, content_type
from
cr_items
where
item_id = content_item.get_id(:url, :content_root)
select
content_template.get_path(
content_item.get_template(:item_id, :context),:template_root) as template_url
from
dual