Oracle INSTRB() FunctionINSTRB is a String function of Oracle. This function returns the location of substring using bytes instead of characters 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
|