oracle8.1.6 select item_id, revision_id, content_revision.get_number(:revision_id) as revision_no, publish_title, publish_lead, publish_body, publish_format, 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