Primary key with two columns

From: Christina <christina.kronblad_at_telia.com>
Date: Wed, 10 Jul 2002 16:16:33 GMT
Message-ID: <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 Wed Jul 10 2002 - 18:16:33 CEST

Original text of this message