src name sex a,male b,female c,male d,female Required output : male fe

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'));

Question Posted / kamleshmishra291

1 Answers
1796 Views
IBM, I also Faced
E-Mail Answers

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tr..

Answer / Deepak Pratap Singh

male femalena,bnc,d

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle General Interview Questions

How to convert characters to dates in oracle?

1 Answers

What are the differences between blob and clob in oracle?

1 Answers

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 Answers

What do you mean by cdb and pdb in oracle 12c?

1 Answers

What is connection pooling in oracle?

1 Answers

Explain an integrity constrains?

1 Answers

What is raw datatype in oracle?

1 Answers

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1 Answers Oracle,

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers Cognizant, IBM,

Explain the dml?

1 Answers

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

1 Answers iFlex,

Explain what are the characteristics of data files?

1 Answers

For more Oracle General Interview Questions Click Here