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 are important reports in HRMS,GL,AP,AR in oracle apps?
3 Answers IBM, Pathway Technologies, Satyam, Techtimer, Wipro,
can we use lexical perameter in oracle plsql if yes how
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
as a technical developer in oracle applications which type errors feced in your experience sofar
how can we send a concurrent program output to the clients through mail or fax give me example.
the user should know to which database he is connected currently in oracle
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?