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
- 16888 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
A scenario for amount correction & how to use amount correction functionality in AP invoices
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How do you create a credit note against an invoice? : oracle accounts receivable
What command would you use to create a backup control file?
What is store procedure?and how do u take the values from database and run in scripts?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is the sql query to find the employee who has Nth maximum salary?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
what is debit memo and credit memo in AR?
Oracle General 
