#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    Oracle function to retrive the records randomly


    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

    If user inputted value is 10 means, it should display one record between 1 to 10.


    Thanks
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    854
    Rep Power
    387

    Cool


    Homework -- right?

    Here is a hint: check out the DBMS_RANDOM package.

IMN logo majestic logo threadwatch logo seochat tools logo