Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. SUBSTR and INSTR used together
SQL>  SELECT SUBSTR('H, J E', INSTR('H, J E',', ')+2)  FROM dual;
SUB
---
J E
SQL>