先写一个序列create sequence SEQ_TIME_STAMPminvalue 10000maxvalue 99999start with 10001increment by 1nocachecycle;再写个触发器create or replace trigger 触发器名before insert on 表名 for each rowbegin
Select to_char(sysdate,'yyyymmdd')||seq_time_stamp.nextval
Into :new.报表信息编号
from dual;end;当你insert时,...