Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17643 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 auto invoicing? Explain : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
How would you determine what sessions are connected and what resources they are waiting for?
which one is currently in used software cmpanies.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
1. What is PO rate variance gain and loss?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
what is difference between inner join & nested query or subqueries
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
