oracle8.1.6 , content.blob_to_string(content) as text select 't' from cr_revisions r, cr_items i where r.revision_id = :revision_id and i.item_id = r.item_id and ((r.content is not null and i.storage_type in ('lob','text')) or (r.filename is not null and i.storage_type = 'file'))