The InStr () function in Oracle

One, InStr () function

1. Syntax: InStr (Sourcestring,deststring,start,appearposition)

Sourcestring represents the source string;

Deststring represents the substring to be looked up from the source string;

Start represents the starting position of the lookup, which is optional and defaults to 1;

The Appearposition representative wants to find out the first occurrence of the deststring from the source character, which is also optional and defaults to 1.

Returns the position before the specified condition

2. Use

①, finds the position of the specified substring from a string, starts at the 1th position, and the position of the first occurrence of C is 3, the result is as follows.

②, starting from the 4th position, the first occurrence of the C position is 6, the result is as follows.

③, starting from the 4th position, the second occurrence of the C position is 9, the result is as follows.

The InStr () function in Oracle