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
- 1697 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What are the advantages of Views ?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to create a table index?
what is the scenario where you take the database to NoArchivelog mode?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Without giving condition how to retrieve the unmatched records from table.
What are the database administrators utilities available?
What is oracle update statement with inner join ?
3. Display all the client numbers in the ORDER table. Remove duplicates.
How to store only time; not date and time?
How to use subqueries in the from clause in oracle?
Oracle General 
