Oracle事务示例及注意事项

ORACLE事务学习笔记   有关事务的语句 commit, rollback, savepoint, settransaction   drop table t2 purge; create table t2 (x int);     drop table t3 purge; create table t3 (x int check(x>0));     create or replace trigger t_trigger   before insert or delete on t3  for each row declare begin if(inserting) then  update t2 set x=x+1; else  update t2 set x=x-1;  end if;    dbms_output.put_line(sql%rowcount||'条记录已经被触发并且更新'); endt_trigger;   insert into t2 values(1);...