update ims_cp_manifest_class set istrackable = :enable where man_id = :man_id and lorsm_instance_id = :package_id select case when istrackable = 't' then 'Yes' else 'No' end as istrackable from ims_cp_manifest_class where man_id = :man_id and lorsm_instance_id = :package_id