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: Untitled

Re: Untitled

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 15 Apr 1999 12:05:41 GMT
Message-ID: <01be8740$ae481990$2c289a0a@apollo>


Hi Adam

This is way I would do:

create table t(

field1 int,
field2 int,
field3 int,

primary key(field1, field2));

Adam D. Naylor <c9705690_at_wlv.ac.uk> skrev i artiklen <SIMEON.9904151214.A_at_dr.wlv.ac.uk>...
> Does anyone know how to create a table in sqlplus
> with a composite key for the following table:
>
> TableName(Field1, Field2, Field3)
> --------------
>
> Field1 and Field2 are the Primary key of the table
> and Field 3 is the field dependent on the first two.
>
>
>
>
Received on Thu Apr 15 1999 - 07:05:41 CDT

Original text of this message

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