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
What is an Extent ?
How to unlock the sample user account in oracle?
What is Water Mark in Oracle?
How to revoke create session privilege from a user in oracle?
how to find count rows in table without count function?
ABOUT IDENTITY?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What is blob datatype?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Explain what are the type of synonyms?
Explain mutating triggers.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi