oracle 8.1.6 update dotlrn_member_emails set enabled_p = case when enabled_p = 't' then 'f' else 't' end where community_id = :community_id and type = 'on join'