on update cascade
758466Mar 12 2010 — edited Mar 12 2010help wanted on update cascade. How can i do it in oracle?
SQL> create table t(
2 id number(1),
3 name varchar2(10),
4 constraint i_pk primary key (id)
5 );
Table created.
SQL> create table m (
2 id number(1),
3 class varchar2(4),
4 constraint i_fk foreign key (id)
5 references t (id) on update cascade
6 );
references t (id) on update cascade
*
ERROR at line 5:
ORA-00905: missing keyword