We can use pivot finction on 11g instead of multiple decodes.

write a sql query following source?
subject mark
maths 30
science 20
social 80

requird output
maths science social
30 20 80

Question Posted / keshava

Answer Posted / keshava

We can use pivot finction on 11g instead of multiple
decodes.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the popular informatica products?

1008

What is meant by LDAP users?

1202

What are the performance considerations when working with aggregator transformation?

1149

Repository user profiles

1758

Explain joiner transformation in informatica

1124

What can we do to improve the performance of informatica aggregator transformation?

1091

4 yrs etl devloper roles and responsibilities?any body give solutions

2163

Explain the different lookup methods used in informatica?

1037

What are roles and groups and benefits of using them?

1055

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2719

Can we override a native sql query within informatica?

1034

What are batches?

1093

What is blocking transformation?

1140

How to convert multiple rows to single row (multiple columns) in informatica

1376

how many types of dimensions are available in informatica?

1091