Oracle 11g Release 2

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

PART1	PART2	PART3	PART4	PART5	PART6	PART7
data1=value1	data2=	data3=data3	tranamt=50	coupon=2bb2	null	null

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	null
data3	data3
tranamt	50
coupon	2bb2
null	null
null	null