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 -> Re: Do no duplicates table exists ?

Re: Do no duplicates table exists ?

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Thu, 9 Sep 1999 09:21:36 -0400
Message-ID: <7r8cqr$17r$1@winter.news.rcn.net>


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

Original text of this message

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