1.In a table Gender is a column in that male and female are the two data.In a s

1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.
2.In a single query i need the count of male data,count of
female and total count

Question Posted / vijay

3 Answers
16351 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1.In a table Gender is a column in that male and female are the two data.In a single statement i ha..

Answer / sagar shinde

--Query for 1
update EMPLOYEE
set GENDER = decode(GENDER,'M','F','M')
/
--Query for 2
select GENDER,count(*)
from EMPLOYEE
group by GENDER

Is This Answer Correct ?

10 Yes

0 No

1.In a table Gender is a column in that male and female are the two data.In a single statement i ha..

Answer / anithaletchumi

1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.

ans->
update emp_table e set gender = (select case gender
when 'F' then 'M' else 'F' end from emp_table f where
e.empid = f.empid and e.gender=f.gender);
-- empid is the primary key.

2.In a single query i need the count of male data,count of
female and total count

ans 1->
select ( select count(empid) from emp_table where
gender='m' or gender='M') as count_male, ( select count
(empid) from emp11 where gender='f' or gender='F') AS
count_female,( select count(empid) from emp_table) as
tot_count from dual;

ans 2->
select sum(decode(gender,'F',1,'f',1)) as count_female,sum
(decode(gender,'M',1,'m',1)) as count_male,count(*) as
tot_count from emp_table;