oracle8.1.6
begin
cm_form_widget.register_attribute_widget(
content_type => :content_type,
attribute_name => :attribute_name,
widget => :widget,
is_required => :is_required
);
end;
update cm_attribute_widgets
set is_required = case when is_required = 't' then 'f' else 't' end
where attribute_id = :attribute_id
and widget = :widget