Re: How to generate specified Random

    select name
    from doctors
    where speciality = 'Radiology'
    and rownum < 2;

Note that Oracle does not guarantee which doctor shows up, but most likely you'll get the same name every time you run the query. Is guess that is a problem for you?

Arjan. Received on Fri Aug 14 1998 - 00:00:00 CDT