Re: Tricky SQL Problem: Top "n" of queried records
From: Joel Garry <joelga_at_pebble.ml.org>
Date: 1998/03/21
Message-ID: <6f0rfo$5v3$1_at_pebble.ml.org>#1/1
Date: 1998/03/21
Message-ID: <6f0rfo$5v3$1_at_pebble.ml.org>#1/1
In article <3512F42A.B4591493_at_kenan.com>,
Brenda Muller <bmuller_at_kenan.com> wrote:
>In Sybase (and Sybase alone), you can "set rowcount 3" at the beginning of your
>transaction, which will restrict the server to returning only 3 rows. There is
>nothing analogous to this in Oracle.
In sybase, you can wait forever because one of those rows is on the same page as a completely unrelated row that someone has locked up. There is nothing analogous to this in Oracle.
-- These opinions are my own and not necessarily those of Information Quest jgarry_at_eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the _at_#%*& DBA!Received on Sat Mar 21 1998 - 00:00:00 CET