Skip to Main Content

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!

Oracle function to retrive the records randomly

senthilmcaJun 19 2013 — edited Jun 19 2013

I need function to pick the record from DB random manner.

For example, say we have 500 records and input value to the function is 5 means, it should display the records randomly between 1 to 5

Thanks

This post has been answered by 34MCA2K2 on Jun 19 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2013
Added on Jun 19 2013
12 comments
324 views