<div>
<div class="content wysiwyg-content">
hI, 
i have data like this 
 
jobcode &nbsp;factor_code &nbsp;decsr &nbsp; maxcode 
 
123 &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp;aa &nbsp; &nbsp; &nbsp; 101 
123 &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp;bb &nbsp; &nbsp; &nbsp; 102 
123 &nbsp; &nbsp; &nbsp; &nbsp;03 &nbsp; &nbsp; &nbsp; &nbsp;cc &nbsp; &nbsp; &nbsp; 401 
123 &nbsp; &nbsp; &nbsp; &nbsp;04 &nbsp; &nbsp; &nbsp; &nbsp;dd &nbsp; &nbsp; &nbsp; 501 
123 &nbsp; &nbsp; &nbsp; &nbsp;05 &nbsp; &nbsp; &nbsp; &nbsp;ee &nbsp; &nbsp; &nbsp; 601 
 
234 &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp;aa &nbsp; &nbsp; &nbsp; 302 
234 &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp;kk &nbsp; &nbsp; &nbsp; 402 
 
 
data should look like below: 
 
jobcode &nbsp;factor_code_01 &nbsp;decsr_01 &nbsp; maxcode_01 &nbsp; factor_code_02 &nbsp;decsr_02 &nbsp; maxcode_02 &nbsp;factor_code_03 &nbsp;decsr_03 &nbsp; maxcode_03 &nbsp; and so on 
 
123 &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aa &nbsp; &nbsp; &nbsp; &nbsp; 101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;bb &nbsp; &nbsp; &nbsp; &nbsp; 102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;cc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 401 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
234 &nbsp; &nbsp; &nbsp; &nbsp;01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;aa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;302 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;kk &nbsp; &nbsp; &nbsp; &nbsp; 402 
 
 
Max we have is factor_code =10 factor_code_10 &nbsp;decsr_10 &nbsp; maxcode_10
</div>
</div>

hI,
i have data like this

jobcode  factor_code  decsr   maxcode

123        01        aa       101
123        02        bb       102
123        03        cc       401
123        04        dd       501
123        05        ee       601

234        01        aa       302
234        02        kk       402


data should look like below:

jobcode  factor_code_01  decsr_01   maxcode_01   factor_code_02  decsr_02   maxcode_02  factor_code_03  decsr_03   maxcode_03   and so on

123        01              aa         101            02            bb         102           03            cc           401          

234        01              aa          302           02            kk         402


Max we have is factor_code =10 factor_code_10  decsr_10   maxcode_10

pivot 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.