Re: Primary key with two columns
From: LS <Luise.Schuster_at_gp.materna.de>
Date: Thu, 11 Jul 2002 09:56:25 +0200
Message-ID: <agje04$d4b$1_at_penthesilea.materna.de>
Date: Thu, 11 Jul 2002 09:56:25 +0200
Message-ID: <agje04$d4b$1_at_penthesilea.materna.de>
Hello,
what about reading Oracle Documentation? SQL/Create Table Statement....
Try
CREATE TABLE whatever
( c1 varchar2(10) NOT NULL,
c2 number(4) NOT NULL,
c3 varchar2(10),
c4 date,
PRIMARY KEY (c1,c2)
);
Regards
Luise
"Christina" <christina.kronblad_at_telia.com> schrieb im Newsbeitrag
news:B5ZW8.47068$n4.11340282_at_newsc.telia.net...
> Hello!
>
> I hope someone can help me with this:
>
> I want to cerate a table 'whatever' with columns
> c1 varchar2(10)
> c2 number(4)
> c3 varchar2(10)
> c4 date
>
> and columns c1+c2 should be primaty key together.
>
> How do I write the create table statement?
>
> Thanks in advance!
>
> Christina
>
>
>
Received on Thu Jul 11 2002 - 09:56:25 CEST