INSTR4

Oracle

Example

SELECT
  INSTR4('HELLO', 'H') AS position
FROM
  dual;

Output

POSITION
1

Explanation

In the provided example, INSTR4 function is used to find the position of the character ‘H’ in the string ‘HELLO’. The function returns 1 as ‘H’ is the first character in the string.