Char Functions Oracle PLSQL

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