oracle8.1.6
select
content_item.get_content_type( :item_id )
from
dual
select
item_id, name, locale, live_revision, publish_status,
content_item.is_publishable(item_id) as is_publishable
from
cr_items
where
item_id = :item_id
select
revision_id,
trim(title) as title,
trim(description) as description,
publish_date,
content_revision.get_number(revision_id) as revision_number
from
cr_revisions r
where
r.item_id = :item_id
order by
revision_number desc