Search for last occurance of a substring
724687Jan 7 2010 — edited Jan 7 2010How do I search for the last occurance of a substring in a string? More in detail: I have table with filenames, and I want to split of the extention of the filename into a seperate column. The extention doesn't have a fixed with (can be "c", "jpg" or "mpeg", etc...), and the filenames themselves can contain dots (so this is possible: "recording.of.last.meeting.mpeg".
So the only way to extract the extention is to search for the last occurance of a dot, and split off everything after the last dot. How can I do this? I worked with a sybase database before and there was a string function to start searching from the right of the string. Is there something similar in Oracle?