Class OracleQueryExpression

java.lang.Object
org.castor.cpa.persistence.sql.driver.JDBCQueryExpression
org.castor.cpa.persistence.sql.driver.OracleQueryExpression
All Implemented Interfaces:
QueryExpression

public final class OracleQueryExpression extends JDBCQueryExpression
QueryExpression for Oracle 7/8. As of release 8.1.6, Oracle supports limiting the number of rows returned by a query through the use of the following mechanism. SELECT * FROM ( SELECT empno, ename, job, sal, rank() over (order by sal) rnk FROM emp ) WHERE rnk BETWEEN 3 AND 8
Version:
$Revision: 8104 $ $Date: 2005-03-24 03:45:01 -0700 (Thu, 24 Mar 2005) $
Author:
Assaf Arkin