oracle8.1.6
select content_item.get_best_revision(:item_id) from dual
select content_item.get_path(:item_id) from dual
select content_item.get_template(:item_id, :context) as template_id
from dual
select content_item.is_publishable(:item_id) from dual
select content_item.get_title(:item_id) from dual
select content_item.get_id(:url
, :root_folder
) from dual
, content.blob_to_string(content) as text