Pinakin,

I can't see what is the point of your previous post.

Do you want to find out why your PL/SQL code is not working? You have to use DBMS_RANDOM.INITIALIZE to initialize your seed. If you have done so before you've run your anonymous block, then you should use it again after you used DBMS_RANDOM.TERMINATE in your first BEGIN-END block, if you wan't also the second part to succeed. Also, there is no particular need to change your seed very often (if at all) once you initialised it.

And what do you mean you have your work done by using SYSDATE? You mean you use SYDATE as a direct "semi-random" generator? If so, you could hardly treat that as a random generator.

Enlighten me if I'm missing the obvious....