By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_SUBSTR(MESSAGE,'[[:ALPHA:]_]+$') |
|---|
| EMP_NB |
| EM_NM |
| DEPT_NO_VL |
| REGEXP_REPLACE(MESSAGE,'^.*[^[:ALPHA:]_]([[:ALPHA:]_]+)[^[:ALPHA:]_]*$','\1') |
|---|
| EMP_NB |
| EM_NM |
| DEPT_NO_VL |