-- Oracle --
SELECT v
     , SUBSTR(REGEXP_SUBSTR(v, '\([^)]+'), 2) x1
     , REGEXP_REPLACE(v, '^[^(]+|\(|\)') x2
     , REPLACE(SUBSTR(v, INSTR(v, '(')+1), ')') x3
     , REGEXP_SUBSTR(v, '[0-9.]+') x4
  FROM (SELECT 'EXAMPLE- HH ALARM (0.00)' v FROM dual)
;

-- MySQL --
SELECT v
     , REPLACE(SUBSTR(v, INSTR(v, '(') +1), ')', '') x1
     , REPLACE(SUBSTRING_INDEX(v, '(', -1), ')', '') x2
  FROM (SELECT 'EXAMPLE- HH ALARM (0.00)' v) a
;