Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any function generating a random number ?

444596Jul 9 2008 — edited Jul 9 2008
Is there any function which yields a random number every time from a given list of numbers ?

e.g.

Consider table t as :

invoice_no
123
456
789
654
321
987

I want a function executed manually yielding a random invoice no.

How can i achieve ?

Regards

Capri !!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2008
Added on Jul 9 2008
16 comments
696 views