| 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 |
|
|
|
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
