No Need for trigger Re: oracle trigger question# Database - 数据库
B*n
1 楼
In this case, you dont even need a trigger. It is
automatically
handled by database referential constraints. Basically you
need
to specify the DELETE CASCADE constraint when creating table
A
that has a forien key referencing table B.
here is an example:
suppose you have the table B which has deptno as a primary
key:
SQL> select * from B;
DEPTNO DNAME LOC
automatically
handled by database referential constraints. Basically you
need
to specify the DELETE CASCADE constraint when creating table
A
that has a forien key referencing table B.
here is an example:
suppose you have the table B which has deptno as a primary
key:
SQL> select * from B;
DEPTNO DNAME LOC
