I'm trying to get the String after the delimiter(,) ,if we don't have a delimiter it should return null
Can you guys please help me with this.
This is what I'm doing right now:
select REGEXP_SUBSTR('First String, Second String','[^,]*$') from dual
Expected Output : Second String (This is working)
select REGEXP_SUBSTR('First String Second String','[^,]*$') from dual
Expected Output : NULL OR NO VALUE (This is not working)