Hello,
I need help for the below scenario:
I have a table
CREATE TABLE XX_EMAIL
(
CODE VARCHAR2(10),
EMAIL_ADDRESS VARCHAR2(100));
/
INSERT INTO XX_EMAIL
VALUES('C001','abc@test.com;xyz@test.com;yed@test.com');
INSERT INTO XX_EMAIL
VALUES('C002','abc@test.comxyz@test.com;yed@test.com');
/
commit;
/
I need to find out in the string of the field EMAIL_ADDRESS if the addresses are separated by ; or , not.