oracle id自动增长

CREATE TABLE CIS.FISCASH_MLDeclare

(Declare_Id          NUMBER,

FirstInput           VARCHAR2(25),

FirstInputName      VARCHAR2(25),

FirstInputDate       DATE,

Declare_Company   VARCHAR2(21),

ConCode             VARCHAR2(100),

FCashCoin           VARCHAR2(11),

FDeclare_Num       NUMBER(25,2),

FCashType           VARCHAR2(11),

FCashRemark         VARCHAR2(100),

DeclareDate         VARCHAR2(11),  

YearMonth          VARCHAR2(8),   

NumType          VARCHAR2(11), 

InvoiceNum        VARCHAR2(100),     

BusinessManId      VARCHAR2(21),

BusinessMan       VARCHAR2(21),

Business_Remark    VARCHAR2(100),

CashCoin           VARCHAR2(11),

Declare_Num       NUMBER(25,2),

CashType           VARCHAR2(11),

CashRemark         VARCHAR2(100),

ChangeType        CHAR(1),

UpdaterId          VARCHAR2(25),

UpdaterName       VARCHAR2(25),

UpdateDate         Date,

Confirm_Id         VARCHAR2(21),

Confirm_Name      VARCHAR2(21),

Confirm_Date       DATE,

Confirm_Flag       CHAR(1),

Confrim_Remark    VARCHAR2(100),

InputFlag          CHAR(1),

Declare_State       CHAR(1),

Fore_State          CHAR(1),

Remark            VARCHAR2(100),

PRIMARY KEY(Declare_Id)

)

 

Create Sequence CIS.FISCASH_MLDeclare_Id start with 1000 increment by 1;

Grant SELECT,ALTER  ON CIS.FISCASH_MLDeclare_Id TO cisprg

GRANT SELECT,INSERT,DELETE,UPDATE ON  CIS.FISCASH_MLDeclare TO cisprg;

 

String sql="insert into  CIS.FISCASH_MLDeclare(Declare_Id,Declare_Company,CashType,CashCoin,ConCode,Declare_Num,DeclareDate,CashRemark,Business_Remark,UpdaterId,UpdaterName,YearMonth,ChangeType,UpdateDate,InputFlag,Declare_State,FirstInputDate) values(CIS.FISCASH_MLDeclare_Id.nextVal,";