oracle8.1.6 select title from cr_revisions, cr_items where cr_items.item_id = :file_id and revision_id=live_revision