oracle.odi.mapping.generation

Class OracleSqlQuery

java.lang.Object

oracle.odi.mapping.generation.AbstractSyntaxTree

oracle.odi.mapping.generation.QueryClause

oracle.odi.mapping.generation.SqlQuery

oracle.odi.mapping.generation.OracleSqlQuery

All Implemented Interfaces:

ITableFunctionParameter, SqlStatement

public class OracleSqlQuery
extends SqlQuery

Models an Oracle SQL query in the ODI code generator. During code generation, each mapping component receives at least one SqlQuery as input.

Since:

12.1.2.0.0

Nested Class Summary

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

AbstractSyntaxTree.LogCounter

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SELECT_HINT_OPTION_KEY

Method Summary

Modifier and Type	Method and Description
java.util.List	getSelectHints() Get list of expressions for select hints.
java.lang.String	getTargetDblinlName() Gets the database link name of the target where this query will load into.
java.lang.String	hasSelectHints() Return "true" if any select hint is used, otherwise return false.
boolean	isRunOnSource() Get the flag indicating if this query should be run on source database server.

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, getSelectList, getSetOperand, getSetOperation, getSourceColumns, getSourceLocation, getSourceTable, getSourceTables, getSourceTables, getSubqueries, getTemplateSubstitutionMap, getText, getType, getWhereList, hasAggregation, hasFilterWithAggregation, hasJournalizedSource, hasNonOrderedJoin, hasSourceReference, hasWindowFunction, hasWindowFunction, isANSI, isConstantQuery, isDistinct, isPassive, isPivot, isScalarTableFunctionWithAggregate, 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

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

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

getParentAST

Field Detail

SELECT_HINT_OPTION_KEY

public static final java.lang.String SELECT_HINT_OPTION_KEY

See Also:

Constant Field Values

Method Detail

getSelectHints

public java.util.List getSelectHints()

Get list of expressions for select hints.

Overrides:

getSelectHints in class SqlQuery

Returns:

The list of select hint expressions.

hasSelectHints

public java.lang.String hasSelectHints()

Return "true" if any select hint is used, otherwise return false.

Returns:

"true" or "false".

isRunOnSource

public boolean isRunOnSource()

Get the flag indicating if this query should be run on source database server.

Returns:

- true if this question needs to be run on source server, false otherwise.

getTargetDblinlName

public java.lang.String getTargetDblinlName()

Gets the database link name of the target where this query will load into.

Returns:

The target database link name.