Re: Composite Primary Key...?

From: Christoph Purrucker <gugi_at_bigfoot.de>
Date: Thu, 12 Jun 2003 14:08:30 +0200
Message-ID: <bc9qg2$mlb$1@home.itg.ti.com>

Hello Dave,

> My text book talks about the "viability" of using a
> composite primary key......

No problem.

> If I try to create a "composite" primary key in
> Oracle I get the message that:
> "table can only have one primary key".

You did not composite one primary key, but trying to create multiple primary keys.

> Or am I simply getting the syntax wrong.

Perhaps. You did not post any code :-)

> Any advice help would be appreciated D.Moore
> (45 year old rookie student)

Regards,

cp (still 21) Received on Thu Jun 12 2003 - 07:08:30 CDT