top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

I need to Extract particular String

+1 vote
231 views

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 :

result:

SEPA1,SEPA2,SEPA3

posted Jan 17, 2018 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

...