Package | Description |
---|---|
oracle.ide.db.panels.sql |
UI for declaratively editing a SQL query.
|
oracle.ide.db.util |
Utility classes for dealing with database objects in UI in the IDE.
|
oracle.javatools.db |
Contains a metadata API for describing database objects, and retrieving them
from a provider of database objects - for example a database.
|
oracle.javatools.db.ora |
Contains the database api implementation for Oracle databases, and additional
DBObject implementations for objects specific to Oracle.
|
oracle.javatools.db.sql |
Contains an API for declaratively parsing SQL queries (SELECT statements).
|
Modifier and Type | Method and Description |
---|---|
SQLQuery |
SQLQueryEditDialog.editQuery(SQLQuery query,
SQLFragment defaultObject,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query.
|
static java.lang.String[] |
SQLQueryEditDialog.getStartPage(SQLFragment child,
boolean incMaster)
Returns the appropriate start page path for editing the given child of a
query.
|
Modifier and Type | Method and Description |
---|---|
javax.swing.tree.DefaultMutableTreeNode |
TreeNodeMaker.createTreeNode(SQLFragment obj)
Creates a TreeNode using the defaults set on this TreeNodeMaker for child
nodes for the given SQLFragment.
|
javax.swing.tree.DefaultMutableTreeNode |
TreeNodeMaker.createTreeNode(SQLFragment obj,
boolean showAvailKids)
Creates a TreeNode using the defaults set on this TreeNodeMaker but gives
an extra customisation - the ability to show available children - e.g.
|
static javax.swing.tree.DefaultMutableTreeNode |
DBObjectRenderer.createTreeNode(SQLFragment obj,
boolean showChildren)
Deprecated.
- use a TreeNodeMaker.
|
Modifier and Type | Method and Description |
---|---|
SQLFragment |
CheckConstraint.getCheckConditionFragment()
Retrieves the conditional expression represented by this constraint
which is derived from the check condition.
|
static SQLFragment |
DBUtil.getColumnExpressionFragment(java.lang.String expression,
Relation rel,
DBObjectProvider pro,
boolean quoteColumns)
Construct a SQLFragment for the given Column Expression
|
SQLFragment |
Column.getVirtualExpression()
Retrieves the Virtual Expression for the Column.
|
Modifier and Type | Method and Description |
---|---|
void |
CheckConstraint.setCheckConditionFragment(SQLFragment condition)
Sets the conditional expression represented by this constraint which
is derived from the check condition.
|
void |
Column.setVirtualExpression(SQLFragment expression)
Sets the Virtual Expression for the Column.
|
Modifier and Type | Class and Description |
---|---|
class |
OracleSQLQuery
Deprecated.
- folded in to SQLQuery
|
Modifier and Type | Interface and Description |
---|---|
interface |
AliasFragment
SQLFragment that consists of an expression and an alias.
|
interface |
DBObjectUsage
Interface implemented by fragments that use a DBObjectID to refer to another
DBObject.
|
interface |
FromObjectUsage
Interface implemented by any object that directly depends on a FromObject
(e.g.
|
interface |
JoinCondition |
interface |
SQLFragmentWithDatatype
A SQLFragment that has a datatype, for example, a ColumnUsage or an Operation.
|
Modifier and Type | Class and Description |
---|---|
class |
AbstractAliasFragment
SQLFragment that consists of an expression and an alias.
|
class |
AbstractDBObjectUsage
Abstract implementation for a SQLFragment that uses another DBObject (e.g
a Column) through a FromObject in the query.
|
class |
AbstractFromObjectUsage
Abstract SQLFragment implementation of FromObjectUsage.
|
class |
AbstractProviderUsageSQLFragment
Abstract SQLFragment implementation that is also a ProviderUsage.
|
class |
AbstractSchemaObjectUsage
Abstract class for usages that reference a SchemaObject (e.g.
|
class |
AbstractSQLFragment
Abstract superclass for SQLFragment implementations.
|
class |
AbstractSQLQuery
Deprecated.
- folded in to SQLQuery
|
class |
ArithmeticOperation
Concrete subclass of Operation for arithmetic operations - ADD, SUBTRACT,
MULTIPLY and DIVIDE.
|
class |
AsteriskUsage
Deprecated.
- use ColumnKeywordUsage
|
class |
CaseStatement
Class to represent a case statement in a sql query.
CASE [expression] WHEN condition THEN thenExpression WHEN condition THEN thenExpression ... |
static class |
CaseStatement.WhenThen |
class |
ColumnKeywordUsage
A FromObjectUsage that has a keyword for the Column name, rather than an
actual column.
|
class |
ColumnUsage
SQL fragment that is a use of a Column.
|
class |
Comparison
Subclass of Operation for comparisons.
|
class |
DataMiningFunction
Subclass of Operation for data mining functions.
|
static class |
DataMiningFunction.DataMiningArguments
Deprecated.
no longer required, use get/setDmSpecificArgs directly.
|
static class |
DataMiningFunction.DataMiningCostValues
An array of values
|
class |
ExpressionList
List of expressions.
|
class |
FKUsage
SQLFragment for the usage of a FKConstraint.
|
class |
FromObject
Object that represents a clause in the FROM statement of a SQL query.
|
class |
Function
Subclass of Operation for functions.
|
class |
FunctionUsage |
class |
GroupByExpression
Expression for a part of a group by that isn't a simple column (e.g.
|
class |
GroupByObject
SQLFragment for the GROUP BY ...
|
class |
HierarchicalQueryObject
SQLFragment for the Hierarchical Query clause in a SQLQuery.
|
class |
IndexObject
Object to wrap each column eaxpression of the Index statement
|
class |
JoinObject
Object that represent the JOIN clause of a SELECT statement (part of the
FROM clause).
|
class |
ModelObject
SQLFragment for the MODEL clause in a SQLQuery.
|
static class |
ModelObject.CellAssignment |
static class |
ModelObject.CellReferenceOptions |
static class |
ModelObject.ModelColumnClauses |
static class |
ModelObject.ModelRulesCellAssignmentExpr |
static class |
ModelObject.ModelRulesClause |
static class |
ModelObject.MultiColumnForLoop |
static class |
ModelObject.ReferenceModel |
static class |
ModelObject.SingleColumnForLoop |
class |
NonDeclarativeSQLQuery
Deprecated.
folded into SQLQuery
|
class |
OnJoinCondition
Object to represent the ON condition of a JOIN clause.
|
class |
Operation
Abstract class for operations.
|
class |
OrderByObject
Object to wrap each part of the ORDER BY clause of a SQLQuery.
|
class |
PlSqlUsage
Fragment that represents a usage of a piece of PlSql.
|
class |
RelationUsage
SQL fragment that is a use of a Relation.
|
class |
SelectObject
Object that represents a clause in the SELECT statement of a SQL query.
|
class |
SelectObjectUsage
Class that represents the usage of a SelectObject.
|
class |
SequenceUsage
SQL fragment that is a use of a Sequence.
|
class |
SetOperation
SQLFragment for dealing with operations to do with sets and ranges like
IN and BETWEEN.
|
class |
SetOperator
SQLFragment for dealing with queries that are linked using one of the SET
operators INTERSECT, UNION, MINUS and UNION ALL.
|
class |
SimpleSQLFragment
SQLFragment that we can't break down any more.
|
class |
SQLQuery
Object that represents a SQL query.
|
class |
SynonymUsage
SQLFragment for using a Synonym or Alias in a SQL query.
|
class |
UsingJoinCondition
Object to represent the condition part of a JOIN that has a USING clause.
|
class |
WhereObject
Object that represents a clause in the WHERE statement of a SQL query.
|
class |
WindowFunction
Subclass of Function for windowing functions (using the OVER syntax).
|
static class |
WindowFunction.WindowFunctionBound |
class |
XMLFunctionUsage
Use spaces as argument seperators.
|
Modifier and Type | Field and Description |
---|---|
protected static SQLFragment[] |
AbstractSQLQueryBuilder.EMPTY_ARRAY |
protected static SQLFragment[] |
AbstractSQLFragment.EMPTY_ARRAY |
Modifier and Type | Method and Description |
---|---|
SQLFragment |
SQLFragmentFactory.createFragment(SQLQueryBuilder builder,
SQLFragment parent,
java.lang.String clause) |
SQLFragment |
AbstractSQLQueryBuilder.createFromFactory(SQLFragment parent,
java.lang.String clause,
java.lang.Integer offset) |
SQLFragment[] |
Operation.getArguments()
Returns the arguments stored in this function.
|
SQLFragment[] |
Comparison.getArguments() |
SQLFragment[] |
PlSqlUsage.getArguments() |
SQLFragment[] |
DataMiningFunction.DataMiningCostValues.getArguments() |
SQLFragment[] |
DataMiningFunction.DataMiningArguments.getArguments()
Deprecated.
|
SQLFragment[] |
WindowFunction.WindowFunctionBound.getBoundExpr() |
SQLFragment[] |
WindowFunction.getBounds() |
SQLFragment[] |
ModelObject.CellAssignment.getCellAssignment() |
SQLFragment |
ModelObject.ReferenceModel.getCellReferenceOptions() |
SQLFragment |
HierarchicalQueryObject.getConnectBy() |
SQLFragment[] |
SQLQueryBuilder.getDependentObjects(FromObject from)
Returns all objects that are dependent on the given FromObject.
|
SQLFragment[] |
AbstractSQLQueryBuilder.getDependentObjects(FromObject from)
Gets the objects in the query that are dependent on the given from object.
|
SQLFragment[] |
SQLQueryBuilder.getDependentObjects(SelectObject select)
Returns all objects that are dependent on the given SelectObject.
|
SQLFragment[] |
AbstractSQLQueryBuilder.getDependentObjects(SelectObject select)
Gets the objects in the query that are dependent on the given select
object.
|
SQLFragment |
ModelObject.ModelColumnClauses.getDimensionByExpressionList() |
SQLFragment[] |
DataMiningFunction.getDmCostValues()
Gets the cost class values for this function.
|
SQLFragment[] |
DataMiningFunction.getDmSpecificArgs()
Gets the function specific arguments for this function.
|
SQLFragment |
CaseStatement.getElseExpression() |
SQLFragment |
ModelObject.ModelRulesCellAssignmentExpr.getExpr() |
SQLFragment |
OrderByObject.getExpression()
Gets the expression for this ORDER BY object.
|
SQLFragment |
CaseStatement.getExpression() |
SQLFragment |
AliasFragment.getExpression()
Returns the expression portion of this SQLFragment.
|
SQLFragment |
IndexObject.getExpression()
Gets the expression for this Index object which is derived from the
expression source.
|
SQLFragment |
AbstractAliasFragment.getExpression()
Returns the expression portion of this SQLFragment.
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpression(DBObjectProvider provider,
Relation relation,
SQLFragmentExpressionBuilder.ExpressionType type,
java.lang.String expression)
For the given relation in the given provider, creates a SQLFragment condition
representing the condition (such as a where clause predicate or check
constraint)
If the parser fails, return a SimpleSQLFragment for the expression string.
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpression(DBObjectProvider provider,
Relation relation,
SQLFragmentExpressionBuilder.ExpressionType type,
java.lang.String expression,
boolean ignorErrors)
Deprecated.
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpressionOrFail(DBObjectProvider provider,
Relation relation,
SQLFragmentExpressionBuilder.ExpressionType type,
java.lang.String expression)
For the given relation in the given provider, creates a SQLFragment condition
representing the condition (such as a where clause predicate or check
constraint)
|
SQLFragment[] |
GroupByObject.getExpressions() |
SQLFragment |
Comparison.getLeftExpression()
Gets the left expression.
|
SQLFragment |
ModelObject.getMainModelCellReferenceOptions() |
SQLFragment |
ModelObject.ModelColumnClauses.getMeasuresExpressionList() |
SQLFragment |
DataMiningFunction.getModel() |
SQLFragment |
ModelObject.getModelColumnClauses() |
SQLFragment |
ModelObject.ReferenceModel.getModelColumnClauses() |
SQLFragment |
ModelObject.ModelRulesCellAssignmentExpr.getModelRulesCellAssignment() |
SQLFragment |
ModelObject.getModelRulesClause() |
SQLFragment |
SQLQueryBuilder.SQLQueryObjectSet.getObject() |
SQLFragment |
ModelObject.ModelRulesCellAssignmentExpr.getOrderBy() |
SQLFragment[] |
WindowFunction.getPartitionBy() |
SQLFragment |
ModelObject.ModelColumnClauses.getPartitionByExpressionList() |
SQLFragment |
FromObject.getPivotExpression() |
SQLFragment[] |
ModelObject.getReferenceModels() |
SQLFragment |
Comparison.getRightExpression()
Gets the right expression.
|
SQLFragment |
HierarchicalQueryObject.getStartWith() |
SQLFragment |
FromObject.getSubqueryFactoringClause() |
SQLFragment |
CaseStatement.WhenThen.getThenExpression() |
SQLFragment |
ModelObject.ModelRulesClause.getUntilCondition() |
SQLFragment |
CaseStatement.WhenThen.getWhenExpression() |
SQLFragment |
SQLQueryBuilder.parseFromExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a From
object.
|
SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression) |
protected SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression,
FromObject creating) |
SQLFragment |
SQLQueryBuilder.parseHavingExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Having
object.
|
SQLFragment |
AbstractSQLQueryBuilder.parseHavingExpression(java.lang.String expression)
By default this calls parseWhereExpression().
|
SQLFragment |
SQLQueryBuilder.parseOrderByExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Order By
object.
|
SQLFragment |
AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression) |
protected SQLFragment |
AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression,
OrderByObject obo) |
SQLFragment |
SQLQueryBuilder.parseSelectExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Select
object.
|
SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression) |
protected SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression,
SelectObject creating) |
SQLFragment |
SQLQueryBuilder.parseWhereExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Where
object.
|
SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression) |
SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression,
WhereObject creating) |
Modifier and Type | Method and Description |
---|---|
void |
Operation.addArgument(int index,
SQLFragment expression) |
void |
Comparison.addArgument(int index,
SQLFragment expression) |
void |
Operation.addArgument(SQLFragment expression) |
void |
Comparison.addArgument(SQLFragment expression) |
void |
Operation.addArguments(SQLFragment[] expressions) |
void |
Comparison.addArguments(SQLFragment[] expressions) |
void |
GroupByObject.addExpression(int index,
SQLFragment s) |
void |
GroupByObject.addExpression(SQLFragment s) |
void |
SQLQueryBuilder.addGroupByColumn(int index,
SQLFragment colu)
Adds the given FromObjectUsage to the specified index of the GROUP BY clause.
|
void |
AbstractSQLQueryBuilder.addGroupByColumn(int index,
SQLFragment colu) |
void |
SQLQueryBuilder.addGroupByColumn(SQLFragment colu)
Adds the given FromObjectUsage to the end of the GROUP BY clause.
|
void |
AbstractSQLQueryBuilder.addGroupByColumn(SQLFragment colu) |
protected void |
Operation.checkArgument(java.util.List<SQLFragment> existing,
SQLFragment add)
If this returns true the Operation checks that the type of all arguments
is the same.
|
SQLFragment |
SQLFragmentFactory.createFragment(SQLQueryBuilder builder,
SQLFragment parent,
java.lang.String clause) |
SQLFragment |
AbstractSQLQueryBuilder.createFromFactory(SQLFragment parent,
java.lang.String clause,
java.lang.Integer offset) |
protected void |
AbstractSQLQueryBuilder.ensureIDs(SQLFragment... frags) |
FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromExpression(java.lang.String colName,
boolean external,
SQLFragment exp,
boolean allowDuplicates,
FromObject from,
SQLFragment creating)
Finds a Column of given name in the given FromObject's expression.
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromObjects(java.lang.String colName,
boolean external,
FromObject[] froms,
boolean allowDuplicates,
boolean enforceInAll,
SQLFragment creating)
Finds a Column of given name amongst the given FromObjects.
|
FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromObjects(java.lang.String colName,
boolean external,
SQLFragment creating,
FromObject... extraFroms)
Finds a Column of given name amongst the RelationUsages in the query.
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInJoin(java.lang.String colName,
boolean external,
JoinObject join,
boolean allowDuplicates,
SQLFragment creating)
Finds a column in the child FromObjects of a given JoinObject.
|
static java.util.Collection<java.lang.String[]> |
ParserUtils.getColumnNames(SQLFragment sqlFragment) |
static java.lang.String |
ParserUtils.getConstant(SQLFragment frag)
Returns the value of a constant fragment, or null if frag
isn't a constant.
|
static java.lang.String |
ParserUtils.getHexToRawString(SQLFragment frag)
Get hextoraw String.
|
static java.lang.String |
ParserUtils.getString(SQLFragment frag)
Get a String constant.
|
protected java.lang.String |
AbstractSQLFragment.getTextOrNull(SQLFragment frag)
Returns the SQLText for the given fragment, or null if the fragment itself
is null.
|
protected java.lang.String |
AbstractSQLFragment.getTextOrNull(SQLFragment frag,
boolean surroundWithBrackets)
Returns the SQLText for the given fragment, or null if the fragment itself
is null.
|
static boolean |
ParserUtils.isAllowedExpression(SQLFragment frag,
java.util.Collection<java.lang.String> validOperators)
Is this one of the allowed expression fragments?
The name of the fragment operation is compared to the collection
of valid operators.
|
static boolean |
ParserUtils.isConstant(SQLFragment frag)
Could this be a non null string or numeric constant.
|
static java.util.Collection<java.lang.String> |
SQLFragmentUtils.listColumnNames(SQLFragment expression)
Lists the columns available from the given SQLFragment.
|
static java.util.Collection<Column> |
SQLFragmentUtils.listColumns(SQLFragment expression)
Deprecated.
- Columns availble from
SQLQueryBuilder.getColumns() |
static java.util.Collection<ColumnUsage> |
SQLFragmentUtils.listColumnUsages(SQLFragment expression)
Deprecated.
use the generic DBUtil.findChildren method to find children
of a given class underneath the SQLFragment. i.e.
DBUtil.findChildren( expression, ColumnUsage.class ) |
void |
GroupByObject.moveExpression(SQLFragment s,
int newIndex) |
boolean |
Operation.removeArgument(SQLFragment expression) |
boolean |
Comparison.removeArgument(SQLFragment expression) |
boolean |
GroupByObject.removeExpression(SQLFragment s) |
boolean |
SQLQueryBuilder.removeGroupByColumn(SQLFragment colu)
Removes the given FromObjectUsage from the GROUP BY clause.
|
boolean |
AbstractSQLQueryBuilder.removeGroupByColumn(SQLFragment colu) |
protected boolean |
AbstractSQLQueryBuilder.removeWhereObject(SQLFragment obj)
Removes a top level WhereObject from the WHERE clause.
|
void |
Operation.setArguments(SQLFragment[] arguments)
Sets the arguments for this function.
|
void |
Comparison.setArguments(SQLFragment[] arguments) |
void |
PlSqlUsage.setArguments(SQLFragment[] arguments) |
void |
DataMiningFunction.DataMiningCostValues.setArguments(SQLFragment[] args) |
void |
DataMiningFunction.DataMiningArguments.setArguments(SQLFragment[] args)
Deprecated.
|
void |
WindowFunction.WindowFunctionBound.setBoundExpr(SQLFragment[] boundExpr) |
void |
WindowFunction.setBounds(SQLFragment[] bounds) |
void |
ModelObject.CellAssignment.setCellAssignment(SQLFragment[] exprs) |
void |
ModelObject.ReferenceModel.setCellReferenceOptions(SQLFragment cellReferenceOptions) |
void |
HierarchicalQueryObject.setConnectBy(SQLFragment connectBy) |
void |
ModelObject.ModelColumnClauses.setDimensionByExpressionList(SQLFragment expressionList) |
void |
DataMiningFunction.setDmCostValues(SQLFragment[] arguments)
Sets the cost class values for this function.
|
void |
DataMiningFunction.setDmSpecificArgs(SQLFragment[] arguments)
Sets the function specific arguments for this function.
|
void |
CaseStatement.setElseExpression(SQLFragment elseExpression) |
void |
ModelObject.ModelRulesCellAssignmentExpr.setExpr(SQLFragment expr) |
void |
OrderByObject.setExpression(SQLFragment exp)
Sets the expression for this ORDER BY object.
|
void |
CaseStatement.setExpression(SQLFragment expression) |
void |
AliasFragment.setExpression(SQLFragment exp)
Sets the expression portion of this SQLFragment.
|
void |
IndexObject.setExpression(SQLFragment exp)
Sets the expression for this Index object which should be derived from
the expression source.
|
void |
AbstractAliasFragment.setExpression(SQLFragment expression)
Sets the expression part of the fragment.
|
void |
FromObject.setExpression(SQLFragment exp) |
void |
GroupByObject.setExpressions(SQLFragment[] exps) |
void |
Comparison.setLeftExpression(SQLFragment leftExpression)
Sets the left expression.
|
void |
ModelObject.setMainModelCellReferenceOptions(SQLFragment mainModelCellReferenceOptions) |
void |
ModelObject.ModelColumnClauses.setMeasuresExpressionList(SQLFragment expressionList) |
void |
DataMiningFunction.setModel(SQLFragment model)
Sets the datamodel for this function
|
void |
ModelObject.setModelColumnClauses(SQLFragment modelColumnClauses) |
void |
ModelObject.ReferenceModel.setModelColumnClauses(SQLFragment modelColumnClauses) |
void |
ModelObject.ModelRulesCellAssignmentExpr.setModelRulesCellAssignment(SQLFragment cellAssignment) |
void |
ModelObject.setModelRulesClause(SQLFragment modelRulesClause) |
void |
ModelObject.ModelRulesCellAssignmentExpr.setOrderBy(SQLFragment orderBy) |
void |
WindowFunction.setPartitionBy(SQLFragment[] frags) |
void |
ModelObject.ModelColumnClauses.setPartitionByExpressionList(SQLFragment expressionList) |
void |
FromObject.setPivotExpression(SQLFragment pivot) |
void |
ModelObject.setReferenceModels(SQLFragment[] referenceModels) |
void |
Comparison.setRightExpression(SQLFragment rightExpression)
Sets the right expression.
|
void |
HierarchicalQueryObject.setStartWith(SQLFragment startWith) |
void |
FromObject.setSubqueryFactoringClause(SQLFragment value) |
void |
CaseStatement.WhenThen.setThenExpression(SQLFragment thenExpression) |
void |
ModelObject.ModelRulesClause.setUntilCondition(SQLFragment condition) |
void |
CaseStatement.WhenThen.setWhenExpression(SQLFragment whenExpression) |
Modifier and Type | Method and Description |
---|---|
protected void |
Operation.checkArgument(java.util.List<SQLFragment> existing,
SQLFragment add)
If this returns true the Operation checks that the type of all arguments
is the same.
|
Constructor and Description |
---|
AbstractAliasFragment(SQLFragment exp,
java.lang.String alias)
Creates a fragment with given expression and alias.
|
AmbiguousColumnException(SQLFragment fou,
java.lang.String name) |
ArithmeticOperation(ArithmeticOperation.ArithmeticOperator operator,
SQLFragment[] args) |
CaseStatement.WhenThen(SQLFragment condition,
SQLFragment result)
....
|
CaseStatement(CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
CASE WHEN condition THEN thenExpression ...
|
CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens)
CASE expression WHEN condition THEN thenExpression ...
|
CaseStatement(SQLFragment expression,
CaseStatement.WhenThen[] whenThens,
SQLFragment elseExpression)
CASE expression WHEN condition THEN thenExpression ...
|
Comparison(Comparison.Comparator comparator,
SQLFragment[] argsL)
Constructs a new comparison fragment for regexp_like, which has
function format.
|
Comparison(SQLFragment left,
Comparison.Comparator comparator)
Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS
and NOT EXISTS.
|
Comparison(SQLFragment left,
Comparison.Comparator comparator,
SQLFragment right)
Constructs a new comparison fragment with the given expressions and
comparator.
|
DataMiningFunction.DataMiningArguments(SQLFragment[] args)
Deprecated.
|
DataMiningFunction.DataMiningCostValues(SQLFragment[] args) |
DataMiningFunction(java.lang.String function,
SQLFragment model,
boolean cost,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs)
Deprecated.
|
DataMiningFunction(java.lang.String function,
SQLFragment model,
boolean cost,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs)
Deprecated.
|
DataMiningFunction(java.lang.String function,
SQLFragment model,
boolean cost,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs)
Deprecated.
|
DataMiningFunction(java.lang.String function,
SQLFragment model,
SQLFragment[] dmCostArgs,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs) |
DataMiningFunction(java.lang.String function,
SQLFragment model,
SQLFragment[] dmCostArgs,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs) |
DataMiningFunction(java.lang.String function,
SQLFragment model,
SQLFragment[] dmCostArgs,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs) |
DataMiningFunction(java.lang.String function,
SQLFragment model,
SQLFragment[] dmCostArgs,
SQLFragment[] dmSpecificArgs,
SQLFragment[] usingArgs) |
ExpressionList(SQLFragment... exps) |
FromObject(SQLFragment expression,
java.lang.String alias)
Create a FROM object with the given expression and alias.
|
Function(java.lang.String function,
SQLFragment[] arguments)
Creates a the given function with arguments.
|
Function(java.lang.String function,
SQLFragment[] arguments,
boolean grouping)
Creates a the given function with arguments, and boolean to mark whether
the function is a grouping function or not.
|
Function(java.lang.String function,
SQLFragment[] arguments,
java.lang.String separator)
Creates a the given function with arguments and separator.
|
Function(java.lang.String function,
SQLFragment[] arguments,
java.lang.String separator,
boolean grouping)
Creates a the given function with arguments, and boolean to mark whether
the function is a grouping function or not.
|
GroupByObject(SQLFragment[] exps) |
GroupByObject(SQLFragment[] exps,
WhereObject having) |
HierarchicalQueryObject(SQLFragment connectBy,
SQLFragment startWith,
boolean startWithFirst,
boolean noCycle) |
IndexObject(SQLFragment exp)
Constructs an Index object with the given expression and no ordering.
|
IndexObject(SQLFragment exp,
IndexObject.OrderType orderType)
Constructs an Index object with the given expression and ordering
constraint (either IndexObject.DESC or IndexObject.ASC).
|
IndexObject(SQLFragment exp,
java.lang.String ordering)
Deprecated.
|
OnJoinCondition(SQLFragment frag) |
Operation(SQLFragment[] args) |
OrderByObject(SQLFragment exp)
Constructs an ORDER BY object with the given expression and no ordering.
|
OrderByObject(SQLFragment exp,
java.lang.String ordering)
Constructs an ORDER BY object with the given expression and ordering
constraint (either OrderByObject.DESC or OrderByObject.ASC)
|
OrderByObject(SQLFragment exp,
java.lang.String ordering,
java.lang.String nullsOrder)
Constructs an ORDER BY object with the given expression, ordering and
null ordering.
|
SelectObject(SQLFragment expression,
java.lang.String alias)
Create a select object with the given expression and alias.
|
SelectObject(SQLFragment expression,
java.lang.String alias,
boolean useAs)
Create a select object with the given expression and alias.
|
SetOperation(SetOperation.Operator operator,
SQLFragment[] args) |
SetOperator(SetOperator.Operator operator,
SQLFragment[] args) |
SQLFragmentID(SQLFragment fragment,
DBObjectID parent)
Deprecated.
SQLFragments now use IndentifierBasedIDs. See bug 7173075.
|
SQLQueryClauseException(SQLFragment obj,
java.lang.String message) |
SQLQueryException(SQLFragment obj,
java.lang.String message) |
SQLQueryException(SQLFragment obj,
java.lang.String message,
java.lang.Exception cause) |
WhereObject(SQLFragment exp)
Where object with only one clause.
|
WhereObject(SQLFragment[] expressions,
WhereObject.WhereOperator logic)
Creates a WhereObject with the given expressions.
|