摘要: //创建序列create sequence t_seqincrement by 1 start with 100 maxvalue 999999;//创建触发器create trigger t_trigger before insert on t for each rowbeginselectt_seq.nextval into :new.id from dual;//id需要自增的序列end; 阅读全文
posted @ 2011-03-31 16:26 appleying 阅读(173) 评论(0) 推荐(0) 编辑