INSTRC
Example
Section titled “Example”SELECT INSTRC('òáôíõæå', 'ô') FROM dual;Output
Section titled “Output”3Explanation
Section titled “Explanation”The INSTRC function in Oracle returns the position of the first occurrence of a substring in a string. Here it is used to locate the position of the character ‘ô’ in the string ‘òáôíõæå’. Since ‘ô’ is the third character in the string, the output is 3.