By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REVERSE(SUBSTRING(REVERSE(col), INSTR(REVERSE(col), '.'))) |
|---|
| first. second. third. |
| REVERSE(SUBSTRING(REVERSE(col), INSTR(REVERSE(col), '.'))) |
|---|
| first. second. third. |