By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT regexp_substr(
'A-XY',
'A-([A-Z]+)$',
1,
1,
NULL,
1
) AS last_characters
FROM DUAL;
LAST_CHARACTERS |
---|
XY |