Re: How to generate specified Random
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: 1998/08/14
Message-ID: <6r1j79$c2j$1_at_newton.a2000.nl>#1/1
Date: 1998/08/14
Message-ID: <6r1j79$c2j$1_at_newton.a2000.nl>#1/1
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 CEST