On 5/16/05, Emir Causevic <[EMAIL PROTECTED]> wrote:
> The Problem is that here is no LIMIT, TOP, or similar on Oracle.
> It's just that silly rownum, which you can use for that purpose and it
> doesn't behave always as one would expect.
> Especially with locking involved...
Emir,
Castor does not utilize the rownum variable to achieve this
functionality. It actually makes use of the RANK() function available
in Oracle 8.1.6 and above as part of the analytic functions.
Bruce
--
perl -e 'print unpack("u30","D0G)[EMAIL
PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
The Castor Project
http://www.castor.org/
Apache Geronimo
http://geronimo.apache.org/
