Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Combine INSTR and SUBSTR together

SQL> SQL> SQL> SELECT SUBSTR('aaa, bb ccc', INSTR('aaa, bb ccc',', ')) FROM dual; SUBSTR(' -------- , bb ccc