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
- 1749 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of a cluster?
How to get a list of all user accounts in the database?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
What are the logical operations?
What is the difference between truncate & delete command?
How to join two tables in a single query using oracle?
How to experiment a data lock in oracle?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How to use like conditions in oracle?
Can we create more than one constraint to column ?
What different of iner joint & outer joint with example
what are the database links ?
Oracle General 
