- Description: Finds the position of a substring in a string.
- Purpose: Useful for searching within strings.
- Syntax:
INSTR(string, substring, [start_position], [occurrence])
- Parameters:
string: The main string to search.substring: The substring to find.start_position: Where to start searching.occurrence: Which occurrence to find.
- Returns: An integer representing the position or
0 if not found.
- Example:
INSTR('Oracle Database', 'a') returns 3.
- Notes: Position is 1-based; case-sensitive.
- Use Case: Validating formats in structured data.
Leave a Reply