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

Home -> Community -> Usenet -> c.d.o.misc -> create three column unique constraint on existing table

create three column unique constraint on existing table

From: Doron <doron_almog_at_msn.com>
Date: 18 Aug 2003 12:52:16 -0700
Message-ID: <995517bc.0308181152.209df81e@posting.google.com> 





Hi,


I want to create a unique validated constraint on three columns of a
very large existing table. the create is failing due to the validation
process.



anybody got any SQL code that will help me determine in which rows the
data appears more then once?



thanks,


Doron
Received on Mon Aug 18 2003 - 14:52:16 CDT












Original text of this message













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