指定ORACLE某个字段，设置为自动编号？？

[monkey_heroin]

在ORACLE中如何设置指定字段让它自动编号，不用程序干预！！

急！急！

[newskysoft]

不想程序干预，呵呵，create a sequence and use trigger

[liulee]

不知道ROWID内部列是否可以满足你的需要？

[yousoft2013]

drop table extraTable CASCADE CONSTRAINTS;
create table extraTable (
ID number(10),
content varchar2(2000),
CONSTRAINT extratable55555_pk
PRIMARY KEY(ID)
);

DROP SEQUENCE extraTable_seq;
CREATE SEQUENCE extraTable_seq
start with 1
increment by 1
order
nocycle;

CREATE OR REPLACE TRIGGER set_extraTable_id
BEFORE INSERT ON extraTable
FOR EACH ROW
DECLARE
temp date;
BEGIN
SELECT extraTable_seq.NEXTVAL
INTO :new.id
FROM dual;
END;