Uses of Class
oracle.odi.mapping.generation.SqlQuery

Packages that use SqlQuery

Package	Description
oracle.odi.mapping.generation
oracle.odi.mapping.generation.spark

Uses of SqlQuery in oracle.odi.mapping.generation

Subclasses of SqlQuery in oracle.odi.mapping.generation

Modifier and Type	Class and Description
class	CorrelatedQuery A class to model a correlated subquery.
class	FileSqlQuery A class to model a File SQL query in the ODI code generator.
class	NestedSqlQuery A class to represent a nested SQLquery, which acts as an inline view inside another SQL query
class	OracleSqlQuery Models an Oracle SQL query in the ODI code generator.
class	PivotQuery The PivotQuery class models an Oracle pivot query.
class	SetQuery SetQuery is the substitution API class used for set operation. It holds a collection of SqlQuery (the queries that will be union-ed), a collection of columns alias, a set operation type and a set alias.
class	WrappedCorrelatedQuery A wrappedCorrelatedQuery is a special correlated query that may be wrapped within a string expression.

Methods in oracle.odi.mapping.generation that return SqlQuery

Modifier and Type	Method and Description
SqlQuery	SetQuery.addAggregation(ArrayExpression pGroupBy, ArrayExpression pHaving, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addAggregation(ArrayExpression pGroupBy, ArrayExpression pHaving, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addFilter(ArrayExpression filterExp, java.util.Set existingAliasSet)
SqlQuery	SetQuery.addGroupBy(ArrayExpression pGroupBy, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addGroupBy(ArrayExpression pGroupBy, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet, boolean optimizeLeftInlineViews)
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet, boolean optimizeLeftInlineViews, boolean isCombinedQuery) Add a query to be joined to this query.
SqlQuery	SqlQuery.addSorter(ArrayExpression sorterExp)
SqlQuery	FileSqlQuery.clone()
SqlQuery	NestedSqlQuery.clone()
SqlQuery	PivotQuery.clone()
SqlQuery	SetQuery.clone() odiInternal
SqlQuery	SqlQuery.clone()
static SqlQuery	SqlQuery.createConstantQuery(TemplateUtils templateUtils, java.lang.String alias)
SqlQuery	SqlQuery.createInlineView()
SqlQuery	SqlQuery.createInlineView(boolean optimize)
SqlQuery	OracleSqlQuery.createQuery()
SqlQuery	SqlQuery.createQuery()
SqlQuery	SetQuery.getInputQuery(int index) Get the input query corresponding to the given index.
SqlQuery	SqlQuery.getInputQuery(int index) Get the input queries that are used in a set query (e.g.
SqlQuery	PigScript.getOutputSqlQuery()
SqlQuery	Script.getOutputSqlQuery()
SqlQuery	QueryClause.getParentQuery() Get the parent query.
SqlQuery	ArrayExpression.getQuery() Get the SqlQuery object that owns this ArrayExpression, if any, else return null.
SqlQuery	CorrelatedQuery.getQuery()
SqlQuery	ISelectItem.getQuery()
SqlQuery	SqlInsertStatement.getQuery() Get the source QUERY (SqlQuery) object for this insert statement.
SqlQuery	SqlMultiInsertStatement.getQuery() Gets the select query of this multi-insert statement.
SqlQuery	StringExpression.getQuery() Gets the SqlQuery object that owns this expression.
SqlQuery	TableQueryReference.getQuery()
SqlQuery	FilterSubQuery.getSelectQuery() Get the owning select query.
SqlQuery	SqlInsertStatement.getSelectQuery() Gets the select query of this insert statement.
SqlQuery	SqlMultiInsertStatement.getSelectQuery() Gets the select query of this multi-insert statement.
SqlQuery	SqlQuery.getSetOperand() Gets the query that is linked with this query through a set operation.
SqlQuery	ArrayExpression.getSqlQuery()
SqlQuery	ITableFunctionParameter.getSqlQuery()
SqlQuery	SqlQuery.getSqlQuery()
SqlQuery	FromClause.getSubquery() Get the subquery from the table query reference of this FromClause if any.
SqlQuery	SqlQuery.getTargetQuery(java.util.List tgtExpressions)
SqlQuery	SqlQuery.pushThisQueryToInlineView(java.util.Set existingAliasSet)
SqlQuery	SqlQuery.pushThisQueryToInlineView(java.util.Set existingAliasSet, java.util.HashMap selectMap)

Methods in oracle.odi.mapping.generation with parameters of type SqlQuery

Modifier and Type	Method and Description
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet)
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet, boolean optimizeLeftInlineViews)
SqlQuery	SqlQuery.addJoin(MapPhysicalNode physicalNode, JoinTable.JoinType joinType, SqlQuery joinQuery, ArrayExpression[] joinConditionHolder, boolean addJoinCondition, boolean orderedJoin, SqlQuery.SelectMapContainer selectMapContainer, IMapComponent leftComponent, IMapComponent rightComponent, MapConnectorPoint leftPoint, MapConnectorPoint rightPoint, boolean inDataset, java.util.Set existingAliasSet, boolean optimizeLeftInlineViews, boolean isCombinedQuery) Add a query to be joined to this query.
void	SqlQuery.copyAliasList(SqlQuery toQuery)
void	SqlQuery.copyCustomTemplate(SqlQuery toQuery)
void	FileSqlQuery.copyFields(SqlQuery pQuery)
void	PivotQuery.copyFields(SqlQuery toQuery)
void	SqlQuery.copyFrom(SqlQuery pFromQuery)
void	SqlQuery.copyFromList(SqlQuery toQuery)
void	SqlQuery.copyGroupByList(SqlQuery toQuery)
void	SqlQuery.copyHavingList(SqlQuery toQuery)
void	SqlQuery.copyNonOrderedComponentList(SqlQuery toQuery)
void	SqlQuery.copyOrderByList(SqlQuery toQuery)
void	OracleSqlQuery.copySelectHints(SqlQuery toQuery)
void	SqlQuery.copySelectHints(SqlQuery toQuery)
void	SqlQuery.copySelectList(SqlQuery toQuery, MapConnectorPoint fromPoint)
void	SqlQuery.copyWhereList(SqlQuery toQuery)
java.util.HashMap	SqlQuery.createSelectListFromInlineView(SqlQuery toQuery, java.lang.String alias, java.util.HashMap selectMap, MapConnectorPoint fromPoint)
java.util.HashMap	SqlQuery.createSelectListFromInlineView(SqlQuery toQuery, java.lang.String alias, java.util.HashMap selectMap, MapConnectorPoint fromPoint, boolean optimize)
java.lang.String	FromClause.getText(TemplateUtils templateUtils, SqlQuery selectQuery)
void	SqlMultiInsertStatement.init(java.util.List tableList, java.util.HashMap tableColumnMap, java.util.HashMap tableColumnExpMap, java.util.HashMap tableWhenClauseMap, SqlQuery query)
void	SqlInsertStatement.init(Table table, java.util.List columnList, SqlQuery query)
void	SqlUpdateStatement.init(Table table, java.util.List columnList, SqlQuery query, java.util.List topLevelSelectList, java.util.List sourceExpressionMatchList, java.util.List targetExpressionMatchList, StringExpression selectQueryAlias, StringExpression targetTableAlias)
void	SqlMergeStatement.init(Table table, SqlQuery query, java.util.List mergeConditionList, java.util.List mergeOnTargetColumnList, java.util.List mergeOnSourceExpressionList, java.util.List mergeColumnList, java.util.List insertColumnList, java.util.List insertSourceExpressionList, java.util.List updateColumnList, java.util.List updateSourceExpressionList, StringExpression targetTableAlias, StringExpression selectQueryAlias, java.util.Map tgtColOrder)
void	FilterSubQuery.setSelectQuery(SqlQuery query)
void	SqlInsertStatement.setSelectQuery(SqlQuery query)
void	SqlMultiInsertStatement.setSelectQuery(SqlQuery query)
void	SqlQuery.setSetOperand(SqlQuery query)

Constructors in oracle.odi.mapping.generation with parameters of type SqlQuery

Constructor and Description
AgentStreamingInsertStatement(MapPhysicalNode papNode, Table table, java.util.List columnList, SqlQuery query)
ArrayExpression(MapPhysicalColumn physCol, SqlQuery inputQuery)
ArrayExpression(MapPhysicalNode physNode, IMapExpression mapExpr, SqlQuery inputQuery)
ArrayExpression(MapPhysicalNode physNode, IMapExpression mapExpr, java.lang.String defaultTemplate, SqlQuery inputQuery)
ArrayExpression(MapPhysicalNode physNode, MapAttribute attr, MapPathSpecifier pathSpec, SqlQuery inputQuery)
ArrayExpression(MapPhysicalNode physNode, MapAttribute attr, MapPathSpecifier pathSpec, SqlQuery inputQuery, java.lang.String alias)
FileInsertStatement(Table table, java.util.ArrayList columnList, SqlQuery query)
FileUpdateStatement(Table table, java.util.ArrayList columnList, SqlQuery query)
FilterSubQuery(SqlQuery selectQuery)
FromClause(SqlQuery query, java.lang.String alias)
FromClause(SqlQuery query, java.lang.String alias, java.lang.String tableAliasSeparator)
OracleInsertStatement(Table table, java.util.List columnList, SqlQuery query)
OracleMergeStatement(Table table, SqlQuery query)
OracleUpdateStatement(Table table, java.util.ArrayList columnList, SqlQuery query)
SqlDeleteStatement(Table table, SqlQuery query)
SqlInsertStatement(Table table, java.util.List columnList, SqlQuery query)
SqlInsertStatement(Table table, SqlQuery query)
SqlMergeStatement(Table table, SqlQuery query)
SqlMultiInsertStatement(java.util.List tableList, java.util.HashMap tableColumnMap, java.util.HashMap tableColumnExpMap, java.util.HashMap tableWhenClauseMap, SqlQuery query)
SqlQuery(SqlQuery otherQuery)
SqlUpdateStatement(Table table, java.util.ArrayList columnList, SqlQuery query)
TableQueryReference(SqlQuery query, java.lang.String refAlias)
TableQueryReference(SqlQuery query, java.lang.String refAlias, java.lang.String tableAliasSeparator)

Uses of SqlQuery in oracle.odi.mapping.generation.spark

Methods in oracle.odi.mapping.generation.spark that return SqlQuery

Modifier and Type	Method and Description
SqlQuery	SparkScript.getOutputSqlQuery() Get the Output SqlQuery.
SqlQuery	SparkSQLCmd.getSQLStatement() Get the Sql Statement for this command.

Methods in oracle.odi.mapping.generation.spark with parameters of type SqlQuery

Modifier and Type	Method and Description
void	SparkSQLCmd.setSQLStatement(SqlQuery sql)

Constructors in oracle.odi.mapping.generation.spark with parameters of type SqlQuery

Constructor and Description
SparkHqlCmd(TemplateUtils templateUtils, MapPhysicalNode physicalNode, SqlQuery sqlToCall)
SparkSQLCmd(TemplateUtils templateUtils, MapPhysicalNode physicalNode, SqlQuery sqlToCall)