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