oracle8.1.6
select content_symlink.resolve( :id ) from dual
select content_folder.get_index_page($parent_var) from dual
select
i.item_id id,
content_item.get_path(i.item_id) path
from
cr_items i, cr_symlinks s
where
i.item_id = s.target_id
and
i.item_id = :original_id
select
parent_id, NVL(label, name) label, description
from
cr_items i, cr_folders f
where
i.item_id = f.folder_id
and
f.folder_id = :id