oracle8.1.6
select
item_id,
package_id,
revision_id,
publish_title,
publish_lead,
html_p,
publish_date,
NVL(archive_date, sysdate+[ad_parameter ActiveDays "news" 14]) as archive_date,
status
from
news_item_full_active
where
item_id = :item_id
select content
from cr_revisions
where revision_id = :revision_id