Class TVarDeclStmt

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

Represents declare statement that used to decalre variable, constant, exception and subtype. Or Signifies that the statement is a pragma (compiler directive), including exception_init_pragma, autonomous_transaction_pragma, restrict_references_pragma, serially_resuable_pragma and pragma_timestamp

public class TVarDeclStmt : TCustomSqlStatement, Visitable

Inheritance

object

TParseTreeNode

TCustomSqlStatement

TVarDeclStmt

Implements

Visitable

Inherited Members

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)

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

TVarDeclStmt()

public TVarDeclStmt()

TVarDeclStmt(EDbVendor)

public TVarDeclStmt(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Fields

whatDeclared_constant

public const int whatDeclared_constant = 2

Field Value

int

See Also

constant

whatDeclared_exception

public const int whatDeclared_exception = 3

Field Value

int

See Also

exception

whatDeclared_pragma_autonomous_transaction

public const int whatDeclared_pragma_autonomous_transaction = 6

Field Value

int

See Also

pragma_autonomous_transaction

whatDeclared_pragma_exception_init

public const int whatDeclared_pragma_exception_init = 5

Field Value

int

See Also

pragma_exception_init

whatDeclared_pragma_interface

public const int whatDeclared_pragma_interface = 10

Field Value

int

See Also

pragma_interface

whatDeclared_pragma_restrict_references

public const int whatDeclared_pragma_restrict_references = 9

Field Value

int

See Also

pragma_restrict_references

whatDeclared_pragma_serially_reusable

public const int whatDeclared_pragma_serially_reusable = 7

Field Value

int

See Also

pragma_serially_reusable

whatDeclared_pragma_timestamp

public const int whatDeclared_pragma_timestamp = 8

Field Value

int

See Also

pragma_timestamp

whatDeclared_subtype

public const int whatDeclared_subtype = 4

Field Value

int

See Also

subtype

whatDeclared_variable

public const int whatDeclared_variable = 1

Field Value

int

See Also

variable

Properties

AliasItem

public virtual TObjectName AliasItem { get; set; }

Property Value

TObjectName

CollateName

public virtual TObjectName CollateName { get; set; }

Property Value

TObjectName

DataType

Datatype of declared element. @return

public virtual TTypeName DataType { get; set; }

Property Value

TTypeName

DeclareType

public virtual EDeclareType DeclareType { get; set; }

Property Value

EDeclareType

DefaultValue

public virtual TExpression DefaultValue { get; set; }

Property Value

TExpression

ElementName

Name of element that declared. @return

public virtual TObjectName ElementName { get; set; }

Property Value

TObjectName

Error_number

public virtual TExpression Error_number { get; set; }

Property Value

TExpression

Exception_name

public virtual TObjectName Exception_name { get; set; }

Property Value

TObjectName

HowtoSetValue

How deafult value of a variable or constant was set.

:= | DEFAULT

:= howtoSetValue_assign

or DEFAULT keyword howtoSetValue_default; @return

public virtual int HowtoSetValue { get; set; }

Property Value

int

NotNull

Specifies that no element can have the value NULL. @return

public virtual bool NotNull { get; set; }

Property Value

bool

Value

public virtual TExpression Value { get; set; }

Property Value

TExpression

See Also

DefaultValue

WhatDeclared

public virtual int WhatDeclared { get; set; }

Property Value

int

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, object)

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

Parameters

arg1 object

arg2 object

arg3 object

arg4 object

setAliasItem(TObjectName)

public void setAliasItem(TObjectName on)

Parameters

on TObjectName

setCollateName(TObjectName)

public void setCollateName(TObjectName on)

Parameters

on TObjectName

setDeclareType(EDeclareType)

public void setDeclareType(EDeclareType t)

Parameters

t EDeclareType

setDefaultValue(TExpression)

public void setDefaultValue(TExpression e)

Parameters

e TExpression