oracle8.1.6 update acs_objects set security_inherit_p = decode(security_inherit_p, 't', 'f', 'f', 't') where object_id = :object_id update acs_objects set security_inherit_p = case when security_inherit_p = 't' then 'f' else 't' end where object_id = :object_id