oracle通过触发器和序列来定义自增主键，并且设置定时任务每秒钟插入一条数据到目标表

create table classinfo(
       classid number(2) primary key,
       classname varchar(10) not null       
);
       
-- Create sequence 
create sequence CLASSINFO_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
nocache;

       
CREATE OR REPLACE TRIGGER 
CLASSINFO_TRIGGER
before insert on classinfo
for each row
declare
begin
select CLASSINFO_SEQ.NEXTVAL into :NEW.classid from DUAL;
end ;

insert into classinfo values(null,'aaa');
insert into classinfo values(null,'aaa');
insert into classinfo values(null,'aaa');
insert into classinfo values(null,'aaa');

select * from classinfo

create or replace procedure CLASSINFO_PRO is
begin
  insert into classinfo values(null,'aaa');
end CLASSINFO_PRO;


declare
  job number;
BEGIN
  DBMS_JOB.SUBMIT(  
        JOB => job,  /*自动生成JOB_ID*/  
        WHAT => 'CLASSINFO_PRO;',  /*需要执行的存储过程名称或SQL语句*/  
        NEXT_DATE => sysdate+1/(24*60),  /*初次执行时间下一分钟*/  
        INTERVAL => 'sysdate+1/(24*60*60)' /*每隔1秒钟执行一次*/
      );  
  commit;
end;


select * from user_jobs;