Oracle与DB2中序列处理

1、序列定义    
   ORACLE:   
             CREATE SEQUENCE <sequence_name>
          INCREMENT BY <integer>
              START WITH <integer>
           MAXVALUE <integer> / NOMAXVALUE
           MINVALUE <integer> / NOMINVALUE
              CYCLE / NOCYCLE
              CACHE <#> / NOCACHE
              ORDER / NOORDER;   
    
   DB2:    
             CREATE SEQUENCE <sequence-name> 
                 AS data-type                           默认 As Integer
              START WITH <numeric-constant>   
          INCREMENT BY <numeric-constant>               默认 INCREMENT BY 1
           MINVALUE <numeric-constant> | NO MINVALUE    默认 NO MINVALUE
           MAXVALUE <numeric-constant> | NO MAXVALUE    默认 NO MAXVALUE