| 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  | 
| 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  | 
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  | 
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[] | 
PlSqlUsage.getArguments()  | 
SQLFragment[] | 
Operation.getArguments()
Returns the arguments stored in this function. 
 | 
SQLFragment[] | 
DataMiningFunction.DataMiningCostValues.getArguments()  | 
SQLFragment[] | 
DataMiningFunction.DataMiningArguments.getArguments()
Deprecated.  
  | 
SQLFragment[] | 
Comparison.getArguments()  | 
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 | 
IndexObject.getExpression()
Gets the expression for this Index object which is derived from the expression source. 
 | 
SQLFragment | 
CaseStatement.getExpression()  | 
SQLFragment | 
AliasFragment.getExpression()
Returns the expression portion of this SQLFragment. 
 | 
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)  | 
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 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)
Lists the columns available from the given SQLFragment. 
 | 
static java.util.Collection<ColumnUsage> | 
SQLFragmentUtils.listColumnUsages(SQLFragment expression)
Lists the columns available from the given SQLFragment. 
 | 
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 | 
PlSqlUsage.setArguments(SQLFragment[] arguments)  | 
void | 
Operation.setArguments(SQLFragment[] arguments)
Sets the arguments for this function. 
 | 
void | 
DataMiningFunction.DataMiningCostValues.setArguments(SQLFragment[] args)  | 
void | 
DataMiningFunction.DataMiningArguments.setArguments(SQLFragment[] args)
Deprecated.  
  | 
void | 
Comparison.setArguments(SQLFragment[] arguments)  | 
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 | 
IndexObject.setExpression(SQLFragment exp)
Sets the expression for this Index object which should be derived from the expression source. 
 | 
void | 
FromObject.setExpression(SQLFragment exp)  | 
void | 
CaseStatement.setExpression(SQLFragment expression)  | 
void | 
AliasFragment.setExpression(SQLFragment exp)
Sets the expression portion of this SQLFragment. 
 | 
void | 
AbstractAliasFragment.setExpression(SQLFragment expression)
Sets the expression part of the fragment. 
 | 
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(int 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(int comparator, SQLFragment[] argsL)
Constructs a new comparison fragment for regexp_like, which has function format. 
 | 
Comparison(SQLFragment left, int comparator)
Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS and NOT EXISTS. 
 | 
Comparison(SQLFragment left, int 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(int operator, SQLFragment[] args)  | 
SetOperator(int 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, int logic)
Creates a WhereObject with the given expressions. 
 |