写的不清楚。把你的数据和想要结果具体内容贴出来。是不是这个意思: OPER@tl> select * from test; ID VA ---------- -- 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 h 9 n 10 v已选择10行。OPER@tl> select * from ( 2 select rownum rn,val from ( 3 select * from test 4 connect by rownum<=15 5 order by dbms_random.value)) 6 where rn >=11 7 and rn<=15 8 / RN VA ---------- -- 11 h 12 n 13 a 14 c 15 eOPER@tl>
insert into tablename select seq.nextval,column1,column2... from tablename where id between 1 and 5 -- id in (1,3,5,6,8)
OPER@tl> select * from test; ID VA
---------- --
1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 n
10 v已选择10行。OPER@tl> select * from (
2 select rownum rn,val from (
3 select * from test
4 connect by rownum<=15
5 order by dbms_random.value))
6 where rn >=11
7 and rn<=15
8 / RN VA
---------- --
11 h
12 n
13 a
14 c
15 eOPER@tl>
select seq.nextval,column1,column2...
from tablename
where id between 1 and 5
-- id in (1,3,5,6,8)