Write a query to display character after comma's

select regexp_substr('VV,XXX,YYYY,ZZZZZ','[^,]+',1,1) COL from dual;

CO

--

VV

 

select regexp_substr('VV,XXX,YYYY,ZZZZZ','[^,]+',1,2) COL from dual;

COL

---

XXX

 

select regexp_substr('VV,XXX,YYYY,ZZZZZ','[^,]+',1,3) COL from dual;

COL

----

YYYY

 

select regexp_substr('VV,XXX,YYYY,ZZZZZ','[^,]+',1,4) COL from dual;

COL

-----

ZZZZZ