Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Do no duplicates table exists ?
Hi,
Create your table with a primary key. (Example from docs)
CREATE TABLE emp (empno NUMBER PRIMARY KEY, . . .
You can also create a unique index, e.g.
CREATE INDEX emp_idx ON emp(empno);
regards
Jerry Gitomer
krillo_at_my-deja.com wrote in message
<7r7o8k$trt$1_at_nnrp1.deja.com>...
>Hello, I would like to know if oracle 8+ allows
>to create a table wich has automatically no
>duplicates. I mean, wich will ignore any
>insertion of a duplicate row. This sort of thing
>exists in sql server, with some NO_DUP_KEY
>constraint/index. But does it in Oracle 8+ ?
>
>Thanks
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 09 1999 - 08:21:36 CDT