If the INSTR pattern is not found, then the entire string would be returned
SQL> SQL> -- If the INSTR pattern is not found, then the entire string would be returned SQL> SQL> SELECT SUBSTR('aaa bbb c', INSTR('aaa bbb c','zonk')) FROM dual; SUBSTR('A --------- aaa bbb c