Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. Substr retrieves a portion of the string
The general format for this function is:
SUBSTR(string, start_at_position, number_of_characters_to_retrieve)

SQL>
SQL> SELECT SUBSTR('Mississippi', 5, 3) FROM dual;
SUB
---
iss
SQL>