SELECT REGEXP_REPLACE ('SEPA1,30-NOV-17,60,60;SEPA2,30-NOV-17,60,60;SEPA3,30-NOV-17,60,60;', '[,^^,^,^;]', '') FROM dual;
Please help. without using LEVEL.
I need output like :
SEPA1,SEPA2,SEPA3
In my table I have three unique column this can be referred by other table. Which key I have to use for this.