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, 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 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(101, 'a,b,c,,e,,g');
1 rows affected

with rcte (id, data, lvl, result) as (
  select id, data, 1,
    cast(regexp_substr(data, '(.*?)(,|$)', 1, 1, null, 1) as varchar2(4000))
  from disp_data
  union all
  select id, data, lvl + 1,
    cast(regexp_substr(data, '(.*?)(,|$)', 1, lvl + 1, null, 1) as varchar2(4000))
  from rcte
  where lvl <= regexp_count(data, '("[^"]*"|[^,]+)')
)
select id, lvl, result
from rcte
order by id, lvl;


ID
LVL
RESULT


100
1
"Project title as per the outstanding Requirements"

100
2
"The values are

100
3
Also it is difficult to

100
4
 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"

100
5
"Active"

100
6
"Disabled"

100
7
"25 tonnes of fuel"

100
8
"www.examplesites.com/html.asp&net;"

100
9
""

100
10
""

100
11
""

100
12
""

101
1
a

101
2
b

101
3
c

101
4
null

101
5
e

101
6
null


with rcte (id, data, lvl, result) as (
  select id, data, 1,
    cast(regexp_substr(data, '("[^"]*"|[^,]+)', 1, 1, null, 1) as varchar2(4000))
  from disp_data
  union all
  select id, data, lvl + 1,
    cast(regexp_substr(data, '("[^"]*"|[^,]+)', 1, lvl + 1, null, 1) as varchar2(4000))
  from rcte
  where lvl <= regexp_count(data, '("[^"]*"|[^,]+)')
)
select id, lvl, result
from rcte
order by id, lvl;


ID
LVL
RESULT


100
1
"Project title as per the outstanding Requirements"

100
2
"The values are, 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 however it is up to the team"

100
3
"Active"

100
4
"Disabled"

100
5
"25 tonnes of fuel"

100
6
"www.examplesites.com/html.asp&net;"

100
7
""

100
8
""

100
9
""

100
10
""

100
11
"25"

100
12
null

101
1
a

101
2
b

101
3
c

101
4
e

101
5
g

101
6
null


with rcte (id, data, lvl, result) as (
  select id, data, 1, regexp_substr(data, '("[^"]*"|[^,]+)', 1, 1, null, 1)
  from disp_data
  union all
  select id, data, lvl + 1, regexp_substr(data, '("[^"]*"|[^,]+)', 1, lvl + 1, null, 1)
  from rcte
  where lvl <= regexp_count(data, '("[^"]*"|[^,]+)')
)
select *
from (
  select id, lvl, result
  from rcte
)
pivot (max(result) as col for (lvl) in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11));


ID
1_COL
2_COL
3_COL
4_COL
5_COL
6_COL
7_COL
8_COL
9_COL
10_COL
11_COL


100
"Project title as per the outstanding Requirements"
"The values are, 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 however it is up to the team"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
""
""
""
""
"25"

101
a
b
c
e
g
null
null
null
null
null
null


create table push_data_temp (pid number,col1 varchar2(100),col2 varchar2(300),col3 varchar2(100),col4 varchar2(100),col5 varchar2(100),col6 varchar2(100),col7 varchar2(100),col8 varchar2(100),col9 varchar2(100),col10 varchar2(100),col11 varchar2(100));
insert into push_data_temp (pid,col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11)
with rcte (id, data, lvl, result) as (
  select id, data, 1, regexp_substr(data, '("[^"]*"|[^,]+)', 1, 1, null, 1)
  from disp_data
  union all
  select id, data, lvl + 1, regexp_substr(data, '("[^"]*"|[^,]+)', 1, lvl + 1, null, 1)
  from rcte
  where lvl <= regexp_count(data, '("[^"]*"|[^,]+)')
)
select *
from (
  select id, lvl, result
  from rcte
)
pivot (max(result) as col for (lvl) in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11));
2 rows affected

select pid,col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11 from push_data_temp;


PID
COL1
COL2
COL3
COL4
COL5
COL6
COL7
COL8
COL9
COL10
COL11


100
"Project title as per the outstanding Requirements"
"The values are, 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 however it is up to the team"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
""
""
""
""
"25"

101
a
b
c
e
g
null
null
null
null
null
null

ID	LVL	RESULT
100	1	"Project title as per the outstanding Requirements"
100	2	"The values are
100	3	Also it is difficult to
100	4	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"
100	5	"Active"
100	6	"Disabled"
100	7	"25 tonnes of fuel"
100	8	"www.examplesites.com/html.asp&net;"
100	9	""
100	10	""
100	11	""
100	12	""
101	1	a
101	2	b
101	3	c
101	4	null
101	5	e
101	6	null

ID	LVL	RESULT
100	1	"Project title as per the outstanding Requirements"
100	2	"The values are, 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 however it is up to the team"
100	3	"Active"
100	4	"Disabled"
100	5	"25 tonnes of fuel"
100	6	"www.examplesites.com/html.asp&net;"
100	7	""
100	8	""
100	9	""
100	10	""
100	11	"25"
100	12	null
101	1	a
101	2	b
101	3	c
101	4	e
101	5	g
101	6	null