SyntaxFix
Write A Post
Hire A Developer
Questions
Tags
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?
-
JD-EQ-0001
INSTR()
This question is related to oracle string
oracle
string
Use -1 as the start position:
INSTR('JD-EQ-0001', '-', -1)
Source: Stackoverflow.com