Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. Combine INSTR and SUBSTR together
SQL>
SQL>
SQL> SELECT SUBSTR('aaa, bb ccc', INSTR('aaa, bb ccc',', ')) FROM dual;
SUBSTR('
--------
, bb ccc