sql - Replace a column values from 'male' to 'female' and 'female' to 'male' -

i have 1 table gender in 2 entries there 'male' & 'female' number of rows 2 entries only. want write procedure replaces these 2 values , output should below,

i/p             o/p   sex             sex ------------------------ male           female female          male female          male male           female 

i creating procedure, gives me error, using cursor fetch more 1 rows..i know can using 1 update statement want try please this..

declare   v_gen gender%rowtype;   cursor cur_gender     select * gender; begin   open cur_gender;   loop     fetch cur_gender v_gen;     select * gender;     if v_gen='male'            update gender set sex='female';     else       update gender set sex='male';     end if;     exit when v_gen%notfound;     end loop;   close cur_gender; end;  

update table1 set "col" = (case "col" when 'male' 'female' else 'male' end); 

fiddle