SQL Query to Replace a Column Values from male to female and female to male

 DROP TABLE t_Gender;

CREATE TABLE t_Gender

(

ENAME VARCHAR(25),

GENDER VARCHAR(6)

);

INSERT INTO t_Gender Values ('SCOTT','MALE');

INSERT INTO t_Gender Values ('KING','MALE');

INSERT INTO t_Gender Values ('Jennifer','FEMALE');

INSERT INTO t_Gender Values ('Shanta','FEMALE');

INSERT INTO t_Gender Values ('Julia','FEMALE');

Commit;

select * from t_Gender;

ENAME                     GENDER
------------------------- ------
SCOTT                     MALE  
KING                        MALE  
Jennifer                  FEMALE
Shanta                    FEMALE
Julia                        FEMALE

 

UPDATE T_GENDER 

SET GENDER =DECODE(GENDER,'MALE','FEMALE','FEMALE','MALE');

ENAME                     GENDER
------------------------- ------
SCOTT                     FEMALE  
KING                        FEMALE  
Jennifer                   MALE
Shanta                     MALE
Julia                         MALE

 ROLLBACK;

 

update t_Gender  

set gender = (case when gender = 'MALE' then 'FEMALE' else 'MALE' end);

ENAME                     GENDER
------------------------- ------
SCOTT                     FEMALE  
KING                        FEMALE  
Jennifer                  MALE
Shanta                    MALE
Julia                        MALE 

ROLLBACK;

 

UPDATE t_Gender

SET    gender = CASE gender

                  WHEN 'MALE' THEN 'FEMALE'

                  WHEN 'FEMALE' THEN 'MALE'

                  ELSE gender

                END;

ENAME                     GENDER
------------------------- ------
SCOTT                     FEMALE  
KING                        FEMALE  
Jennifer                   MALE
Shanta                     MALE
Julia                         MALE  

ROLLBACK;