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!

Conerting multiple rows into sinlge row

user651567Jun 22 2012 — edited Jun 22 2012

Hi All,

Suppose the table is like given below,

EmpId Technology
1 Java
1 Oracle
1 .Net
1 MySQL

Here the above table (Technology) says the list of technologies working by Employee 1.

Now I want a query, which can give result like below,

EmpId Tech_java Tech_oracle Tech_.net Tech_mysql
1 java Oracle .Net MySQL

The data base is oracle 10g

Please let me know if any issue.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2012

Added on Jun 22 2012

#query, #sql

7 comments

206 views