Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Using SUBSTR and INSTR together

SQL>  SELECT SUBSTR('H, J E', INSTR('H, J E',', ')+2)  FROM dual; SUB --- J E SQL>