DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected DBCompareExpr |
connectBy |
protected int |
limitRows |
protected String |
optimizerHint |
protected int |
skipRows |
protected DBCompareExpr |
startWith |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, select, selectDistinct, set, where
cmdQuery, orderBy
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE
Constructor and Description |
---|
DBCommandOracle(boolean autoPrepareStmt)
Constructs an oracle command object.
|
Modifier and Type | Method and Description |
---|---|
protected void |
addDeleteForTable(StringBuilder buf,
DBRowSet table)
Creates an Oracle specific delete statement.
|
protected void |
addDeleteWithJoins(StringBuilder buf,
DBRowSet table) |
protected void |
addUpdateForTable(StringBuilder buf,
DBRowSet table) |
protected void |
addUpdateWithJoins(StringBuilder buf,
DBRowSet table) |
void |
clear()
Clears the entire command object.
|
void |
clearConnectBy()
Clears the connectBy Expression.
|
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
void |
connectByPrior(DBCompareExpr expr) |
String |
getOptimizerHint() |
Object[] |
getParamValues()
Returns an array of parameter values for a prepared statement.
|
void |
getSelect(StringBuilder buf)
Creates an Oracle specific select statement
that supports special features of the Oracle DBMS
like e.g.
|
DBCommandOracle |
limitRows(int limitRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
void |
setOptimizerHint(String optimizerHint) |
void |
setOptimizerIndexHint(DBIndex index) |
DBCommandOracle |
skipRows(int skipRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
void |
startWith(DBCompareExpr expr) |
addFrom, addGrouping, addJoin, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, joinLeft, joinRight, mergeSubqueryParams, notifyParamUsage, orderBy, orderBy, orderBy, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, set, set, setConstraint, useCmdParam, where, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, hasOrderBy, intersect, result, union, unionAll
getObjectValue
checkParamNull
protected DBCompareExpr connectBy
protected DBCompareExpr startWith
protected String optimizerHint
protected int limitRows
protected int skipRows
public DBCommandOracle(boolean autoPrepareStmt)
db
- the oracle database object this command belongs toDBCommand
public String getOptimizerHint()
public void setOptimizerHint(String optimizerHint)
public void setOptimizerIndexHint(DBIndex index)
public void clear()
DBCommand
clear
in class DBCommand
DBCommand.clear()
public void clearConnectBy()
public void connectByPrior(DBCompareExpr expr)
public void startWith(DBCompareExpr expr)
public DBCommandOracle limitRows(int limitRows)
DBCommand
public DBCommandOracle skipRows(int skipRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(StringBuilder buf)
public Object[] getParamValues()
DBCommand
getParamValues
in class DBCommand
protected void addUpdateForTable(StringBuilder buf, DBRowSet table)
addUpdateForTable
in class DBCommand
protected void addUpdateWithJoins(StringBuilder buf, DBRowSet table)
addUpdateWithJoins
in class DBCommand
protected void addDeleteForTable(StringBuilder buf, DBRowSet table)
addDeleteForTable
in class DBCommand
protected void addDeleteWithJoins(StringBuilder buf, DBRowSet table)
addDeleteWithJoins
in class DBCommand
Copyright © 2008–2022 Apache Software Foundation. All rights reserved.