Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT SUBSTR('4505U331.701', Instr('4505U331.701', '.', -1, 1) +1) FROM dual;

SUBSTR('4505U331.701',INSTR('4505U331.701','.',-1,1)+1)
701