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
How to invoke the data pump export utility?
what are the advantages of running a database in archive log mode?
query to find the maximum no persons with same age(age colomn) from emp table
How to delete a column in an existing table in oracle?
What is a static data dictionary in oracle?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
List the various oracle database objects?
Hi Can any one tell me what are the API's used in requisition import.
Explain the function of optimizer in oracle?
what is the difference between UNION AND UNIONALL
How do I spool in oracle?
How to synchronize 2 schema's objects?