Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. Retrieval begins at position 5 and again goes for 12 characters
SQL>  SELECT SUBSTR('My address is 1234 Fourth St.',5,12) FROM dual;
SUBSTR('MYAD
------------
ddress is 12
SQL>