Re: Random

>is there a function, in Oracle, to generate pseudo-random numbers (like RND
>or RANDOM) ?

Hi,

You can use dbms_random to generate random numbers but dbms_random can generated numbers that are not random enough, i.e. pseudo random numbers. The seed needs to be large enough. This package calls the internal number generator in the Oracle kernel. If you want better random numbers then use desgetkey and des3getkey in the package dbms_obfuscation_toolkit. I believe these are FIPS140 standard.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.