Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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