By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT regexp_substr('STRING_EXA2MP_3LE', '(.*)_[0-9]+', 1, 1, NULL, 1)
FROM dual
| REGEXP_SUBSTR('STRING_EXA2MP_3LE','(.*)_[0-9]+',1,1,NULL,1) |
|---|
| STRING_EXA2MP |