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  _/
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/