Re: Primary Key on two columns in one table
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 11 Jul 2002 05:29:03 -0700
Message-ID: <a20d28ee.0207110429.44ce641c_at_posting.google.com>
constraint whatever_prim primary key (c1,c2) )
Date: 11 Jul 2002 05:29:03 -0700
Message-ID: <a20d28ee.0207110429.44ce641c_at_posting.google.com>
"Christina" <christina.kronblad_at_telia.com> wrote in message news:<s2ZW8.47067$n4.11340237_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
create table whatever
(c1 varchar2(10)
,c2 number(4) ,c3 varchar2(10) ,c4 date
constraint whatever_prim primary key (c1,c2) )
Homework !
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jul 11 2002 - 14:29:03 CEST