级联删除

--create table a and b
--主表
Create Table department (dept_id number (4) Not Null Primary Key, name varchar2 (10), importdate date default sysdate);
--子表
Create Table employee (
emp_id number (4) Not Null Primary Key,
dept_id number (4), Not Null
name varchar2 (10),
importdate date default sysdate
);

Alter Table employee Add Constraint emp_fk Foreign Key (dept_id) References department(dept_id) on delete cascade;
commit;

--删除主表时，级联删除子表
添加数据时，应先添加主表的数据记录