Re: Simple Question!
From: Carl Gohringer <cgohring_at_lucifer>
Date: 1995/04/25
Message-ID: <3nio5g$1j7_at_dcsun4.us.oracle.com>#1/1
Date: 1995/04/25
Message-ID: <3nio5g$1j7_at_dcsun4.us.oracle.com>#1/1
tmaxwell_at_crl.com (Anthony B. Cillo) writes:
: I am trying to find the oldest 1000 patients in our database. The
: problem is that I cannot get the system to stop after returning 1000
: rows. I have tried using rownum but that only works if you are not
: using order by.
:
: Any ideas?
:
Use a PL/SQL block
-- regards, Carl +-----------------------------------------------------------------------------+ Carl Gohringer, Oracle European Development Centre, World Wide Education Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG Internet : cgohring_at_uk.oracle.com +-----------------------------------------------------------------------------+Received on Tue Apr 25 1995 - 00:00:00 CEST