Skip to Main Content
Forums

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!

Does anyone have some wizzy code or bright ideas?

563457Sep 28 2007 — edited Oct 5 2007
I have a string variable - varchar2(240) maximum - which is arbitarily filled with 3 letter codes. Any one or more of these codes may be duplicated within the string. What I need to do is to strip out all the duplications and end up with a single contiguous string containing all the unique code options. e.g.

Initial string 'AAABBBCCCBBBDDDAAAEEEBBB'

should end up as :-

'AAABBBCCCDDDEEE'

Hope this makes sense - also there is no need to place the unique codes in any kind of order.

Thanks for your help...

Comments

thatJeffSmith-Oracle

I'd look at adjusting your editor font face/size

image.png

user_roshni

Font Name: Georgia did the trick for me.

1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 29 2007
Added on Sep 28 2007
13 comments
5,569 views