JDunkerley
Reputation: 12495
Finding last index of a string in Oracle
I need to find the last index of a string (e.g. -) within another string (e.g. JD-EQ-0001 in Oracle's SQL (version 8i). Is there a way to do this with INSTR() or another function?
Upvotes: 83
Views: 158835
Answers (1)
Related Questions
- How to obtain last string after right-most space
- How to get the substring before the last occurrence of a character?
- oracle 12c - select string after last occurrence of a character
- How to get the last letter of a string?
- select string after second to the last occurrence of a character
- Exact last character match in string
- Oracle Substring a column for last index of character
- Find substring till last occurrence
- Instr - Last index of last character
- Substring from last index