oracle8.1.6 select [ad_decode $storage_type file "'[cr_fs_path]' || filename" content] as content from cr_revisions where revision_id = $revision_id select item_id, mime_type, content_revision.is_live( revision_id ) is_live from cr_revisions where revision_id = :revision_id