Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How a row data is converted into a column data

703280Jan 18 2010 — edited Jan 19 2010
How the data in any row of a table is converted into a column data. (the query to do that)
e.g.

id name city
a11 Ram Kolhapur
b22 Manu Satara

the result should be

a11 b22
ram Manu
kolhapur Satara

Is it possible , if yes how ? boz this has been asked in an interview?

Thanks
Prithviraj

Comments

Shailesh Donda

Hello Experts,
Can you please provide me a solution for this issue ?

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 16 2010
Added on Jan 18 2010
6 comments
996 views