oracle.odi.mapping.generation

Interface ISelectItem

All Known Implementing Classes:

ArrayExpression, CorrelatedQuery, Expression, StringConstant, StringExpression, WrappedCorrelatedQuery

public interface ISelectItem

A class to represent a select item in a SQL query, or some column-level metadata in a script.

Method Summary

Modifier and Type	Method and Description
ArrayExpression	getArrayExpression() Convenience method to cast this object to an ArrayExpression, if it is an instance of ArrayExpression.
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()
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()
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(TemplateUtils templateUtils)
boolean	hasCorrelatedSubquery()
boolean	hasWindowFunction(oracle.odi.domain.adapter.topology.ITechnology techno) Indicates whether this expression references a window function.
boolean	isAggregation(oracle.odi.domain.adapter.topology.ITechnology techno) Indicates whether this expression references an aggregation function.

Method Detail

getText

java.lang.String getText(TemplateUtils templateUtils)
                  throws GenerationException

Throws:

GenerationException

getRefObject

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

getRefPath

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

Get the referencing graph path associated with this select item.

isAggregation

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

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

Parameters:

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

Returns:

true if an aggregation function is referenced, otherwise false.

hasWindowFunction

boolean hasWindowFunction(oracle.odi.domain.adapter.topology.ITechnology techno)

Indicates whether this expression references a window function. It checks all function calls against the list of aggregation functions for the given technology. If an aggregation is found, an additional check is made to determine if the "over" clause is present, indicating a window function.

Parameters:

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

Returns:

true if a window function is referenced, otherwise false.

getMaxColumnLength

int getMaxColumnLength()

hasCorrelatedSubquery

boolean hasCorrelatedSubquery()

getTargetColumnName

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.

getRefAttributeWithPath

MapAttributeWithPath getRefAttributeWithPath()

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

getQuery

SqlQuery getQuery()

getMappingObject

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

Returns:

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

getSourceAttributes

java.util.List getSourceAttributes()

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

getMapAttribute

oracle.odi.domain.mapping.MapAttribute getMapAttribute()
                                                throws oracle.odi.domain.adapter.AdapterException,
                                                       oracle.odi.domain.mapping.exception.MappingException

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

Returns:

The associated map attribute.

Throws:

oracle.odi.domain.adapter.AdapterException

oracle.odi.domain.mapping.exception.MappingException

getSourceExpressions

java.util.List getSourceExpressions()

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

getArrayExpression

ArrayExpression getArrayExpression()

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

Returns:

The ArrayExpression if this is an ArrayExpression, else null.

getCorrelatedQuery

CorrelatedQuery getCorrelatedQuery()

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

Returns:

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

getStringExpression

StringExpression getStringExpression()

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

Returns:

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