select regexp_substr((select sl.photo_id
from product_service_line sl
where sl.product_id =
'8a84e5c13ee4f021013ee502f8140010'),
'[^,]+',
1,
rownum)
from dual
connect by rownum <= length(regexp_replace((select sl.photo_id
from product_service_line sl
where sl.product_id =
'8a84e5c13ee4f021013ee502f8140010'),
'[^,]',
null)) ;
from product_service_line sl
where sl.product_id =
'8a84e5c13ee4f021013ee502f8140010'),
'[^,]+',
1,
rownum)
from dual
connect by rownum <= length(regexp_replace((select sl.photo_id
from product_service_line sl
where sl.product_id =
'8a84e5c13ee4f021013ee502f8140010'),
'[^,]',
null)) ;