DEVFYI - Developer Resource - FYI

Difference between SUBSTR and INSTR?

PL/SQL Interview Questions and Answers


(Continued from previous question...)

Difference between SUBSTR and INSTR?

INSTR (String1, String2 (n, (m)),
INSTR returns the position of the m-th occurrence of the string 2 in string1. The search begins from nth position of string1.
SUBSTR (String1 n, m)
SUBSTR returns a character string of size m in string1, starting from n-th position of string1.

(Continued on next question...)

Other Interview Questions