org.apache.empire.db.oracle
Class DBCommandOracle
java.lang.Object
org.apache.empire.db.DBObject
org.apache.empire.db.DBExpr
org.apache.empire.db.DBCommandExpr
org.apache.empire.db.DBCommand
org.apache.empire.db.oracle.DBCommandOracle
- All Implemented Interfaces:
- Serializable, Cloneable
public class DBCommandOracle
- extends DBCommand
This class handles the special features of an oracle database.
- See Also:
- Serialized Form
Methods inherited from class org.apache.empire.db.DBCommand |
addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addWhere, addWhereConstraints, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, getDatabase, getInsert, getJoins, getParamValues, getSelectExprList, getTableList, getUpdate, getWhereConstraints, groupBy, hasJoinOn, hasJoinOn, hasSelectExpr, hasSetExprOn, hasWhereConstraints, having, isSelectDistinct, isValid, isValidQuery, isValidUpdate, join, join, join, join, join, notifyParamUsage, removeConstraintOn, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeWhereConstraintOn, resetParamUsage, select, select, select, selectDistinct, set, setConstraint, useCmdParam, where |
Methods inherited from class org.apache.empire.db.DBCommandExpr |
addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getSelect, intersect, orderBy, orderBy, orderBy, skipRows, union |
connectBy
protected DBCompareExpr connectBy
startWith
protected DBCompareExpr startWith
optimizerHint
protected String optimizerHint
rowNumExpr
protected OracleRowNumExpr rowNumExpr
DBCommandOracle
public DBCommandOracle(DBDatabase db)
- Constructs an oracle command object.
- Parameters:
db
- the oracle database object this command belongs to- See Also:
DBCommand
getOptimizerHint
public String getOptimizerHint()
setOptimizerHint
public void setOptimizerHint(String optimizerHint)
setOptimizerIndexHint
public void setOptimizerIndexHint(DBIndex index)
clear
public void clear()
- Description copied from class:
DBCommand
- Clears the entire command object.
- Overrides:
clear
in class DBCommand
- See Also:
DBCommand.clear()
clearConnectBy
public void clearConnectBy()
- Clears the connectBy Expression.
connectByPrior
public void connectByPrior(DBCompareExpr expr)
startWith
public void startWith(DBCompareExpr expr)
limitRows
public void limitRows(int numRows)
- Description copied from class:
DBCommandExpr
- set the maximum number of rows to return when executing a query command
A negative value will remove the limit.
- Overrides:
limitRows
in class DBCommandExpr
clearLimit
public void clearLimit()
- Description copied from class:
DBCommandExpr
- Clears a limit or offset set by calling limit() or offset()
- Overrides:
clearLimit
in class DBCommandExpr
getSelect
public void getSelect(StringBuilder buf)
- Creates the SQL statement the special characteristics of
the Oracle database are supported.
- Overrides:
getSelect
in class DBCommand
- Parameters:
buf
- the SQL statement
getDelete
public String getDelete(DBTable table)
- Creates the delete SQL-Command.
- Overrides:
getDelete
in class DBCommand
- Parameters:
table
- the table object
- Returns:
- the delete SQL-Command
Copyright © 2008-2012 Apache Software Foundation. All Rights Reserved.