Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Remove duplicates from a field possible?

Re: Remove duplicates from a field possible?

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Mon, 06 Mar 2006 15:06:46 GMT
Message-ID: <aeYOf.4971$eP4.1751@trnddc05>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US