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: 5951 $ $Date: 2005-03-24 03:45:01 -0700 (Thu, 24 Mar 2005) $

Author: Assaf Arkin

Constructor Summary
	OracleQueryExpression(PersistenceFactory factory)

Method Summary
String	getStatement(boolean lock)
boolean	isLimitClauseSupported() Indicates that Oracle supports an OQL LIMIT clause for versions >= 8.1.6.
boolean	isOffsetClauseSupported() 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.