INSTR4

INSTR4 is a character string function in SQL that helps in determining the position of the fourth character occurrence of a specific substring within a specific source string. It returns an integer specifying the starting position of the specified occurrence of the substring. If the substring does not appear in the source string or a specific occurrence is not found, it returns zero.

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.