INSTR2

Oracle

Example

SELECT INSTR2('Hello World','o') AS Location
FROM dual;

Output

LOCATION
----------
   5

Explanation

INSTR2 function in Oracle returns the position of the 2nd occurrence of a substring. In the provided example, we look for the position of the ‘o’ letter in the string “Hello World”. As we can see in the output, the position is 5.