I want to get all characters after a specific character but at its last occurance

Question

Want to get all the characters after a specific character but at its last occurrence.

Current 'CSM.Sales.0000.Territory Manager' Desired Output : Territory Manager

SELECT
    SUBSTR('CSM.Sales.0000.Territory Manager', INSTR('CSM.Sales.0000.Territory Manager', '.') + 1) AS subject
FROM dual

Answer 1

You can try below -

DEMO

select substr('CSM.Sales.0000.Territory Manager', - 
    instr(reverse('CSM.Sales.0000.Territory Manager'), '.') + 1) from dual

OUTPUT:

Territory Manager