Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. If the INSTR pattern is not found, then the entire string would be returned
SQL>  SELECT SUBSTR('H, J E', INSTR('H,J E','z'))  FROM dual;
SUBSTR
------
H, J E
SQL>