自增语句

表名:jb_report

在oracle中数据库连接工具中输入命令:

create sequence jb_report_seq start with 1 increment by 1;  

create or replace trigger jb_report_trigger before insert on jb_report for each row begin select jb_report_seq.nextval into :new.rpid from dual; end ;