clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 710116 fiddles created (14338 in the last week).

select regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', 1, 1) as part1, CASE WHEN INSTR(text,' ',1,1)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,1), 1) ELSE '' END as part2, CASE WHEN INSTR(text,' ',1,2)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,2), 1) ELSE '' END as part3, CASE WHEN INSTR(text,' ',1,3)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,3), 1) ELSE '' END as part4, CASE WHEN INSTR(text,' ',1,4)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,4), 1) ELSE '' END as part5, CASE WHEN INSTR(text,' ',1,5)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,5), 1) ELSE '' END as part6, CASE WHEN INSTR(text,' ',1,6)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,6), 1) ELSE '' END as part7 FROM ( SELECT 'data1=value1 data2= data3=data3 tranamt=50 coupon=2bb2' as text FROM dual);
PART1 PART2 PART3 PART4 PART5 PART6 PART7
data1=value1 data2= data3=data3 tranamt=50 coupon=2bb2
 hidden batch(es)


WITH temp as ( select regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', 1, 1) as part1, CASE WHEN INSTR(text,' ',1,1)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,1), 1) ELSE '' END as part2, CASE WHEN INSTR(text,' ',1,2)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,2), 1) ELSE '' END as part3, CASE WHEN INSTR(text,' ',1,3)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,3), 1) ELSE '' END as part4, CASE WHEN INSTR(text,' ',1,4)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,4), 1) ELSE '' END as part5, CASE WHEN INSTR(text,' ',1,5)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,5), 1) ELSE '' END as part6, CASE WHEN INSTR(text,' ',1,6)>0 THEN regexp_substr(text, '[a-zA-z0-9]+=[a-zA-z0-9]*', INSTR(text,' ',1,6), 1) ELSE '' END as part7 FROM ( SELECT 'data1=value1 data2= data3=data3 tranamt=50 coupon=2bb2' as text FROM dual)) SELECT regexp_substr(part1,'[a-zA-Z0-9]*',1,1) as data,substr(part1,instr(part1,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part2,'[a-zA-Z0-9]*',1,1) as data,substr(part2,instr(part2,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part3,'[a-zA-Z0-9]*',1,1) as data,substr(part3,instr(part3,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part4,'[a-zA-Z0-9]*',1,1) as data,substr(part4,instr(part4,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part5,'[a-zA-Z0-9]*',1,1) as data,substr(part5,instr(part5,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part6,'[a-zA-Z0-9]*',1,1) as data,substr(part6,instr(part6,'=')+1) as value FROM temp UNION ALL SELECT regexp_substr(part7,'[a-zA-Z0-9]*',1,1) as data,substr(part7,instr(part7,'=')+1) as value FROM temp ;
DATA VALUE
data1 value1
data2
data3 data3
tranamt 50
coupon 2bb2
 hidden batch(es)