Package gudusoft.gsqlparser.stmt.oracle

Class TPlsqlForallStmt

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.oracle.TPlsqlForallStmt

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TPlsqlForallStmt
extends TCustomSqlStatement

The FORALL statement issues a series of static or dynamic DML statements, usually much faster than an equivalent FOR loop.

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.TCustomSqlStatement

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields

Modifier and Type	Field	Description
static final int	bound_clause_kind_indices_of
static final int	bound_clause_kind_normal
static final int	bound_clause_kind_values_of

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isctequery, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, semicolonended, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TPlsqlForallStmt()
TPlsqlForallStmt(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method	Description
void	accept(TParseTreeVisitor v)	Accept a visitor
void	acceptChildren(TParseTreeVisitor v)	Accept a visitor to iterate this class and sub-nodes of this class
int	doParseStatement(TCustomSqlStatement psql)
int	getBound_clause_kind()
TExpression	getCollecitonNameExpr()
TObjectName	getCollectionName()
TObjectName	getIndexName()
TExpression	getLower_bound()	Used in bounds clause.
TCustomSqlStatement	getStatement()
TExpression	getUpper_bound()	Used in bounds clause.
void	init(Object arg1, Object arg2)
void	setBound_clause_kind(int bound_clause_kind)
void	setBoundsClause(TDummy b)
void	setCollecitonNameExpr(TExpression collecitonNameExpr)
void	setCollectionName(TObjectName collectionName)
void	setIndexName(TObjectName indexName)
void	setLower_bound(TExpression lower_bound)
void	setStatement(TCustomSqlStatement statement)
void	setUpper_bound(TExpression upper_bound)

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, computeSqlHash, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getQueryId, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getSqlHash, getSqlHash, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTargetTable, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setQueryId, setResultColumnList, setReturningClause, setSqlHash, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toNormalizedSql, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toString, toString2

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.Iterator

forEachRemaining

Field Details

bound_clause_kind_normal

public static final int bound_clause_kind_normal

See Also:

• Constant Field Values

bound_clause_kind_indices_of

public static final int bound_clause_kind_indices_of

See Also:

• Constant Field Values

bound_clause_kind_values_of

public static final int bound_clause_kind_values_of

See Also:

• Constant Field Values

Constructor Details

TPlsqlForallStmt

public TPlsqlForallStmt()

TPlsqlForallStmt

public TPlsqlForallStmt(EDbVendor dbvendor)

Method Details

getUpper_bound

public TExpression getUpper_bound()

Used in bounds clause.

Returns:

getLower_bound

public TExpression getLower_bound()

Used in bounds clause.

Returns:

getBound_clause_kind

public int getBound_clause_kind()

Returns:

one of bound_clause_kind_normal, bound_clause_kind_indices_of, bound_clause_kind_values_of.

getStatement

public TCustomSqlStatement getStatement()

Returns:

A static, such as UPDATE or DELETE, or dynamic (EXECUTE IMMEDIATE) DML statement that references collection elements in the VALUES or WHERE clauses.

init

public void init(Object arg1,
 Object arg2)

Overrides:

init in class TParseTreeNode

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

getIndexName

public TObjectName getIndexName()

Returns:

An undeclared identifier that names the loop index.

setBoundsClause

public void setBoundsClause(TDummy b)

getCollectionName

public TObjectName getCollectionName()

Returns:

values of collection name/indices of collection name

getCollecitonNameExpr

public TExpression getCollecitonNameExpr()

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setLower_bound

public void setLower_bound(TExpression lower_bound)

setUpper_bound

public void setUpper_bound(TExpression upper_bound)

setBound_clause_kind

public void setBound_clause_kind(int bound_clause_kind)

setStatement

public void setStatement(TCustomSqlStatement statement)

setIndexName

public void setIndexName(TObjectName indexName)

setCollectionName

public void setCollectionName(TObjectName collectionName)

setCollecitonNameExpr

public void setCollecitonNameExpr(TExpression collecitonNameExpr)