如何建立自动递增的主键列？

[hychieftain]

请问是不是用create sequence这个命令，但我用了以后并不自动递增，请大虾给出具体代码，谢谢！

[zlqs]

再创建一个trigger，调用你创建的sequence的nextval,就可以实现递增。

[lianhg]

1)create sequence u_seq
2) insert into u_tbl values(u_se1.nextval , ....

[zgh2003]

创建自增序列：
SQL>CREATE SEQUENCE test_seq
SQL>INCREMENT BY 1
SQL>START WITH 1
SQL>MAXVALUE 9999999;
创建触发器(设表的自增列为Id)：
CREATE OR REPLACE TRIGGER seq_trigger
BEFORE INSERT ON table_name
FOR EACH ROW
DECLARE
s_ID number;
BEGIN
SELECT test_seq.nextval INTO s_ID FROM DUAL;
:NEW.ID:=s_ID;
END seq_trigger;

[S海鸥]

study

[hychieftain]

谢谢~~