Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

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>