Re: Create Table question

Teresa Mah ¼¶¼g©ó¤å³¹ <364367C4.26DCB9C2_at_home.com>...
>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 does not support "on update cascade". If you want to perform it, you must write some triggers instead of using "references" constraint. Received on Sat Nov 07 1998 - 04:12:09 CST