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
- 17656 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Where in the Oracle directory tree structure are audit traces placed?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
can we use lexical perameter in oracle plsql if yes how
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Could you please let me know the interfaces in OM / FA??
difference of using cursor for loop and open,fetch,close.which one is better
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
what are the API of GL,PO,AP
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Explain how to close periods in ar. : oracle accounts receivable
