Interested to Buy Any Domain ? << Click Here >> for more details...
src
name sex
a,male
b,female
c,male
d,female
Required output :
male female
a,b
c,d
tried pivot but was not successfull
select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
- 0 Answers
- 1673 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a synonym? What are its various types?
Differentiate between translate and replace?
difference between oracle8i and oracle9i
How can Oracle users be audited?
What is merge statement used for?
What is an index associated with a constraint?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
Does oracle charge for java?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
What is the difference between I and G in Oracle?
Explain the difference between sap and oracle?
Oracle General 
