Uses of Interface
oracle.javatools.db.sql.SQLFragment

Packages that use SQLFragment

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.hive
oracle.javatools.db.ora	Contains the database api implementation for Oracle databases, and additional DBObject implementations for objects specific to Oracle.
oracle.javatools.db.ora.bigdata
oracle.javatools.db.sql	Contains an API for declaratively parsing SQL queries (SELECT statements).

Uses of SQLFragment in oracle.ide.db.panels.sql

Methods in oracle.ide.db.panels.sql with parameters of type SQLFragment

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.

Uses of SQLFragment in oracle.ide.db.util

Methods in oracle.ide.db.util with parameters of type SQLFragment

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.

Uses of SQLFragment in oracle.javatools.db

Methods in oracle.javatools.db that return SQLFragment

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.

Methods in oracle.javatools.db with parameters of type SQLFragment

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.

Uses of SQLFragment in oracle.javatools.db.hive

Classes in oracle.javatools.db.hive that implement SQLFragment

Modifier and Type	Class and Description
class	TblProperty Simple DBObject implementation for a key/value pair in a property map (like TBLPROPERTIES or SERDEPROPERTIES).

Uses of SQLFragment in oracle.javatools.db.ora

Classes in oracle.javatools.db.ora that implement SQLFragment

Modifier and Type	Class and Description
class	OracleSQLQuery Deprecated. - folded in to SQLQuery

Methods in oracle.javatools.db.ora that return SQLFragment

Modifier and Type	Method and Description
SQLFragment	OracleExternalTableProperties.getAccessParametersFragment() Gets the driver's access parameters derived as a SQLFragment.

Methods in oracle.javatools.db.ora with parameters of type SQLFragment

Modifier and Type	Method and Description
void	OracleExternalTableProperties.setAccessParametersFragment(SQLFragment frag) Sets the driver's access parameters derived as a SQLFragment.

Uses of SQLFragment in oracle.javatools.db.ora.bigdata

Classes in oracle.javatools.db.ora.bigdata that implement SQLFragment

Modifier and Type	Class and Description
class	BigDataAccessParameter SQLFragment that represents an access parameter for an Oracle "Big Data" access driver.
class	BigDataAccessParameters SQLFragment that represents the access parameters for the Oracle "Big Data" external table access drivers.
class	BigDataField Representation of a Big Data field object.
class	BigDataFields Object that represents the value of the com.oracle.bigdata.fields access parameter.
class	BigDataJsonArray Array construct for use in big data access parameter values.
class	BigDataJsonEntry Entry (or element) construct for use in big data access parameter values.
class	BigDataJsonObject Object construct for use in big data access parameter values.
class	BigDataTableProperties Object that represents the value of the com.oracle.bigdata.tblproperties access parameter.
class	BigDataTableProperty Representation of a big data "table property", which is a name/value property pair.

Methods in oracle.javatools.db.ora.bigdata that return SQLFragment

Modifier and Type	Method and Description
SQLFragment[]	BigDataJsonArray.getArguments() Gets the arguments to this array (i.e.
SQLFragment	BigDataAccessParameter.getParameterValueFragment() Gets the derived fragment representation of the parameterValue property.
SQLFragment	BigDataJsonEntry.getValueFragment() Gets the fragment that respresents the value for this entry.

Methods in oracle.javatools.db.ora.bigdata with parameters of type SQLFragment

Modifier and Type	Method and Description
void	BigDataJsonArray.addArgument(SQLFragment arg) Adds an element fragment to the list of arguments.
void	BigDataJsonArray.setArguments(SQLFragment[] args) Sets the arguments to this array (i.e.
void	BigDataAccessParameter.setParameterValueFragment(SQLFragment frag) Sets the derived fragment representation of the parameterValue property.
void	BigDataJsonEntry.setValueFragment(SQLFragment value) Sets the fragment that respresents the value for this entry.

Constructors in oracle.javatools.db.ora.bigdata with parameters of type SQLFragment

Constructor and Description
BigDataJsonEntry(java.lang.String name, SQLFragment valueFragment) Creates a BigDataJsonEntry with the given name and value.

Uses of SQLFragment in oracle.javatools.db.sql

Subinterfaces of SQLFragment in oracle.javatools.db.sql

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.

Classes in oracle.javatools.db.sql that implement SQLFragment

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	ConnectByRoot SQLFragment representing the unary operator CONNECT_BY_ROOT.
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 a column expression (usually just a name, but could be any sql expression) with an optional order type (ASC/DESC).
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	WithClauseUsage FromObjectUsage which represents the usage of a WITH clause in the FROM clause.
class	XMLFunctionUsage Use spaces as argument seperators.

Fields in oracle.javatools.db.sql declared as SQLFragment

Modifier and Type	Field and Description
protected static SQLFragment[]	AbstractSQLFragment.EMPTY_ARRAY
protected static SQLFragment[]	AbstractSQLQueryBuilder.EMPTY_ARRAY

Methods in oracle.javatools.db.sql that return SQLFragment

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[]	Comparison.getArguments()
SQLFragment[]	DataMiningFunction.DataMiningCostValues.getArguments()
SQLFragment[]	DataMiningFunction.DataMiningArguments.getArguments() Deprecated.
SQLFragment[]	Function.getArguments()
SQLFragment[]	Operation.getArguments() Returns the arguments stored in this function.
SQLFragment[]	PlSqlUsage.getArguments()
SQLFragment[]	WindowFunction.WindowFunctionBound.getBoundExpr()
SQLFragment[]	WindowFunction.getBounds()
SQLFragment[]	ModelObject.CellAssignment.getCellAssignment()
SQLFragment	ModelObject.ReferenceModel.getCellReferenceOptions()
SQLFragment	HierarchicalQueryObject.getConnectBy()
SQLFragment[]	AbstractSQLQueryBuilder.getDependentObjects(FromObject from) Gets the objects in the query that are dependent on the given from object.
SQLFragment[]	SQLQueryBuilder.getDependentObjects(FromObject from) Returns all objects that are dependent on the given FromObject.
SQLFragment[]	AbstractSQLQueryBuilder.getDependentObjects(SelectObject select) Gets the objects in the query that are dependent on the given select object.
SQLFragment[]	SQLQueryBuilder.getDependentObjects(SelectObject select) Returns all objects that are dependent on the given SelectObject.
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	AbstractAliasFragment.getExpression() Returns the expression portion of this SQLFragment.
SQLFragment	AliasFragment.getExpression() Returns the expression portion of this SQLFragment.
SQLFragment	CaseStatement.getExpression()
SQLFragment	IndexObject.getExpression() Gets the expression for this Index object which is derived from the expression source.
SQLFragment	OrderByObject.getExpression() Gets the expression for this ORDER BY object.
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	AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression)
SQLFragment	SQLQueryBuilder.parseFromExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a From object.
protected SQLFragment	AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression, FromObject creating)
SQLFragment	AbstractSQLQueryBuilder.parseHavingExpression(java.lang.String expression) By default this calls parseWhereExpression().
SQLFragment	SQLQueryBuilder.parseHavingExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Having object.
SQLFragment	AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression)
SQLFragment	SQLQueryBuilder.parseOrderByExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Order By object.
protected SQLFragment	AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression, OrderByObject obo)
SQLFragment	AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression)
SQLFragment	SQLQueryBuilder.parseSelectExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Select object.
protected SQLFragment	AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression, SelectObject creating)
SQLFragment	AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression)
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, WhereObject creating)

Methods in oracle.javatools.db.sql with parameters of type SQLFragment

Modifier and Type	Method and Description
void	Comparison.addArgument(int index, SQLFragment expression)
void	Operation.addArgument(int index, SQLFragment expression)
void	Comparison.addArgument(SQLFragment expression)
void	Operation.addArgument(SQLFragment expression)
void	Comparison.addArguments(SQLFragment[] expressions)
void	Operation.addArguments(SQLFragment[] expressions)
void	GroupByObject.addExpression(int index, SQLFragment s)
void	GroupByObject.addExpression(SQLFragment s)
void	AbstractSQLQueryBuilder.addGroupByColumn(int index, SQLFragment colu)
void	SQLQueryBuilder.addGroupByColumn(int index, SQLFragment colu) Adds the given FromObjectUsage to the specified index of the GROUP BY clause.
void	AbstractSQLQueryBuilder.addGroupByColumn(SQLFragment colu)
void	SQLQueryBuilder.addGroupByColumn(SQLFragment colu) Adds the given FromObjectUsage to the end of the GROUP BY clause.
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	Comparison.removeArgument(SQLFragment expression)
boolean	Operation.removeArgument(SQLFragment expression)
boolean	GroupByObject.removeExpression(SQLFragment s)
boolean	AbstractSQLQueryBuilder.removeGroupByColumn(SQLFragment colu)
boolean	SQLQueryBuilder.removeGroupByColumn(SQLFragment colu) Removes the given FromObjectUsage from the GROUP BY clause.
protected boolean	AbstractSQLQueryBuilder.removeWhereObject(SQLFragment obj) Removes a top level WhereObject from the WHERE clause.
void	Comparison.setArguments(SQLFragment[] arguments)
void	DataMiningFunction.DataMiningCostValues.setArguments(SQLFragment[] args)
void	DataMiningFunction.DataMiningArguments.setArguments(SQLFragment[] args) Deprecated.
void	Operation.setArguments(SQLFragment[] arguments) Sets the arguments for this function.
void	PlSqlUsage.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	AbstractAliasFragment.setExpression(SQLFragment expression) Sets the expression part of the fragment.
void	AliasFragment.setExpression(SQLFragment exp) Sets the expression portion of this SQLFragment.
void	CaseStatement.setExpression(SQLFragment expression)
void	FromObject.setExpression(SQLFragment exp)
void	IndexObject.setExpression(SQLFragment exp) Sets the expression for this Index object which should be derived from the expression source.
void	OrderByObject.setExpression(SQLFragment exp) Sets the expression for this ORDER BY object.
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)

Method parameters in oracle.javatools.db.sql with type arguments of type SQLFragment

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.

Constructors in oracle.javatools.db.sql with parameters of type SQLFragment

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(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.
ConnectByRoot(SQLFragment operand)
DataMiningArguments(SQLFragment[] args) Deprecated.
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. - Use IndexObject.IndexObject(SQLFragment,OrderType)
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)
WhenThen(SQLFragment condition, SQLFragment result) ....
WhereObject(SQLFragment exp) Where object with only one clause.
WhereObject(SQLFragment[] expressions, WhereObject.WhereOperator logic) Creates a WhereObject with the given expressions.