update ims_cp_manifests set isshared = :share where man_id = :man_id select segment_id from rel_segments where rel_type = 'dotlrn_student_profile_rel' select case when isshared = 't' then 'Shared' else 'Not Shared' end as isshared from ims_cp_manifests where man_id = :man_id