sql - oracle 12c - select string after last occurrence of a character

Question

I have below string:

ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence

So I want to select Sentence since it is the string after the last period. How can I do this?

Answer 1

Just for completeness' sake, here's a solution using regular expressions (not very complicated IMHO :-) ):

select regexp_substr(
  'ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence',
  '[^.]+$') 
from dual

The regex

• uses a negated character class to match anything except for a dot [^.]
• adds a quantifier + to match one or more of these
• uses an anchor $ to restrict matches to the end of the string