Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create Table question

Re: Create Table question

From: Rob Medley <medleyrk_at_iafrica.com>
Date: Sun, 08 Nov 1998 22:43:20 +0200
Message-ID: <36460268.D52C9FE2@iafrica.com>


Hi,There is no syntax for 'on update cascade'. This option does not exist.
You would have to write your own code to make this happen, I am told ( I have not checked it
personally) that there is an example of the code at http://govt.us.oracle.com.

Good luck,

Rob Medley

> 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
Received on Sun Nov 08 1998 - 14:43:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US