oracle8.1.6 select item_id, content_item.get_best_revision(item_id) as revision_id, content_revision.get_number(news_id) as revision_no, publish_title, html_p, to_char(to_date(publish_date, 'MM-DD-yyyy'), 'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi, to_char(to_date(archive_date, 'MM-DD-yyyy'), 'YYYY-MM-DD HH24:MI:SS') as archive_date_ansi, creation_user, item_creator, package_id, status from news_items_live_or_submitted where package_id = :package_id $view_option order by item_id desc