–触发器基本语法
–查看员工表的人数
create or replace trigger tri_in_emp
before --after
insert
on emp
declare
v_count int;
begin
select count(*) into v_count from emp;
dbms_output.put_line(‘员工人数为:’||v_count);
end;
insert into emp values();
select * from emp