Question

The string function that returns the index of the first occurrence of substring is ______.

Options

• INSERT()

• INSTR()

• INSTRING()

• INFSTR()

Answer 1

The string function that returns the index of the first occurrence of substring is INSTR().

Explanation:

The string function 'INSTR()' is used to return the index of the first occurrence of the substring. The function 'INSERT()' is used to insert a substring up to the requested number of characters at the specified place.