Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remove duplicates from a field possible?
Mark Milke wrote:
> Hi all,
>
> we store in a var field values in the format 123; 345; 567; In some
> records the field contains duplicates, i.e. 123; 345; 123; 567; Is it
> possible to selelct those records somehow, or even better get rid of
> the duplicates?
>
> Mark
>
Sounds like you have a multivalued (denormalized) column. Any chance you can normalize the data?
-- To reply by email remove "_nospam"Received on Mon Mar 06 2006 - 09:06:46 CST
![]() |
![]() |