oracle.odi.mapping.generation

Class FilterSubQuery

java.lang.Object

oracle.odi.mapping.generation.AbstractSyntaxTree

oracle.odi.mapping.generation.QueryClause

oracle.odi.mapping.generation.FilterSubQuery

All Implemented Interfaces:

IConditionItem

public class FilterSubQuery
extends QueryClause
implements IConditionItem

FilterSubQuery is a part of whereList of the outer query. It generates IN/NOT IN/EXISTS/NOT EXISTS clause in where clause of the outer query. It uses columns from the outer query in it's where clause or it's In clause. Examples: 1. SELECT ENAME from EMP where (EMP.DEPTNO) in (select DEPTNO from DEPT) In this case, the filterSubquery is responsible to generate the code: (EMP.DEPTNO) in (select DEPTNO from DEPT) 2. SELECT ENAME from EMP where exists (select 1 from DEPT where EMP.DEPTNO = DEPT.DEPTNO) In this case, the FilterSubQuery is responsible to generate the code: exists (select 1 from DEPT where EMP.DEPTNO = DEPT.DEPTNO) *

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	FilterSubQuery.GroupComparisonKeyword An enum to represent a method of comparing groups.
static class	FilterSubQuery.QueryRole

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

AbstractSyntaxTree.LogCounter

Method Summary

Modifier and Type	Method and Description
java.util.List	getChildren() Get the children.
java.util.List	getExpressions() Get the expressions.
FilterSubQuery.GroupComparisonKeyword	getGroupComparisonKeyword() Get the group comparison keyword.
java.lang.String	getGroupComparisonKeywordText() Get the text representation of the group comparison keyword.
FilterSubQuery.QueryRole	getQueryRole() Get the query role.
java.lang.String	getQueryRoleText() Get the text representation of the query role.
java.util.List	getRefObjectExpressionList() Get the columns in FilterSubQuery's whereList which are from the outer query.
SqlQuery	getSelectQuery() Get the owning select query.
java.util.List	getSubqueryInExpressionList() Get the subquery in expression list.
java.util.Map	getTemplateSubstitutionMap() Get the template substitution map.
java.lang.String	getType() Get the class type of this Object.
java.lang.String	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, getSourceLocation, getSourceTechnology, getSourceText, getTargetLanguage, getTargetLocation, getTargetTechnology, getTargetText, getText, hasCustomTemplate, hasSourceAndTargetText, isLeafLevelNode, isPushFromSource

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

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

getParentAST, getText

Method Detail

getRefObjectExpressionList

public java.util.List getRefObjectExpressionList()

Get the columns in FilterSubQuery's whereList which are from the outer query.

getSubqueryInExpressionList

public java.util.List getSubqueryInExpressionList()

Get the subquery in expression list.

getQueryRole

public FilterSubQuery.QueryRole getQueryRole()

Get the query role.

getQueryRoleText

public java.lang.String getQueryRoleText()

Get the text representation of the query role.

getGroupComparisonKeywordText

public java.lang.String getGroupComparisonKeywordText()

Get the text representation of the group comparison keyword.

getGroupComparisonKeyword

public FilterSubQuery.GroupComparisonKeyword getGroupComparisonKeyword()

Get the group comparison keyword.

getExpressions

public java.util.List getExpressions()

Get the expressions.

Specified by:

getExpressions in class QueryClause

Returns:

The list of expressions.

getChildren

public java.util.List getChildren()

Get the children.

Specified by:

getChildren in interface IConditionItem

Specified by:

getChildren in class AbstractSyntaxTree

Returns:

The list of child objects.

getType

public java.lang.String getType()

Get the class type of this Object.

Specified by:

getType in class AbstractSyntaxTree

Returns:

A simple class type name for this object.

getSelectQuery

public SqlQuery getSelectQuery()

Get the owning select query.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getTemplateSubstitutionMap

public java.util.Map getTemplateSubstitutionMap()

Get the template substitution map.

Specified by:

getTemplateSubstitutionMap in class AbstractSyntaxTree

Returns:

The built-in template substitution hash map.