Connected to Oracle Database 10g Enterprise Edition Release  10 . 1 . 0 . 2 . 0  
Connected as test

SQL> create table dict as select rownum id, to_char (rownum) data from dual connect by level <=  10 ;

Table created

SQL> create table ref as select rownum id, rownum ref1, rownum+ 5  ref2 from dual connect by level <=  5 ;

Table created

SQL> alter table dict add primary key (id);

Table altered

SQL> alter table ref add constraint ref_fk1 foreign key (ref1) references dict (id) on delete cascade;

Table altered

SQL> alter table ref add constraint ref_fk2 foreign key (ref2) references dict (id) on delete cascade;

Table altered

SQL> select * from ref;

        ID       REF1       REF2
---------- ---------- ----------
          1            1            6 
          2            2            7 
          3            3            8 
          4            4            9 
          5            5           10 

SQL> delete from dict where id in ( 1 ,  8 );

 2  rows deleted

SQL> select * from ref;

        ID       REF1       REF2
---------- ---------- ----------
          2            2            7 
          4            4            9 
          5            5           10