DROP SEQUENCE seq_1;
CREATE SEQUENCE seq_1 ;
CREATE TABLE t(n INT,m INT);
INSERT INTO t SELECT seq_1.nextval ,object_id FROM user_objects s WHERE ROWNUM<21;
SELECT *FROM t;
输出:
N  M
1  165677
2  165678
3  165679
4    165680
5    165681
6    165682
7    165683
8    165684
9    165685
10    165686
11    165687
12    165688
13    165689
14    165690
15    165691
16    165692
17    165693
18    165694
19    165695
20    165696