<div>
<div class="content wysiwyg-content">
HI,<br />
<br />
I have a table that looks like this<br />
EMPLID &nbsp; &nbsp; COL_NAME &nbsp; &nbsp; COL_VAL<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ABC<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9999<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Stop!<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QQQ<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 87493<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; All Done<br />
<br />
I need to transpose this to look like<br />
EMPLID &nbsp; &nbsp; &nbsp; col1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; col2 &nbsp; &nbsp; &nbsp; &nbsp;col3<br />
123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ABC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9999 &nbsp; &nbsp; &nbsp; Stop!<br />
456 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QQQ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;87493 &nbsp; &nbsp; All Done<br />
<br />
In the most <b>efficient</b> way possible. All fields are of type varchar <br />
Thanx
</div>
</div>


HI,

I have a table that looks like this
EMPLID     COL_NAME     COL_VAL
123              col1                ABC
123              col2                9999
123              col3                Stop!
456              col1                 QQQ
456              col2                 87493
456              col3                 All Done

I need to transpose this to look like
EMPLID       col1           col2        col3
123             ABC           9999       Stop!
456             QQQ          87493     All Done

In the most efficient way possible. All fields are of type varchar 
Thanx

oracle: transpose rows to columns

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.