Re: ON UPDATE CASCADE

Hi Sybrand Bakker,
Thanks much!
acutually i need this feature as my design need to fit in MS-SQL,mysql,oracle. well, managed to work around. thanks for the info. **but couldn't open www.asktom.com .(Is this ste down these dayz?)

Regards,
Robbie.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ul0au74n89ev79_at_corp.supernews.com...
>
> "Raj" <ratnam_at_staff.singnet.com.sg> wrote in message
> news:aio490$abk$1_at_reader02.singnet.com.sg...
> > Im getting something like
> >
> > SQL> alter table sample add constraint cj_fk foreign key (name)
> references
> > customer (name) on delete cascade on update cascade;
> >
> >
> > references raaj(name) on delete cascade on update cascade
> > *
> > ERROR at line 2:
> > ORA-01735: invalid ALTER TABLE option
> >
> > please advice me about how to acheive, on update cascade along with on
> > delete cascade.
> >
> > Thanks!
> > Robbie
> >
> >
>
> 1 Check the syntax in your sql reference manual.
> 2 Note on update cascade doesn't exist
> You need to implement this by creating triggers.
> www.asktom.com should have a generic package to generate those triggers
> based on appropiate constraints.
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Wed Aug 07 2002 - 02:06:18 CDT