How to generate random number (up to 7 digits) in Oracle?

Hi,

Could you give me a hint on how to generate random numbers (up to 7 or 8 digits) in Oracle. The idea is to randomly select 100 account for creating a snapshot. The account number is up to 7 or 8 digits.

Any help is highly appreciated.

Regards,

Leon,

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!