Oracle’s PL/SQL questions

Difference between SUBSTR and INTSTR?

Posted by silpa on Sep 17 2007

INSTR (String1,String2(n,(m)), returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.

SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.