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
begin
content_revision.to_temporary_clob(:revision_id);
end;
select
content
from
cr_content_text
where
revision_id = :revision_id
select
item_id, content_type
from
cr_items
where
item_id = content_item.get_id(:url, :content_root)
select
item_id, content_type
from
cr_items
where
item_id = content_item.get_id(:url, :template_root)
select
(select live_revision from cr_items where item_id = content_item.get_template(:item_id, :context)) as template_id,
content_template.get_path(
content_item.get_template(:item_id, :context),:template_root) as template_url
from
dual