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: primary keys

Re: primary keys

From: Alan <alanshein_at_erols.com>
Date: Mon, 29 Oct 2001 15:24:11 -0500
Message-ID: <9rkdpa$ucngl$1@ID-114862.news.dfncis.de>


CREATE TABLE table_name(

    last_name varchar2(20),
    first_name varchar2(20)
    CONSTRAINT table_name_pk_idx
    PRIMARY KEY (last_name, first_name)
     etc

"Herman" <landsaat_at_intekom.co.za> wrote in message news:9rkcqf$fu$1_at_ctb-nnrp2.saix.net...
> HI there
>
> For most of you this is common knowledge but there is something I'd like
to
> know. I would like to make more than 1 column my primary key. If possible
> how is this done?
>
> T.y.
> Herman
>
>
Received on Mon Oct 29 2001 - 14:24:11 CST

Original text of this message

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