What function does Oracle use to contain a certain character?

Functions that contain specific characters in Oracle

In Oracle database, you can use the INSTR() function to check whether a string contains specific characters.

Syntax:

<code>INSTR(string, substring)</code>

Where:

• string: The string to be searched
• substring: The character or string to be found

Example:

Find whether the string "Hello World" contains letters "o":

<code>SELECT INSTR('Hello World', 'o') FROM dual;</code>

Result:

<code>4</code>

This means that the character "o" is at position 4 in the string "Hello World".

Return result:

• If substring is found in string, then substring# is returned The first occurrence of ## in string.
Returns 0 if
• substring is not found in string.

Note:

String comparison is case-sensitive.
• If
• substring is the empty string, the INSTR() function returns 1.

The above is the detailed content of What function does Oracle use to contain a certain character?. For more information, please follow other related articles on the PHP Chinese website!