Oracle SQL Replace Male to Female and Female to Male

Step1: Create a table

create table gender_update(ename varchar2(10),gender varchar2(10));

Step 2: Insert a value into a table

insert into gender_update values('SMITH','male');

insert into gender_update values('ALLEN','female');

insert into gender_update values('WARD','male');

insert into gender_update values('JONES','female');

insert into gender_update values('MARTIN','male');

insert into gender_update values('BLAKE','female');

insert into gender_update values('CLARK','male');

insert into gender_update values('SCOTT','female');

Step 3:

Output

select * from gender_update;

Step 4: Update table Male to Female and Female to male

update gender_update set gender = case

when gender='male' then 'female'

when gender='female' then 'male'

else gender

end;

Step 5: select * from gender_update;