SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regular expression

849776Nov 12 2013 — edited Nov 20 2013

In a column ,we have values from A to Z and it repeats multiple time and i just want to get distinct values.Please see the below sample data.
Thanks in advance

WITH T1
     AS (SELECT 'AAAABBBCCAAADDCSS' VAL FROM DUAL
         UNION ALL
         SELECT 'SDDDABBBNCMMDDCSS' VAL FROM DUAL
         UNION ALL
         SELECT 'RTSDABBBCCAAADDCSS' VAL FROM DUAL)
SELECT *
FROM T1

EXPECTED OUTPUT:

ABCDS
SDABNCM
RTSDABC

This post has been answered by 849776 on Nov 20 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2013

Added on Nov 12 2013

30 comments

1,749 views