--------学生表的创建------
create table stumsg
(
name varchar2(20),
num char(4) primary key
);
---------成绩表的创建--------
create table stuclass
(
num char(4),
math smallint,
chinese smallint,
constraint fk_class foreign key(num) references stumsg(num) on delete cascade,
constraint pk_class primary key(num)
);
-------创建触发器--------
set serveroutput on
create or replace trigger "trg_1"
after insert
on stumsg
begin
dbms_output.put_line('试一下学习一下触发器的使用...');
end trg_1;......
阅读全文