create table Test_Table
(
ID number(11) primary key,
Name varchar(50) not null
)

create sequence AutoID
start with 1 //根據需要自己可修改該數值
increment by 1 //步長值
minvalue 1
nomaxvalue

create trigger AutoID_Trigger

before insert on Test_Table for each row
begin
select AutoID.nextval into :new.ID from dual;
end AutoID_Trigger;