Oracle Fusion Middleware Java API Reference for Oracle Extension SDK
11g Release 2 (11.1.2.0.0)

E17493-01

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

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

Copyright © 1997, 2011, Oracle. All rights reserved.