Why INSTRB used in PL/SQL?

1.	Why INSTRB used in PL/SQL?
Answer» The INSTRB is a function used in PL/SQL to RETURN the location of a string within ANOTHER string. The value is RETURNED in bytes. An example: INSTR('Jack SPARROW', 'c') The above returns the OUTPUT in bytes: 3

Answer»

The INSTRB is a function used in PL/SQL to RETURN the location of a string within ANOTHER string. The value is RETURNED in bytes.

An example:

INSTR('Jack SPARROW', 'c')

The above returns the OUTPUT in bytes:

Discussion