public class OracleSQLGenerator extends GenericSQLGenerator
AND, INIT_WIDTH_FROM, INIT_WIDTH_GROUP_BY, INIT_WIDTH_ORDER_BY, INIT_WIDTH_SELECT, INIT_WIDTH_SQL, INIT_WIDTH_WHERE, MAX_ELEMENTS_IN
Modifier and Type | Method and Description |
---|---|
protected StringBuilder |
createOffsetLimitClause(int offset,
int limit,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
SQLStatementIF |
createSQLStatement(SQLQuery query)
INTERNAL: Create a concrete SQL statement from the given abstract
SQL query.
|
protected String |
createStatement(SQLExpressionIF filter,
List selects,
boolean distinct,
int offset,
int limit,
List orderby,
boolean issetquery,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
protected void |
fromSQLLeftOuterJoin(SQLJoin join,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
protected void |
fromSQLRightOuterJoin(SQLJoin join,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
protected String |
getSetOperator(int operator) |
boolean |
supportsLimitOffset()
INTERNAL: Returns true if generator supports the functionality of
OFFSET/LIMIT.
|
protected void |
whereSQLFalse(SQLFalse expr,
StringBuilder sql,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
protected void |
whereSQLLeftOuterJoin(SQLJoin join,
StringBuilder sql,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
protected void |
whereSQLRightOuterJoin(SQLJoin join,
StringBuilder sql,
net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info) |
analyzeExpression, analyzeExpressions, analyzeOrderBy, analyzeQuery, analyzeSelect, analyzeValue, atomicSQLValueIF, createFromClause, createGroupByClause, createOrderByClause, createSelectClause, createStatement, createStatement, createWhereClause, escapeString, flattenSQLValueIF, flattenSQLValueIF, fromSQLCrossJoin, fromSQLJoin_GENERIC, fromSQLJoin, fromSQLLeftOuterJoin, fromSQLRightOuterJoin, fromSQLTable, fromSubSelectAlias, getSQLGenerator, getSQLGenerator, isFromLevel, isPatternFunction, joinSQLValueIF, produceFrom, produceGroupBy, produceOrderBy, produceSelect, produceWhere, referenceSQLColumnsColumn, referenceSQLFunction, referenceSQLPrimitive, referenceSQLTableAndAlias, referenceSQLValueIFOpBinary, referenceSQLValueIFOpUnary, selectColumnAlias, selectColumnAlias, selectSQLAggregateIF, selectSQLColumns, selectSQLFunction, selectSQLNull, selectSQLPrimitive, selectSQLValueIF, selectSQLVerbatim, whereSQLAnd, whereSQLCrossJoin_GENERIC, whereSQLCrossJoin, whereSQLEquals, whereSQLExists, whereSQLExpressionIF, whereSQLExpressionIF, whereSQLIn, whereSQLIsNull, whereSQLJoin, whereSQLLeftOuterJoin_GENERIC, whereSQLLeftOuterJoin_ORACLE, whereSQLLike, whereSQLNot, whereSQLNotEquals, whereSQLOr, whereSQLRightOuterJoin_GENERIC, whereSQLRightOuterJoin_ORACLE, whereSQLSetOperation, whereSQLValueEqualsNull, whereSQLValueExpression, whereSQLValueNotEqualsNull, whereSQLVerbatimExpression
public SQLStatementIF createSQLStatement(SQLQuery query)
SQLGeneratorIF
createSQLStatement
in interface SQLGeneratorIF
createSQLStatement
in class GenericSQLGenerator
protected String createStatement(SQLExpressionIF filter, List selects, boolean distinct, int offset, int limit, List orderby, boolean issetquery, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
createStatement
in class GenericSQLGenerator
protected void fromSQLLeftOuterJoin(SQLJoin join, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void fromSQLRightOuterJoin(SQLJoin join, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void whereSQLLeftOuterJoin(SQLJoin join, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
whereSQLLeftOuterJoin
in class GenericSQLGenerator
protected void whereSQLRightOuterJoin(SQLJoin join, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
whereSQLRightOuterJoin
in class GenericSQLGenerator
protected String getSetOperator(int operator)
getSetOperator
in class GenericSQLGenerator
protected StringBuilder createOffsetLimitClause(int offset, int limit, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
createOffsetLimitClause
in class GenericSQLGenerator
public boolean supportsLimitOffset()
SQLGeneratorIF
supportsLimitOffset
in interface SQLGeneratorIF
supportsLimitOffset
in class GenericSQLGenerator
protected void whereSQLFalse(SQLFalse expr, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
whereSQLFalse
in class GenericSQLGenerator