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'));
- 1 Answers
- 1797 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / Deepak Pratap Singh
male femalena,bnc,d
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to write a left outer join with the where clause in oracle?
How to select all columns of all rows from a table in oracle?
Design database draw er diagram for a certain scenario ?
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
What is oracle latest version?
