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
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 |
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Give the two types of tables involved in producing a star schema and the type of data they hold.
what is sql*loader parameters and where we will use it.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
please explain about oracle
How to find locks exists in a table or not?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
What are the main diff. between oracle 7.3 and oracle 8i?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What view would you use to determine free space in a tablespace?
What do you mean by hz_ in customer tables? : oracle accounts receivable