Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 17549 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is db_recovery_file_dest in oracle? When do you need to set this value?
How would you determine who has added a row to a table?
Can we modify approve purchase order?if yes what is navigation?
Are These Dff's Flexible?
What is the mandatory setup in cyclecount ?
Why more redos are generated when the oracle database is in begin backup mode?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is Tax Categories?
What is the use of lockboxes? : oracle accounts receivable
how to replace not in with not exist?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
