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

select regexp_substr(data,'[^,]+',1,level) from disp_data 
connect by regexp_substr(data,'[^,]+',1,level) is not null;


REGEXP_SUBSTR(DATA,'[^,]+',1,LEVEL)


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


Insert into disp_data(id,data) values(101, 'a,b,c,,e,,g');
1 rows affected

select regexp_substr(data,'[^,]+',1,level) from (select * from disp_data where id = 101)
connect by regexp_substr(data,'[^,]+',1,level) is not null


REGEXP_SUBSTR(DATA,'[^,]+',1,LEVEL)


a

b

c

e

g


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 id, lvl, result
from rcte
order by id, lvl;


ID
LVL
RESULT


100
1
"Project title as per the outstanding Requirements"

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

101
1
a

101
2
b

101
3
c

101
4
null

101
5
e

101
6
null

101
7
g


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"
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
null
e
null
g
null
null
null
null

ID	LVL	RESULT
100	1	"Project title as per the outstanding Requirements"
100	2	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"
101	1	a
101	2	b
101	3	c
101	4	null
101	5	e
101	6	null
101	7	g