Oracle function (character location in string search (full-Angle Calculation of 1 character) INSTR (C1, C2 [, I [, J]) [function] searches for a specified character in a string and returns the specified character.
Oracle function (character location in string search (full-Angle Calculation of 1 character) INSTR (C1, C2 [, I [, J]) [function] searches for a specified character in a string and returns the specified character.
Oracle functions (search character positions in strings (full-width Calculation of 1 character ))
INSTR (C1, C2 [, I [, J])
[Function] searches for a specified character in a string and returns the location where the specified character is found;
[Note] multi-byte characters (Chinese characters, full-angle characters, etc.) are counted as 1 Character
[Parameter] the start position of the string I to be searched for by string C2 searched by C1. The default value is the position where the first J appears. The default value is 1.
Return Value
[Example] select instr ('oracle traning', 'A', 1, 2) instring from dual; Return: 9
[Example] select instr ('a software company in Chongqing ', 'mou',), Region B ('a software company in Chongqing', 'mou',) instring from dual;
Return Value: 3, 5
,