Re: Create Table question

From: <satar_at_my-dejanews.com>
Date: Sat, 07 Nov 1998 00:50:24 GMT
Message-ID: <7205gh$2ve$1@nnrp1.dejanews.com>

Is "on update cascade" even an option?

Satar

In article <364367C4.26DCB9C2_at_home.com>, Teresa Mah <tmah_at_home.com> wrote:
> Hi,
>
> I'm having problems with the following create table statement:
>
> create table section
> ( dept char(4) not null,
> . . .
> foreign key (dept, course#) references course
> on delete cascade
> on update cascade )
>
> The system allows me to write one "on" clause, but not both. For
> example, I can do "on delete cascade" only, but not "on delete cascade
> on update cascade".
>
> Does anyone know the right syntax for specifying multiple actions?
>
> Thank you very much. Your help would be greatly appreciated.
>
> Teresa
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 18:50:24 CST