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'));
No Answer is Posted For this Question
Be the First to Post Answer
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How do I manually create a database in oracle?
Can we connect to ORACLE db using Windows Authentication?
When system tablespace is created?
What is materialized view in Oracle?
1.display list of all users from ur data base.what is the query?
How to get a list of all background sessions in the database?
What is recovery manager(rman) backup in Oracle?
which language is used to develop the oracle........?
without using count(*) and rownum how can we count total record in a table
Give the various exception types.
how to select second mauximum value in a given table under salary column