Gender Swapping in SQL

Database: Oracle

Table name: demo

Query:
UPDATE DEMO
SET GENDER = CASE
  WHEN GENDER = 'male' THEN 'female'
  WHEN GENDER = 'female' THEN 'male'
  END;