update ims_cp_manifest_class set isenabled = :enable where man_id = :man_id and lorsm_instance_id = :package_id select case when isenabled = 't' then 'Enabled' else 'Disabled' end as isenabled from ims_cp_manifest_class where man_id = :man_id and lorsm_instance_id = :package_id