createtableTest_Increase(
useridnumber(10)NOTNULLprimarykey,/*主鍵，自動(dòng)增加*/
usernamevarchar2(20)
);

CREATESEQUENCETestIncrease_Sequence
INCREMENTBY1--每次加幾個(gè)
STARTWITH1--從1開(kāi)始計(jì)數(shù)
NOMAXVALUE--不設(shè)置最大值，設(shè)置最大值：maxvalue9999
NOCYCLE--一直累加，不循環(huán)
CACHE10;

CREATETRIGGERTest_IncreaseBEFORE
insertONTest_IncreaseFOREACHROW/*對(duì)每一行都檢測(cè)是否觸發(fā)*/
begin
selectTestIncrease_Sequence.nextvalinto:New.useridfromdual;
end;
//*退出sqlplus行編輯*/

commit;

Test_Increase(Username)values('test');