<div>
Write a stored function which will call dbms_random and return the value generated then call the stored function from within developer. This will work.
</div>


Write a stored function which will call dbms_random and return the value generated then call the stored function from within developer. This will work.

<div>
You have to create the function and store it in the database for this to work (Stored function).
</div>


You have to create the function and store it in the database for this to work (Stored function).

<div>
i want to a function which is generate a random function.<br />
because dbms.random isnt working on developer/2000 
</div>


i want to a function which is generate a random function.
because dbms.random isnt working on developer/2000

<div>
i want to a function which is generate a random number which is 8 and 6 digit.<br />
because dbms.random isnt working on developer/2000 
</div>


i want to a function which is generate a random number which is 8 and 6 digit.
because dbms.random isnt working on developer/2000

<div>
Hi adnat,<br />
<br />
What is the range of random numbers that you want to generate ?
</div>


Hi adnat,

What is the range of random numbers that you want to generate ?

<div>
the range of random number is 100000-999999 and<br />
10000000-99999999
</div>


the range of random number is 100000-999999 and
10000000-99999999

<div>
<div class="content wysiwyg-content">
hi,<br />
i want to generate random number on oracle.<br />
we can generate random numbers by using dbms_random.random function.<br />
and that works on sql/plus but it fails on developer/2000<br />
how can we use this function on developer/2000<br />
is there any another way to generate random numbers?<br />
<br />

</div>
</div>


hi,
i want to generate random number on oracle.
we can generate random numbers by using dbms_random.random function.
and that works on sql/plus but it fails on developer/2000
how can we use this function on developer/2000
is there any another way to generate random numbers?



random number generate on oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.