Re: Oracle 9i ON UPDATE CASCADE

SQL Server is not completely without its merits.

 But I can write a trigger that will give me on update cascade in Oracle. There is no means in SQL Server to write multiversioning or provide unlimited locks.

Daniel Morgan

Alex Ivascu wrote:

> Oracle doesn't let you do that. Don't get Oracle confused with SQL
> Server.... [ I guess there is a benefit for using SQL ] :o)
>
> Alex Ivascu
> DBA
>
> "Claude Gagnon" <claudegagnon_at_videotron.ca> wrote in message
> news:VD9r8.7964$c_.289847_at_wagner.videotron.net...
> > Hi,
> >
> > I want to know if Oracle 9i supports the command ON UPDATE CASCADE.
> >
> > I have the following constraints and I get an error:
> >
> > CONSTRAINTS fk_PosteSecond_PostePrim FOREIGN KEY (noP) REFERENCES
> PostePrim
> > (noP) ON UPDATE CASCADE)
> >
> > *
> > ERROR at line 5:
> > ORA-00905: missing keyword
> >
> >
> >
> > If I utilize ON DELETE CASCADE, I didn't get any error.
> >
> >
> > Thanks,
> >
> > Claude
> >
> >
Received on Sun Apr 07 2002 - 09:19:54 CDT