dbms_random

From: Sheela <spathiyal_at_yahoo.ca>
Date: 4 Feb 2005 08:00:54 -0800
Message-ID: <678ae5f9.0502040800.686af540@posting.google.com>

I have a question regarding dbms_random pkg. One jsp page needs to pull a random password from a table.

So, first I created a table and inserted 100 passwords and used this sql to display the random password.
SELECT password FROM
( SELECT password from px_password_selfreg ORDER BY DBMS_RANDOM.value )
WHERE ROWNUM = 1; Is this enough or do I need to initialize and terminate the pkg before and after the use?

Thank you in advance,

sheen Received on Fri Feb 04 2005 - 10:00:54 CST