WITH t AS ( SELECT 1 no, 'AA00 = AAB9 and DJ00 = DJ01' usage FROM dual UNION ALL SELECT 2, '(16-18 = A07 and HK00 = HK03 AND PZ00 = PZ06 AND MG00 = MG42)' FROM dual UNION ALL SELECT 3, '(TEST_BASE_MODEL = TS1ED1985151 OR TEST_BASE_MODEL = TS1EE0485151)' FROM dual ) SELECT no , usage , REGEXP_REPLACE(usage, '[^ =(]+ = ') x FROM t ;