It's http://asktom.oracle.com
"Raj" <ratnam_at_staff.singnet.com.sg> wrote in message
news:aiqga6$4eo$1_at_reader01.singnet.com.sg...
> 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 - 08:40:41 CDT
