Re: dbms_random [message #35747] |
Thu, 11 October 2001 11:45 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
try something like this:
select * from random_result
(select dbms_random.value, big_table.* from big_table order by 1) Random_result
where rownum < 150000
----------------------------------------------------------------------
|
|
|
Thanx [message #35773 is a reply to message #35747] |
Mon, 15 October 2001 06:03 |
Bernd
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
----------------------------------------------------------------------
|
|
|