Re: sql wrong? missing left parenthesis error?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 19 Nov 2002 11:02:30 +1000
Message-ID: <C_eC9.79360$g9.223685@newsfeeds.bigpond.com>

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:VvaC9.282$wt7.22136959_at_newssvr14.news.prodigy.com...

<snip>

> You'll find that your statement should be something like:
>
> CREATE TABLE kodUserSession (
> SessionID number not null
> constraint kodUserSession_PK
> primary key (SessionID),

Hi Karsten,

When you use column level constraints (such your example above), you don't re-specify the column name as it's implied and Oracle complains bitterly.

Cheers

Richard

> UserID number not null
> constraint kodUserSession_kodUser_FK
> foreign key (UserID)
> references kodUser (UserID)
> on delete cascade,
> LogonStamp date,
> LogoffStamp date,
> IPAddress varchar2(16),
> )
> tablespace KOD_DATA
> /
Received on Mon Nov 18 2002 - 19:02:30 CST