| 
 | Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.4.0) E17493-05 | |||||||||
| 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 | OracleSQLQueryObject that represents a complete SQL query. | 
| Uses of SQLFragment in oracle.javatools.db.sql | 
|---|
| Subinterfaces of SQLFragment in oracle.javatools.db.sql | |
|---|---|
|  interface | AliasFragmentSQLFragment that consists of an expression and an alias. | 
|  interface | DBObjectUsageInterface implemented by fragments that use a DBObjectID to refer to another DBObject. | 
|  interface | DeclarativeSQLQueryExtension of the SQLQuery interface that allows the query to edited. | 
|  interface | FromObjectUsageInterface implemented by any object that directly depends on a FromObject (e.g. | 
|  interface | JoinCondition | 
|  interface | SQLQueryObject that represents a basic SQL query. | 
| Classes in oracle.javatools.db.sql that implement SQLFragment | |
|---|---|
|  class | AbstractAliasFragmentSQLFragment that consists of an expression and an alias. | 
|  class | AbstractDBObjectUsageAbstract implementation for a SQLFragment that uses another DBObject (e.g a Column) through a FromObject in the query. | 
|  class | AbstractFromObjectUsageAbstract SQLFragment implementation of FromObjectUsage. | 
|  class | AbstractSchemaObjectUsageAbstract class for usages that reference a SchemaObject (e.g. | 
|  class | AbstractSQLFragmentAbstract superclass for SQLFragment implementations. | 
|  class | AbstractSQLQueryAbstract implementation of a SQLQuery. | 
|  class | ArithmeticOperationConcrete subclass of Operation for arithmetic operations - ADD, SUBTRACT, MULTIPLY and DIVIDE. | 
|  class | AsteriskUsageDeprecated. - use ColumnKeywordUsage | 
|  class | CaseStatementClass to represent a case statement in a sql query. CASE [expression] WHEN condition THEN thenExpression WHEN condition THEN thenExpression ... | 
| static class | CaseStatement.WhenThen | 
|  class | ColumnKeywordUsageA FromObjectUsage that has a keyword for the Column name, rather than an actual column. | 
|  class | ColumnUsageSQL fragment that is a use of a Column. | 
|  class | ComparisonSubclass of Operation for comparisons. | 
|  class | DataMiningFunctionSubclass of Operation for data mining functions. | 
| static class | DataMiningFunction.DataMiningArgumentsDeprecated. no longer required, use get/setDmSpecificArgs directly. | 
| static class | DataMiningFunction.DataMiningCostValuesAn array of values | 
|  class | ExpressionListList of expressions. | 
|  class | FKUsageSQLFragment for the usage of a FKConstraint. | 
|  class | FromObjectObject that represents a clause in the FROM statement of a SQL query. | 
|  class | FunctionSubclass of Operation for functions. | 
|  class | FunctionUsage | 
|  class | GroupByExpressionExpression for a part of a group by that isn't a simple column (e.g. | 
|  class | GroupByObjectSQLFragment for the GROUP BY ... | 
|  class | HierarchicalQueryObjectSQLFragment for the Hierarchical Query clause in a SQLQuery. | 
|  class | IndexObjectObject to wrap each column eaxpression of the Index statement | 
|  class | JoinObjectObject that represent the JOIN clause of a SELECT statement (part of the FROM clause). | 
|  class | ModelObjectSQLFragment 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 | NonDeclarativeSQLQueryDummy SQLQuery that just contains a String representing the SQLQuery. | 
|  class | OnJoinConditionObject to represent the ON condition of a JOIN clause. | 
|  class | OperationAbstract class for operations. | 
|  class | OrderByObjectObject to wrap each part of the ORDER BY clause of a SQLQuery. | 
|  class | PlSqlUsageFragment that represents a usage of a piece of PlSql. | 
|  class | RelationUsageSQL fragment that is a use of a Relation. | 
|  class | SelectObjectObject that represents a clause in the SELECT statement of a SQL query. | 
|  class | SelectObjectUsageClass that represents the usage of a SelectObject. | 
|  class | SetOperationSQLFragment for dealing with operations to do with sets and ranges like IN and BETWEEN. | 
|  class | SetOperatorSQLFragment for dealing with queries that are linked using one of the SET operators INTERSECT, UNION, MINUS and UNION ALL. | 
|  class | SimpleSQLFragmentSQLFragment that we can't break down any more. | 
|  class | SynonymUsageSQLFragment for using a Synonym in a SQL query. | 
|  class | UsingJoinConditionObject to represent the condition part of a JOIN that has a USING clause. | 
|  class | WhereObjectObject that represents a clause in the WHERE statement of a SQL query. | 
|  class | WindowFunctionSubclass 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.4.0) E17493-05 | |||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||