top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

I need to Extract particular String

+1 vote
34 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

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...