Class TLoopStmt

Namespace

gudusoft.gsqlparser.stmt

Assembly

gudusoft.gsqlparser.dll

A LOOP statement executes a sequence of statements multiple times. PL/SQL provides these loop statements:

• Basic loop
• WHILE loop
• FOR loop

  FOR indexName IN lower_bound .. upper_bound LOOP statements END LOOP

• Cursor FOR loop

public class TLoopStmt : TBlockSqlStatement, Visitable

Inheritance

object

TParseTreeNode

TCustomSqlStatement

TBlockSqlStatement

TLoopStmt

Implements

Visitable

Inherited Members

TBlockSqlStatement.BodyStatements

TCustomSqlStatement.RewriteInit()

TCustomSqlStatement.OracleHint

TCustomSqlStatement.Hint

TCustomSqlStatement.scanOracleHint(TSourceToken)

TCustomSqlStatement.DatabaseObjects

TCustomSqlStatement.setLabelName(TObjectName)

TCustomSqlStatement.setEndlabelName(TObjectName)

TCustomSqlStatement.LabelName

TCustomSqlStatement.EndLabelName

TCustomSqlStatement.sqlstatementtype

TCustomSqlStatement.sourcetokenlist

TCustomSqlStatement.parser

TCustomSqlStatement.plsqlparser

TCustomSqlStatement.stmtDummyTag

TCustomSqlStatement.TargetTable

TCustomSqlStatement.joins

TCustomSqlStatement.tables

TCustomSqlStatement.Statements

TCustomSqlStatement.CteList

TCustomSqlStatement.ResultColumnList

TCustomSqlStatement.ReturningClause

TCustomSqlStatement.OutputClause

TCustomSqlStatement.TopClause

TCustomSqlStatement.WhereClause

TCustomSqlStatement.addWhereClause(string)

TCustomSqlStatement.searchCTEList()

TCustomSqlStatement.ParentStmt

TCustomSqlStatement.AncestorStmt

TCustomSqlStatement.rootNode

TCustomSqlStatement.SymbolTable

TCustomSqlStatement.isparsed

TCustomSqlStatement.ErrorCount

TCustomSqlStatement.parseerrormessagehandle(TSyntaxError)

TCustomSqlStatement.parsestatement(TCustomSqlStatement, bool)

TCustomSqlStatement.OracleStatementCanBeSeparatedByBeginEndPair()

TCustomSqlStatement.isnzplsql()

TCustomSqlStatement.ispgplsql()

TCustomSqlStatement.isoracleplsql()

TCustomSqlStatement.dochecksyntax(TCustomSqlStatement)

TCustomSqlStatement.clearError()

TCustomSqlStatement.analyzeTablename(TObjectName)

TCustomSqlStatement.isTableACTE(TTable)

TCustomSqlStatement.findTable(ETableEffectType)

TCustomSqlStatement.addToTables(TTable)

TCustomSqlStatement.analyzeFromTable(TFromTable, bool?)

TCustomSqlStatement.analyzeJoin(TJoinExpr, TJoin, bool?)

TCustomSqlStatement.locateVariableOrParameter(TObjectName)

TCustomSqlStatement.fireOnMetaDatabaseTableColumn(string, string, string, string, string)

TCustomSqlStatement.FirstPhysicalTable

TCustomSqlStatement.OrphanColumns

TCustomSqlStatement.linkToFirstTable(TObjectName, int)

TCustomSqlStatement.linkColumnToTable(TObjectName, ESqlClause)

TCustomSqlStatement.linkColumnReferenceToTable(TObjectName, ESqlClause)

TCustomSqlStatement.checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt(TObjectName, bool)

TCustomSqlStatement.TopStatement

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.doParse(TCustomSqlStatement, ESqlClause)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Constructors

TLoopStmt()

public TLoopStmt()

TLoopStmt(EDbVendor)

public TLoopStmt(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Fields

basic_loop

public const int basic_loop = 1

Field Value

int

cursor_for_loop

public const int cursor_for_loop = 4

Field Value

int

for_loop

public const int for_loop = 3

Field Value

int

while_loop

public const int while_loop = 2

Field Value

int

Properties

Condition

Used in while-loop-statement

public virtual TExpression Condition { get; set; }

Property Value

TExpression

If and only if the value of this expression is TRUE, the statements in while will execute.

CursorName

public virtual TObjectName CursorName { get; set; }

Property Value

TObjectName

Cursor name when gudusoft.gsqlparser.stmt.TLoopStmt.kind is cursor_for_loop.

CursorParameterNames

public virtual TExpressionList CursorParameterNames { get; set; }

Property Value

TExpressionList

ExecuteExpr

public virtual TExpression ExecuteExpr { get; set; }

Property Value

TExpression

ExecuteUsingVars

public virtual TExpressionList ExecuteUsingVars { get; set; }

Property Value

TExpressionList

IndexName

An undeclared identifier that names the loop index. Or, it should be a record-name when kind is cursor_for_loop.

public virtual TObjectName IndexName { get; set; }

Property Value

TObjectName

Index name used in for-loop-statement.

Kind

public virtual int Kind { get; set; }

Property Value

int

Lower_bound

Used in for-loop-statement. @return

public virtual TExpression Lower_bound { get; set; }

Property Value

TExpression

RecordName

public virtual TObjectName RecordName { get; set; }

Property Value

TObjectName

Reverse

public virtual bool Reverse { get; set; }

Property Value

bool

SelectSqlNode

public virtual TSelectSqlNode SelectSqlNode { set; }

Property Value

TSelectSqlNode

Subquery

public virtual TSelectSqlStatement Subquery { get; set; }

Property Value

TSelectSqlStatement

Upper_bound

Used in for-loop-statement. @return

public virtual TExpression Upper_bound { get; set; }

Property Value

TExpression

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int

init(object)

Initialize a query tree node.

public override void init(object arg1)

Parameters

arg1 object

init(object, object)

public override void init(object arg1, object arg2)

Parameters

arg1 object

arg2 object

init(object, object, object)

public override void init(object arg1, object arg2, object arg3)

Parameters

arg1 object

arg2 object

arg3 object

init(object, object, object, object)

public override void init(object arg1, object arg2, object arg3, object arg4)

Parameters

arg1 object

arg2 object

arg3 object

arg4 object

setCursorParameterNames(TExpressionList)

public void setCursorParameterNames(TExpressionList l)

Parameters

l TExpressionList

setExecuteExpr(TExpression)

public void setExecuteExpr(TExpression e)

Parameters

e TExpression

setExecuteUsingVars(TExpressionList)

public void setExecuteUsingVars(TExpressionList l)

Parameters

l TExpressionList

setKind(int)

public void setKind(int i)

Parameters

i int

setReverse(bool)

public void setReverse(bool b)

Parameters

b bool

setSelectSqlNode(TSelectSqlNode)

public void setSelectSqlNode(TSelectSqlNode n)

Parameters

n TSelectSqlNode

See Also

BodyStatements