oracle实战技巧（四）oracle触发器(主键自增脚本)

  

   

    

     

    
    

     

      create or replace trigger server_tri
     
    
   

    

     

    
    

     
   before
     
    
   

    

     

    
    

     
      insert on server
     
    
   

    

     

    
    

     
   for each row
     
    
   

    

     

    
    

     
 declare
     
    
   

    

     

    
    

     
 begin
     
    
   

    

     

    
    

     
   SELECT server_seq.Nextval  INTO :NEW.id FROM DUAL;
     
    
   

    

     

    
    

     
 end server_tri;
     
    
  
 

文章来源: baocl.blog.csdn.net，作者：小黄鸡1992，版权归原作者所有，如需转载，请联系作者。

原文链接：baocl.blog.csdn.net/article/details/105654078