Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

SUBSTR and INSTR used together

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