Hi,<br><br>one question: how I can create a Randomfunction with the DBMS_RANDOM Utility?? At the moment I'm a little bit clueless.<br><br>Thank you very much for your help.<br><br>SiM
1st of all dbms random is not a utility it is package supplied only with oracle 8.<br>there are four methods <br>1) initialize: initilize the random number genrator with seed value.<br>2) random: returns a random number.<br>3) seed: rset the seed number used to genrate the seed number.<br>4) terminate: terminates the random number genrator mechanism<br>note : donot use in sql.<br>usage not :<br> exec dbms_random.initialize(309666789);<br> use this method with at least 5 numbers.<br> <br> exec dbms_random.seed(455663349);<br><br> declare <br> my_random binary_integer;<br> begin<br> my_random := dbms_random.random;<br> end;<br><br> exec dbms_random.terminate;<br>i hope that will help <p>imran tariq thanvi<br><a href=mailto:ithanvi@hotmail.com>ithanvi@hotmail.com</a><br><a href= >dba</a><br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.