Oracle INSTR4() FunctionINSTR4 is a String function of Oracle. This function returns the location of the substring using UCS4 code points from the given string. SyntaxParametersString : string for searching. Substring : substring from the given string. start_position : it is optional. Starting position for searching. nth_appearance : it is optional. Nth position for a substring. ReturnThis function returns the numeric value. In the string first position is 1. Example 1Example 2
Next TopicOracle String
|