1、建立序列: CREATE SEQUENCE checkup_no_seq NOCYCLE MAXVALUE 9999999999 START WITH 2;
2、建立触发器: CREATE OR REPLACE TRIGGER set_checkup_no BEFORE INSERT ON checkup_history FOR EACH ROW DECLARE next_checkup_no NUMBER; BEGIN --Get the next checkup number from the sequence SELECT checkup_no_seq.NEXTVAL INTO next_checkup_no FROM dual;
--use the sequence number as the primary key --for the record being inserted :new.checkup_no := next_checkup_no; END;
第二种方法: select * from ( select rownum r,a from yourtable where rownum <= 20 order by name ) where r > 10 那么在选出的字段里就会自动的在最前加上ROENUM的字段,按递增排序的,这种用的挺方便的,我用过,