Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Random Number generator in Oracle???

Random Number generator in Oracle???

From: eoswa <eoswa_at_sol.co.uk>
Date: Mon, 22 Jun 1998 17:01:13 -0700
Message-ID: <358EF049.18D@sol.co.uk> 





Hi there,


I have a requirement to produce a report select in a random selection of 
records grouped by area - i.e. A report with 2 randomly chosen property 
records for each of the 450 areas in the database. Does anyone have any 
ideas on the best way to do this. I've considered using the SYSDATE as a 
seed for the random number generator but can't figure out the best way to 
proceed. 


Any help would be greatly appreciated.


Thanks


Keith Hill
Received on Mon Jun 22 1998 - 19:01:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US