oracle 练习5

create or replace trigger emp_t
  before update  or delete or insert
  on emp
  begin
     if  to_char(sysdate,‘day’)=‘星期天' then
        raise_application_error(-20000, 'you would not 
                          update the emp table  on Wednesday') ;
     end if ;
  end ;
 
 
  select * from  user_triggers;
 
 
  delete from  emp where deptno=10;
 
 
  commit;
 
  select * from student;
 
  delete  from student where id=0;
 
  savepoint a;
 
  delete from student where id=4;
 
  savepoint b;
 
  rollback to b
 
  select * from student;
 
  rollback;
 
 
  ***************
  select * from student;
 
  insert into student values(6,'lx1');
 
  savepoint a;
 
  delete from student where id=0;
 
  savepoint  b;
 
  select * from student;
 
  rollback to a;
 
  delete from student where id=1;
 
  insert into  student  values(7,'lx2')
 
  savepoint c
  select * from student
 
  rollback to c;
 
 
  rollback to a;
 
    ***************
   
    select  * from  student ;
   
    savepoint a;
   
    delete from student;
   
    create table stu( id int,sname varchar(10))
   
    savepoint b
   
    select * from student;
   
    insert into stu values(1,'lx');
   
    select * from stu
   
    rollback to  b;
   
    select * from stu;
    rollback to a;------从未创建a点 create 让事务结束