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
- 1181 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Does oracle database need java?
what is difference between table and view? where to use views? thanks in advance!
What privilege is needed for a user to connect to oracle server?
How to shutdown your 10g xe server?
how to find out largest value in a table
how to get the second max val for every group in a table
What is the difference between Sleep and Wait? (Java)
how can db_files > maxdatafiles since db_files is for instance and the later is for database
what is analyze command ? what kind of statistics does it generate?
How many file formats are supported to export data?
Give the Types of modules in a form?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
Oracle General 
