SQLize Online / PHPize Online  /  SQLtest Online

with tbl as ( select 'TPURCHASE_CURR=980;TPURCHASE_AMOUNT=8020;SCASHBACK_CURR=980;SCASHBACK_AMOUNT=60000;' as t from dual union all select 'TPURCHASE_CURR=980;TPURCHASE_AMOUNT=6630;SCASHBACK_CURR=980;' as t from dual union all select 'TCASHBACK_AMOUNT=60000;ALLOW_PURCH_ONLY_AUTH=Y;TCASHBACK_CURR=980;TPURCHASE_CURR=980;TPURCHASE_AMOUNT=8;SCASHBACK_CURR=980;SCASHBACK_AMOUNT=60000;' as t from dual union all select 'TCASHBACK_AMOUNT=60000;ALLOW_PURCH_ONLY_AUTH=Y;TCASHBACK_CURR=980;TPURCHASE_CURR=980;SCASHBACK_CURR=980;SCASHBACK_AMOUNT=60000;TPURCHASE_AMOUNT=91' as t from dual union all select 'TPURCHASE_AMOUNT=9992' as t from dual ) select substr(REGEXP_SUBSTR(t, '(TPURCHASE_AMOUNT\=)[0-9]+*'), 18) as res2 from tbl