Oracle Procedure alter pivoted data to unpivot and push into different destination
Why do you not simply unpivot the hole table


SELECT * FROM push_data_temp;


ID_PK |  ID | COL1                         | COL2                                                                                                                                                                                                                                                           | COL3     | COL4       | COL5                | COL6                                 | COL7           | COL8 | COL9 | COL10 | COL11 | COL12    | COL13 | COL14
----: | --: | :--------------------------- | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------- | :--------- | :------------------ | :----------------------------------- | :------------- | :--- | :--- | :---- | :---- | :------- | :---- | :----
 null | 110 | Project title afor BYU heads | &quot;The values are,&lt;br&gt; &quot;exactly&quot; up to the requirement and analysis done by the team.&lt;br&gt;Also it is difficult to,&lt;br&gt; prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team&quot; | &quot;Active&quot; | &quot;Disabled&quot; | &quot;25 tonnes of fuel&quot; | &quot;www.examplesites.com/html.asp&amp;net;&quot; | &quot;Apprehension&quot; | null | null | null  | &quot;25&quot;  | &quot;Stable&quot; | null  | null 
 null | 111 | Project title for IT Heads   | &quot;The values are,&lt;br&gt; &quot;exactly&quot; up to the requirement and analysis done by the team.&lt;br&gt;Also it is difficult to,&lt;br&gt; prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team&quot; | &quot;Active&quot; | &quot;Disabled&quot; | &quot;25 tonnes of fuel&quot; | &quot;www.examplesites.com/html.asp&amp;net;&quot; | &quot;Apprehension&quot; | null | null | null  | &quot;25&quot;  | &quot;Stable&quot; | null  | null 




create table PUSH_DATA_PIVOT
(
id_pk NUMBER,
  id NUMBER,
  label_id number,
  label varchar2(4000),
  value varchar2(4000)
);




INSERT INTO PUSH_DATA_PIVOT
SELECT 1,ID,1,label,value
FROM
(SELECT * FROM push_data_temp
UNPIVOT INCLUDE NULLS(
    value
    FOR label 
    IN (
        col1 AS 'COL01', 
        col2 AS 'COL02', 
        col3 AS 'COL03', 
        col4 AS 'col4', 
        col5 AS 'col5', 
        col6 AS 'COL06', 
        col7 AS 'COL07', 
        col8 AS 'COL08', 
        col9 AS 'COL09', 
        col10 AS 'COL10', 
        col11 AS 'COL11', 
        col12 AS 'COL12', 
        col13 AS 'COL13', 
        col14 AS 'COL14'
    )
)) t1;


28 rows affected




select * from push_data_pivot;


ID_PK |  ID | LABEL_ID | LABEL | VALUE                                                                                                                                                                                                                                                         
----: | --: | -------: | :---- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    1 | 110 |        1 | COL01 | Project title afor BYU heads                                                                                                                                                                                                                                  
    1 | 110 |        1 | COL02 | &quot;The values are,&lt;br&gt; &quot;exactly&quot; up to the requirement and analysis done by the team.&lt;br&gt;Also it is difficult to,&lt;br&gt; prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team&quot;
    1 | 110 |        1 | COL03 | &quot;Active&quot;                                                                                                                                                                                                                                                      
    1 | 110 |        1 | col4  | &quot;Disabled&quot;                                                                                                                                                                                                                                                    
    1 | 110 |        1 | col5  | &quot;25 tonnes of fuel&quot;                                                                                                                                                                                                                                           
    1 | 110 |        1 | COL06 | &quot;www.examplesites.com/html.asp&amp;net;&quot;                                                                                                                                                                                                                          
    1 | 110 |        1 | COL07 | &quot;Apprehension&quot;                                                                                                                                                                                                                                                
    1 | 110 |        1 | COL08 | null                                                                                                                                                                                                                                                          
    1 | 110 |        1 | COL09 | null                                                                                                                                                                                                                                                          
    1 | 110 |        1 | COL10 | null                                                                                                                                                                                                                                                          
    1 | 110 |        1 | COL11 | &quot;25&quot;                                                                                                                                                                                                                                                          
    1 | 110 |        1 | COL12 | &quot;Stable&quot;                                                                                                                                                                                                                                                      
    1 | 110 |        1 | COL13 | null                                                                                                                                                                                                                                                          
    1 | 110 |        1 | COL14 | null                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL01 | Project title for IT Heads                                                                                                                                                                                                                                    
    1 | 111 |        1 | COL02 | &quot;The values are,&lt;br&gt; &quot;exactly&quot; up to the requirement and analysis done by the team.&lt;br&gt;Also it is difficult to,&lt;br&gt; prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team&quot;
    1 | 111 |        1 | COL03 | &quot;Active&quot;                                                                                                                                                                                                                                                      
    1 | 111 |        1 | col4  | &quot;Disabled&quot;                                                                                                                                                                                                                                                    
    1 | 111 |        1 | col5  | &quot;25 tonnes of fuel&quot;                                                                                                                                                                                                                                           
    1 | 111 |        1 | COL06 | &quot;www.examplesites.com/html.asp&amp;net;&quot;                                                                                                                                                                                                                          
    1 | 111 |        1 | COL07 | &quot;Apprehension&quot;                                                                                                                                                                                                                                                
    1 | 111 |        1 | COL08 | null                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL09 | null                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL10 | null                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL11 | &quot;25&quot;                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL12 | &quot;Stable&quot;                                                                                                                                                                                                                                                      
    1 | 111 |        1 | COL13 | null                                                                                                                                                                                                                                                          
    1 | 111 |        1 | COL14 | null                                                                                                                                                                                                                                                          


db&lt;&gt;fiddle here