org.exolab.castor.jdo.drivers

Class OracleQueryExpression

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: 1.7 $ $Date: 2005/03/24 10:44:58 $

Author: Assaf Arkin

Constructor Summary
OracleQueryExpression(PersistenceFactory factory)
Method Summary
StringgetStatement(boolean lock)
booleanisLimitClauseSupported()
Indicates that Oracle supports an OQL LIMIT clause for versions >= 8.1.6.
booleanisOffsetClauseSupported()
Indicates that Oracle supports an OQL OFFSET clause for versions >= 8.1.6.

Constructor Detail

OracleQueryExpression

public OracleQueryExpression(PersistenceFactory factory)

Method Detail

getStatement

public String getStatement(boolean lock)

isLimitClauseSupported

public boolean isLimitClauseSupported()
Indicates that Oracle supports an OQL LIMIT clause for versions >= 8.1.6.

Returns: true to indicate that Oracle supports an OQL LIMIT clause.

isOffsetClauseSupported

public boolean isOffsetClauseSupported()
Indicates that Oracle supports an OQL OFFSET clause for versions >= 8.1.6.

Returns: true to indicate that Oracle supports an OQL OFFSET clause.

Intalio Inc. (C) 1999-2004. All rights reserved http://www.intalio.com