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