create
table
a(item
varchar
(10), f
int
, t
int
);
insert into a values('A', 1, 10);
insert into a values('B', 20, 40);
insert into a values('C', 45, 50);
commit;
SQL> select item, level + a.f-1
2 from a
3 connect by level <= a.t-a.f+1
4 and prior rowid = rowid
5 and prior dbms_random.value is not null;
ITEM LEVEL+A.F-1
---------- -----------
A 1
A 2
A 3
A 4
A 5
A 6
A 7
A 8
A 9
A 10
B 20
B 21
B 22
B 23
B 24
B 25
B 26
B 27
B 28
B 29
B 30
B 31
B 32
B 33
B 34
B 35
B 36
B 37
B 38
B 39
B 40
C 45
C 46
C 47
C 48
C 49
C 50
已选择37行。