oracle8.1.6 select item_id, revision_id, content_revision.get_number(:revision_id) as revision_no, publish_title, html_p, publish_date, archive_date, creation_ip, creation_date, '' || item_creator || '' as creator_link from news_item_revisions where item_id = :item_id and revision_id = :revision_id select content from cr_revisions where revision_id = :revision_id