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 -> Test if Data for a Field is UNIQUE

Test if Data for a Field is UNIQUE

From: Michael42 <melliott42_at_yahoo.com>
Date: 23 Jan 2006 05:32:02 -0800
Message-ID: <1138023122.199034.154030@g47g2000cwa.googlegroups.com> 





Hello,



In Oracle 9i R2 on Solaris 8 I have a table (LOCATION) that has data.
I want to create a Foreign Key (FK) and base it on an existing field


(location_key) in this table.  I am not 100% sure the values are unique

(which is required to make it a FK for a child table).




Can someone please share SQL that can be used to determine if the
values in my LOCATION table field location_key field are UNIQUE?



Thanks,



Michael42
Received on Mon Jan 23 2006 - 07:32:02 CST












Original text of this message













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