Sql - There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with

[radhika_btech]

Sql - There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?

[sk_kireeti]

Not sure if this query works or not.... assuming name of the table is emp.

update emp set GENDER = decode(GENDER,'M','F','F','M');
or
update emp set GENDER = decode(GENDER,'M','F','M');

Thanks,
Krishna

[Laxminarayanak]

The other alternative is
update emp set GENDER = 'KK' WHERE GENDER ='M'
update emp set GENDER = 'M' WHERE GENDER='F'
update emp set GENDER = 'F' WHERE GENDER ='KK'

[manjunath.hota]

update emp_vas1 x
set x.gender = (
select nvl(replace(decode (gender, 'M', '*'),'*', 'F'
),'M') /*,emp_id, emp_name*/
from emp_vas1 x2
where x.emp_id = x2.emp_id
)

Pls correct me if any mistakes

[samsi_143]

UPDATE EMP
SET GENDER=case gender when 'M' then 'F' when 'F' then 'M' END;

[samsi_143]

This was a check constraint , so it wont accept anything except M & F.