Table of Contents

Class TPlsqlForallStmt

Namespace
gudusoft.gsqlparser.stmt.oracle
Assembly
gudusoft.gsqlparser.dll

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

public class TPlsqlForallStmt : TCustomSqlStatement, Visitable
Inheritance
TPlsqlForallStmt
Implements
Inherited Members

Constructors

TPlsqlForallStmt() 

public TPlsqlForallStmt()

TPlsqlForallStmt(EDbVendor) 

public TPlsqlForallStmt(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Fields

bound_clause_kind_indices_of 

public const int bound_clause_kind_indices_of = 2

Field Value

int

bound_clause_kind_normal 

public const int bound_clause_kind_normal = 1

Field Value

int

bound_clause_kind_values_of 

public const int bound_clause_kind_values_of = 3

Field Value

int

Properties

Bound_clause_kind 

public virtual int Bound_clause_kind { get; set; }

Property Value

int

one of bound_clause_kind_normal, bound_clause_kind_indices_of, bound_clause_kind_values_of.

BoundsClause 

public virtual TDummy BoundsClause { set; }

Property Value

TDummy

CollecitonNameExpr 

public virtual TExpression CollecitonNameExpr { get; set; }

Property Value

TExpression

CollectionName 

public virtual TObjectName CollectionName { get; set; }

Property Value

TObjectName

values of collection name/indices of collection name

IndexName 

public virtual TObjectName IndexName { get; set; }

Property Value

TObjectName

An undeclared identifier that names the loop index.

Lower_bound

Used in bounds clause. @return

public virtual TExpression Lower_bound { get; set; }

Property Value

TExpression

Statement 

public virtual TCustomSqlStatement Statement { get; set; }

Property Value

TCustomSqlStatement

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

Upper_bound

Used in bounds clause. @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, object) 

public override void init(object arg1, object arg2)

Parameters

arg1 object
arg2 object
Edit this page