oracle.odi.mapping.generation

Class CorrelatedQuery

java.lang.Object

oracle.odi.mapping.generation.AbstractSyntaxTree

oracle.odi.mapping.generation.QueryClause

oracle.odi.mapping.generation.SqlQuery

oracle.odi.mapping.generation.CorrelatedQuery

All Implemented Interfaces:

ISelectItem, ITableFunctionParameter, SqlStatement

Direct Known Subclasses:

WrappedCorrelatedQuery

public class CorrelatedQuery
extends SqlQuery
implements ISelectItem

A class to model a correlated subquery. A correlated subquery is a subquery that uses values from the outer query in its WHERE clause. A correlated subquery only has one column in its select list.

Nested Class Summary

Nested classes/interfaces inherited from class oracle.odi.mapping.generation.AbstractSyntaxTree

AbstractSyntaxTree.LogCounter

Method Summary

Modifier and Type	Method and Description
boolean	equals(java.lang.Object obj)
CorrelatedQuery	getCorrelatedQuery() Convenience method to cast this object to a CorrelatedQuery object, if it is an instance of CorrelatedQuery.
oracle.odi.domain.mapping.MapAttribute	getMapAttribute() Get the map attribute that is associated with this select item, if any, else null.
oracle.odi.domain.root.IMappingObject	getMappingObject()
int	getMaxColumnLength() Get the max length of a column name.
SqlQuery	getQuery()
MapAttributeWithPath	getRefAttributeWithPath() If the referenced object is an attribute, return the attribute with path object, else null.
oracle.odi.domain.mapping.xreference.IExpressionReferencedObject	getRefObject() Get the referenced object.
oracle.odi.domain.mapping.MapPathSpecifier	getRefPath() Get the referencing graph path associated with this select item.
java.util.List	getSourceAttributes() Get a list of attributes that act as sources for this expression.
java.util.List	getSourceExpressions() Get a list of expression objects that act as a source for this expression.
StringExpression	getStringExpression() Convenience method to cast this object to a StringExpression object, if it is an instance of StringExpression.
java.lang.String	getTargetColumnName() Get a target column name that corresponds to this query select item, for the case where the query is owned by a DML statement object.
java.lang.String	getText() Get the expanded text of this query object which represents a SELECT statement.
boolean	hasCorrelatedSubquery()
int	hashCode()
boolean	isAggregation(oracle.odi.domain.adapter.topology.ITechnology techno) Indicates whether this expression references an aggregation function.

Methods inherited from class oracle.odi.mapping.generation.SqlQuery

addJoin, getAliasList, getChildren, getColumnAliasSeparator, getConstantFromClauseText, getConstantFromClauseText, getExpressionColumn, getExpressions, getFromList, getGroupByList, getHavingList, getInputQuery, getInputQueryCount, getJournalizedSource, getLateralViewList, getNonOrderedComponents, getOrderByList, getQuerySourceComponent, getSelectHints, getSelectList, getSetOperand, getSetOperation, getSourceColumns, getSourceLocation, getSourceTable, getSourceTables, getSourceTables, getSubqueries, getTemplateSubstitutionMap, getType, getWhereList, hasAggregation, hasFilterWithAggregation, hasJournalizedSource, hasNonOrderedJoin, hasSourceReference, hasWindowFunction, hasWindowFunction, isANSI, isConstantQuery, isDistinct, isPassive, isPivot, isStagingQuery, isSubquery, toString

Methods inherited from class oracle.odi.mapping.generation.QueryClause

getParentQuery

Methods inherited from class oracle.odi.mapping.generation.AbstractSyntaxTree

getCodeGenerationTemplate, getCodeGenerationTemplateName, getCustomTemplate, getKMName, getLeafLevelChildren, getMapPhysicalNode, getOrder, getParentAST, getParentOfType, getPropertyValue, getSourceLanguage, getSourceTechnology, getSourceText, getTargetLanguage, getTargetLocation, getTargetTechnology, getTargetText, hasCustomTemplate, hasSourceAndTargetText, isLeafLevelNode, isPushFromSource

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.odi.mapping.generation.ISelectItem

getText, hasWindowFunction

Methods inherited from interface oracle.odi.mapping.generation.ITableFunctionParameter

getParentAST

Method Detail

hashCode

public int hashCode()

Overrides:

hashCode in class java.lang.Object

equals

public boolean equals(java.lang.Object obj)

Overrides:

equals in class java.lang.Object

getRefObject

public oracle.odi.domain.mapping.xreference.IExpressionReferencedObject getRefObject()

Get the referenced object.

Specified by:

getRefObject in interface ISelectItem

getRefAttributeWithPath

public MapAttributeWithPath getRefAttributeWithPath()

If the referenced object is an attribute, return the attribute with path object, else null.

Specified by:

getRefAttributeWithPath in interface ISelectItem

getMaxColumnLength

public int getMaxColumnLength()

Get the max length of a column name.

Specified by:

getMaxColumnLength in interface ISelectItem

getText

public java.lang.String getText()
                         throws GenerationException

Get the expanded text of this query object which represents a SELECT statement.

Specified by:

getText in interface ITableFunctionParameter

Overrides:

getText in class SqlQuery

Returns:

The select statement.

Throws:

GenerationException

isAggregation

public boolean isAggregation(oracle.odi.domain.adapter.topology.ITechnology techno)

Description copied from interface: ISelectItem

Indicates whether this expression references an aggregation function. It checks all function calls against the list of aggregation functions for the given technology.

Specified by:

isAggregation in interface ISelectItem

Parameters:

techno - technology to use for finding the list of aggregation functions

Returns:

true if an aggregation function is referenced, otherwise false.

hasCorrelatedSubquery

public boolean hasCorrelatedSubquery()

Specified by:

hasCorrelatedSubquery in interface ISelectItem

getTargetColumnName

public java.lang.String getTargetColumnName()

Get a target column name that corresponds to this query select item, for the case where the query is owned by a DML statement object.

Specified by:

getTargetColumnName in interface ISelectItem

getRefPath

public oracle.odi.domain.mapping.MapPathSpecifier getRefPath()

Get the referencing graph path associated with this select item.

Specified by:

getRefPath in interface ISelectItem

getQuery

public SqlQuery getQuery()

Specified by:

getQuery in interface ISelectItem

getMappingObject

public oracle.odi.domain.root.IMappingObject getMappingObject()

Specified by:

getMappingObject in interface ISelectItem

Returns:

The mapping object that was used to create this expression. It will be either a MapExpression, MapPhysicalExpression, or MapAttribute object.

getSourceAttributes

public java.util.List getSourceAttributes()

Get a list of attributes that act as sources for this expression.

Specified by:

getSourceAttributes in interface ISelectItem

getSourceExpressions

public java.util.List getSourceExpressions()

Get a list of expression objects that act as a source for this expression.

Specified by:

getSourceExpressions in interface ISelectItem

getMapAttribute

public oracle.odi.domain.mapping.MapAttribute getMapAttribute()

Get the map attribute that is associated with this select item, if any, else null.

Specified by:

getMapAttribute in interface ISelectItem

Returns:

The associated map attribute.

getCorrelatedQuery

public CorrelatedQuery getCorrelatedQuery()

Description copied from interface: ISelectItem

Convenience method to cast this object to a CorrelatedQuery object, if it is an instance of CorrelatedQuery.

Specified by:

getCorrelatedQuery in interface ISelectItem

Returns:

The CorrelatedQuery object if this is a CorrelatedQuery, else null.

getStringExpression

public StringExpression getStringExpression()

Description copied from interface: ISelectItem

Convenience method to cast this object to a StringExpression object, if it is an instance of StringExpression.

Specified by:

getStringExpression in interface ISelectItem

Returns:

The StringExpression object if this is a StringExpression, else null.