SQL>SQL> -- SUBSTR: from the right-hand side of original string:SQL>SQL> SELECT SUBSTR('My address is 123 Fourth St.',-9,5) FROM dual;SUBST-----ourthSQL>