Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky SQL Problem: Top "n" of queried records
Joel Garry (joelga_at_pebble.ml.org) wrote:
: 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.
And Sybase has nothing analagous to "snapshot too old". Yada yada yada. Let's not start another religious war over a simple question. This can go on forever. Brenda has posted here many times and promotes Oracle's features as often as she promotes Sybase's. She gives responsible answers, don't discourage that.
Teresa Larson
-- _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ _/ Jay Masino and Teresa Larson __!__ _/ _/ Digital H/W Design Database Design _____(_)_____ _/ _/ Systems Engineering Sybase and Oracle ! ! ! _/ _/ UNIX/Network Admin UNIX and VAX Cherokee '69J _/ _/ C programming C programming _/ _/ http://www2.ari.net/jmasino/ _/ _/ jmasino_at_ari.net tlarson_at_ari.net jay-n-teresa_at_ari.net _/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/Received on Sun Mar 22 1998 - 00:00:00 CST