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
- 1746 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
When system tablespace is created?
Is there an oracle sql query that aggregates multiple rows into one row?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What language does oracle use?
What are the set operators union, union all, minus & intersect meant to do?
What is proxy method?
Explain an index segment?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What is Water Mark in Oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
What is max rowid in oracle?
How do I uninstall oracle 11g?
Oracle General 
