Split SQL Columns by Regex Substr

Question

I need to split this SQL Columns using Regex and extracted the last part (LN1_DEF_DEPT). Can someone help me?

LDS^1^LN1_DEF_DEPT

Thanks in Advance!

Answer 1

If I correct understood, you need this

select REGEXP_SUBSTR('LDS^1^LN1_DEF_DEPT',  '[^\^]+$') from dual