|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.0.0) E17493-01 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use SQLFragment | |
---|---|
oracle.ide.db.panels.sql | UI classes 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). |
Uses of SQLFragment in oracle.ide.db.panels.sql |
---|
Methods in oracle.ide.db.panels.sql that return SQLFragment | |
---|---|
SQLFragment |
ExpressionPanel.getCurrentExpression()
|
SQLFragment[] |
GroupByToPicker.getExpressions()
|
SQLFragment[] |
ExpressionPanel.getExpressions()
Returns the SQLFragments that have been created by the panel. |
SQLFragment |
GroupByPanel.newFragment()
|
SQLFragment |
SelectObjectsPanel.newFragment()
|
SQLFragment |
OrderByPanel.newFragment()
|
SQLFragment |
ExpressionPanel.FragmentProvider.newFragment()
Requests a new fragment from the provider. |
Methods in oracle.ide.db.panels.sql with parameters of type SQLFragment | |
---|---|
void |
ExpressionPanel.addTemplate(SQLFragment frag,
boolean includeChildren)
|
void |
GroupByPanel.edit(SQLFragment frag)
|
void |
SelectObjectsPanel.edit(SQLFragment frag)
|
void |
OrderByPanel.edit(SQLFragment frag)
|
void |
ExpressionPanel.FragmentProvider.edit(SQLFragment frag)
Edits the given fragment. |
SQLQuery |
SQLQueryEditDialog.editQuery(SQLQuery query,
SQLFragment defaultObject,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query. |
void |
ExpressionPanel.entered(SQLFragment[] exps,
SQLFragment defaultObject)
Sets up the panel with the given expressions and activates the list selection listener. |
void |
ExpressionPanel.entered(SQLFragment[] exps,
SQLFragment defaultObject)
Sets up the panel with the given expressions and activates the list selection listener. |
static java.lang.String[] |
SQLQueryEditDialog.getStartPage(SQLFragment child,
boolean incMaster)
Returns the appropriate start page path for editing the given child of a query. |
void |
WhereEditor.init(SQLFragment where,
SQLQueryBuilder builder,
boolean includePrior)
|
void |
GroupByPanel.moveFragment(SQLFragment frag,
int newIndex)
|
void |
SelectObjectsPanel.moveFragment(SQLFragment frag,
int newIndex)
|
void |
OrderByPanel.moveFragment(SQLFragment frag,
int newIndex)
|
void |
ExpressionPanel.FragmentProvider.moveFragment(SQLFragment frag,
int newIndex)
Moves the fragment within it's section of the query. |
boolean |
GroupByPanel.removeFragment(SQLFragment frag)
|
boolean |
SelectObjectsPanel.removeFragment(SQLFragment frag)
|
boolean |
OrderByPanel.removeFragment(SQLFragment frag)
|
boolean |
ExpressionPanel.FragmentProvider.removeFragment(SQLFragment frag)
Removes the given fragment from the query. |
void |
ExpressionPanel.setCurrentExpression(SQLFragment exp)
|
Uses of SQLFragment in oracle.ide.db.util |
---|
Methods in oracle.ide.db.util with parameters of type SQLFragment | |
---|---|
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 | |
---|---|
SQLFragment |
CheckConstraint.getCheckConditionFragment()
Retrieves the conditional expression represented by this constraint. |
Methods in oracle.javatools.db with parameters of type SQLFragment | |
---|---|
void |
CheckConstraint.setCheckConditionFragment(SQLFragment condition)
Sets the conditional expression represented by this constraint. |
Uses of SQLFragment in oracle.javatools.db.ora |
---|
Classes in oracle.javatools.db.ora that implement SQLFragment | |
---|---|
class |
OracleSQLQuery
Object that represents a complete SQL query. |
Uses of SQLFragment in oracle.javatools.db.sql |
---|
Subinterfaces of SQLFragment in oracle.javatools.db.sql | |
---|---|
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 |
DeclarativeSQLQuery
Extension of the SQLQuery interface that allows the query to edited. |
interface |
FromObjectUsage
Interface implemented by any object that directly depends on a FromObject (e.g. |
interface |
JoinCondition
|
interface |
SQLQuery
Object that represents a basic SQL query. |
Classes in oracle.javatools.db.sql that implement SQLFragment | |
---|---|
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
Abstract implementation of a 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
Dummy SQLQuery that just contains a String representing the 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 |
SynonymUsage
SQLFragment for using a Synonym 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
|
Fields in oracle.javatools.db.sql declared as SQLFragment | |
---|---|
protected static SQLFragment[] |
AbstractSQLQueryBuilder.EMPTY_ARRAY
|
protected static SQLFragment[] |
AbstractSQLFragment.EMPTY_ARRAY
|
Methods in oracle.javatools.db.sql that return SQLFragment | |
---|---|
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[] |
Comparison.getArguments()
|
SQLFragment[] |
DataMiningFunction.DataMiningCostValues.getArguments()
|
SQLFragment[] |
DataMiningFunction.DataMiningArguments.getArguments()
Deprecated. |
SQLFragment[] |
Operation.getArguments()
Returns the arguments stored in this function. |
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 |
IndexObject.getExpression()
Gets the expression for this Index object. |
SQLFragment |
AliasFragment.getExpression()
Returns the expression portion of this SQLFragment. |
SQLFragment |
AbstractAliasFragment.getExpression()
Returns the expression portion of this SQLFragment. |
SQLFragment |
OrderByObject.getExpression()
Gets the expression for this ORDER BY object. |
SQLFragment |
CaseStatement.getExpression()
|
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)
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. |
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 | |
---|---|
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,
SQLFragment exp,
boolean allowDuplicates,
FromObject from,
SQLFragment creating)
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromObjects(java.lang.String colName,
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,
SQLFragment creating,
FromObject... extraFroms)
Finds a Column of given name amongst the RelationUsages in the query. |
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInJoin(java.lang.String colName,
JoinObject join,
boolean allowDuplicates,
SQLFragment creating)
|
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 |
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 |
PlSqlUsage.setArguments(SQLFragment[] arguments)
|
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 |
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 |
IndexObject.setExpression(SQLFragment exp)
Sets the expression for this Index object. |
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 |
OrderByObject.setExpression(SQLFragment exp)
Sets the expression for this ORDER BY object. |
void |
CaseStatement.setExpression(SQLFragment expression)
|
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)
|
Method parameters in oracle.javatools.db.sql with type arguments of type SQLFragment | |
---|---|
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 | |
---|---|
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(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,
java.lang.String ordering)
Constructs an Index object with the given expression and ordering constraint (either IndexObject.DESC or IndexObject.ASC) |
|
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. |
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.0.0) E17493-01 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |