Home » SQL & PL/SQL » SQL & PL/SQL » Re: dbms_random
Re: dbms_random [message #35747] Thu, 11 October 2001 11:45 Go to next message
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 Go to previous message
Bernd
Messages: 2
Registered: October 2001
Junior Member
----------------------------------------------------------------------
Previous Topic: any ideas
Next Topic: Re: SOS!!!help, How I can query string in a LONG datatype?
Goto Forum:
  


Current Time: Sat May 25 03:23:25 CDT 2024