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 |
Can we modify approve purchase order?if yes what is navigation?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
How would you determine what sessions are connected and what resources they are waiting for?
How do you resize a data file?
Difference between transaction type and transaction sources. : oracle accounts receivable
How client makes connection with server in client/server architecture?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
Explain the difference between a hot backup and a cold backup and the benefits associated with each
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What type of index should you use on a fact table?