Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table disp_data(id number, data varchar2(4000));


Insert into disp_data(id,data) values(100,
'["Project title as per the outstanding Requirements","The values are,\n not with respect to the requirement and analysis done by the team. 
Also it is difficult to, prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex\n however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","","","","","25"]');
1 rows affected

Insert into disp_data(id,data) values(110,
'["Project title afor BYU heads","The values are\n, exactly up to the requirement and analysis done by the team. 
Also it is difficult to, 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","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
1 rows affected

SELECT * FROM disp_data


ID
DATA


100
["Project title as per the outstanding Requirements","The values are,\n not with respect to the requirement and analysis done by the team. 
Also it is difficult to, prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex\n however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","","","","","25"]

110
["Project title afor BYU heads","The values are\n, exactly up to the requirement and analysis done by the team. 
Also it is difficult to, 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","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]


create table PUSH_DATA_TEMP
(
id_pk NUMBER,
  id    NUMBER,
  col1  VARCHAR2(4000),
  col2  VARCHAR2(4000),
  col3  VARCHAR2(4000),
  col4  VARCHAR2(4000),
  col5  VARCHAR2(4000),
  col6  VARCHAR2(4000),
  col7  VARCHAR2(4000),
  col8  VARCHAR2(4000),
  col9  VARCHAR2(4000),
  col10 VARCHAR2(4000),
  col11 VARCHAR2(4000),
  col12 VARCHAR2(4000),
   col13 VARCHAR2(4000),
    col14 VARCHAR2(4000)
);
CREATE OR REPLACE PROCEDURE PUSH_DATA(p_id NUMBER,data_string varchar2) IS
  CURSOR cur_data IS
    WITH input
      AS
    (select data_string from dual),
    rcte (id, data, lvl, result)
    AS (
         SELECT p_id, data, 1,regexp_substr(data,
                '(".*?")(,|\])', 1, 1, 'n', 1) result
           FROM (select data_string data from input) 
        UNION ALL
         SELECT id, data, lvl + 1,
                regexp_substr(data, '(".*?")(,|\])', 1, lvl + 1, 'n', 1)
           FROM rcte
        WHERE lvl <= regexp_count(data, '(".*?")(,|\])',1,'n')
       )
    SELECT *
    FROM (SELECT id, lvl, replace(result,'""','') as result
            FROM rcte)
    PIVOT (MAX(result)
     FOR (lvl) IN(1 AS col1
                  ,2 AS col2
                  ,3 AS col3
                  ,4 AS col4
                  ,5 AS col5
                  ,6 AS col6
                  ,7 AS col7
                  ,8 AS col8
                  ,9 AS col9
                  ,10 AS col10
                  ,11 AS col11
                  ,12 AS col12
                     ,13 AS col13
                        ,14 AS col14));
   var cur_data%ROWTYPE;
BEGIN
  OPEN cur_data;
  LOOP
    FETCH cur_data INTO var;
    EXIT WHEN cur_data%NOTFOUND;
    UPDATE push_data_temp
    SET col1 = var.col1
      , col2 = var.col2
      , col3 = var.col3
      , col4 = var.col4
      , col5 = var.col5
      , col6 = var.col6
      , col7 = var.col7
      , col8 = var.col8
      , col9 = var.col9
      , col10 = var.col10
      , col11 = var.col11
      , col12 = var.col12
      , col13 = var.col13
      , col14 = var.col14
    WHERE ID = var.id;
    IF SQL%ROWCOUNT = 0
    THEN
       INSERT INTO push_data_temp(id, col1, col2, col3, col4, col5,
                                  col6, col7, col8, col9, col10, col11, col12,col13,col14)
          VALUES (var.id, var.col1, replace(var.col2,'\n',chr(10)),replace(var.col3,'\n',chr(10)),var.col4,var.col5,
                  var.col6,var.col7,var.col8,var.col9,var.col10,var.col11,var.col12,var.col13,var.col14);
    END IF;
  END LOOP;
END;
/
BEGIN
PUSH_DATA(110,'[""Project title afor BYU heads"","The values are,\n "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,\n 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","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
END;
/
1 rows affected

BEGIN
PUSH_DATA(111,'[""Project title for IT Heads"","The values are,\n "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,\n 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","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
END;
/
1 rows affected

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
"The values are,
 "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,
 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"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
"Apprehension"
null
null
null
"25"
"Stable"
null
null

null
111
Project title for IT Heads
"The values are,
 "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,
 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"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
"Apprehension"
null
null
null
"25"
"Stable"
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
"The values are,
 "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,
 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"

1
110
1
COL03
"Active"

1
110
1
col4
"Disabled"

1
110
1
col5
"25 tonnes of fuel"

1
110
1
COL06
"www.examplesites.com/html.asp&net;"

1
110
1
COL07
"Apprehension"

1
110
1
COL08
null

1
110
1
COL09
null

1
110
1
COL10
null

1
110
1
COL11
"25"

1
110
1
COL12
"Stable"

1
110
1
COL13
null

1
110
1
COL14
null

1
111
1
COL01
Project title for IT Heads

1
111
1
COL02
"The values are,
 "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,
 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"

1
111
1
COL03
"Active"

1
111
1
col4
"Disabled"

1
111
1
col5
"25 tonnes of fuel"

1
111
1
COL06
"www.examplesites.com/html.asp&net;"

1
111
1
COL07
"Apprehension"

1
111
1
COL08
null

1
111
1
COL09
null

1
111
1
COL10
null

1
111
1
COL11
"25"

1
111
1
COL12
"Stable"

1
111
1
COL13
null

1
111
1
COL14
null

ID	DATA
100	["Project title as per the outstanding Requirements","The values are,\n not with respect to the requirement and analysis done by the team. Also it is difficult to, prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex\n however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","","","","","25"]
110	["Project title afor BYU heads","The values are\n, exactly up to the requirement and analysis done by the team. Also it is difficult to, 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","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]

ID_PK	ID	COL1	COL2	COL3	COL4	COL5	COL6	COL7	COL8	COL9	COL10	COL11	COL12	COL13	COL14
null	110	Project title afor BYU heads	"The values are, "exactly" up to the requirement and analysis done by the team. Also it is difficult to, 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"	"Active"	"Disabled"	"25 tonnes of fuel"	"www.examplesites.com/html.asp&net;"	"Apprehension"	null	null	null	"25"	"Stable"	null	null
null	111	Project title for IT Heads	"The values are, "exactly" up to the requirement and analysis done by the team. Also it is difficult to, 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"	"Active"	"Disabled"	"25 tonnes of fuel"	"www.examplesites.com/html.asp&net;"	"Apprehension"	null	null	null	"25"	"Stable"	null	null

ID_PK	ID	LABEL_ID	LABEL	VALUE
1	110	1	COL01	Project title afor BYU heads
1	110	1	COL02	"The values are, "exactly" up to the requirement and analysis done by the team. Also it is difficult to, 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"
1	110	1	COL03	"Active"
1	110	1	col4	"Disabled"
1	110	1	col5	"25 tonnes of fuel"
1	110	1	COL06	"www.examplesites.com/html.asp&net;"
1	110	1	COL07	"Apprehension"
1	110	1	COL08	null
1	110	1	COL09	null
1	110	1	COL10	null
1	110	1	COL11	"25"
1	110	1	COL12	"Stable"
1	110	1	COL13	null
1	110	1	COL14	null
1	111	1	COL01	Project title for IT Heads
1	111	1	COL02	"The values are, "exactly" up to the requirement and analysis done by the team. Also it is difficult to, 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"
1	111	1	COL03	"Active"
1	111	1	col4	"Disabled"
1	111	1	col5	"25 tonnes of fuel"
1	111	1	COL06	"www.examplesites.com/html.asp&net;"
1	111	1	COL07	"Apprehension"
1	111	1	COL08	null
1	111	1	COL09	null
1	111	1	COL10	null
1	111	1	COL11	"25"
1	111	1	COL12	"Stable"
1	111	1	COL13	null
1	111	1	COL14	null