The corresponding function InStr contrast in CHARINDEX and Oracle in SQL _oracle

Sql:charindex (' String ', field) >0 charindex (' Administrator ', Muserid) >0

Oracle:instr (field, ' String ', 1,1) >0 InStr (Muserid, ' Administrator ', 1,1) >0

In the project to use the Oracle INSTR this function, by the way carefully learn this knowledge again.

Oracle, you can use the INSTR function to judge a string to determine whether it contains the specified character.

Its syntax is:
INSTR (string, substring, position, occurrence)
which

String: Represents the source string;

SUBSTRING: Represents the substring to look for in the source string;

Position: Represents the start position of the lookup, which is optional and defaults to 1;

Occurrence: The representative wants to find out the first occurrence of the substring from the source character, this parameter is optional, default is 1;
If the value of the position is a negative number, the representation is looked up from right to left.
The return value is: The position of the string found.

For the INSTR function, we often use this: to find the position of a specified substring from a string.

For example:

The display result of the SELECT Instr (' Hello Word ', ' O ',-1, 1) ' String ' from Dual is

Instring
————
8