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
- 16378 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is autocashrule set? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
Explain about party and customer in ar : oracle accounts receivable
how to write customizations in po
What is the difference between recovery and restoring of the oracle database?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
can u give guidance abt packages of plsql
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
what is difference between inner join & nested query or subqueries
What do you mean by Oracle MEDIA RECOVERY?
What view would you use to determine free space in a tablespace?
What is Tax Categories?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
