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
17786 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;

Is This Answer Correct ?

9 Yes

3 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 / kd

2.
select gender, count(*)
from employee
group by gender
union
select 'total' as gender, count(*)
from employee

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More Oracle AllOther Interview Questions

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers Oracle,

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers Accenture,

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 Answers

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

0 Answers

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers IBM,

what is domain in database and its benefits?

0 Answers

How do you resize a data file?

2 Answers

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers CTS,

How do you switch from an init.ora file to a spfile?

1 Answers HCL, Wipro,

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers

For more Oracle AllOther Interview Questions Click Here