Theres no easy way to do this that I know of. You can refer to records in your table through your primary key, or use the record id supplied by oracle. But you will have to find a way to randomly select one of the values. You might try dbms_random.random to get a random number, and then use that to select one of your values somehow (either by determining odd or even, or dividing it by something? This is just a though, I've never done this myself.