Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. If begin is negative, then retrieval occurs from the right-hand side of original string
SQL>  SELECT SUBSTR('My address is 123 Fourth St.',-9,5) FROM dual;
SUBST
-----
ourth
SQL>