Class TPlsqlTableTypeDefStmt
- Namespace
- gudusoft.gsqlparser.stmt.oracle
- Assembly
- gudusoft.gsqlparser.dll
A collection groups elements of the same type in a specified order. Each element has a unique subscript that determines its position in the collection.
PL/SQL has three kinds of collections:
- Associative arrays (formerly called "PL/SQL tables" or "index-by tables"), represents by TPlsqlTableTypeDefStmt
- Nested tables, represents by TPlsqlTableTypeDefStmt
- Variable-size arrays (varrays), represents by TPlsqlVarrayTypeDefStmt
Associative arrays can be indexed by either integers or strings. Nested tables and varrays are indexed by integers.
public class TPlsqlTableTypeDefStmt : TCustomSqlStatement, Visitable
- Inheritance
-
TPlsqlTableTypeDefStmt
- Implements
- Inherited Members
Constructors
TPlsqlTableTypeDefStmt()
public TPlsqlTableTypeDefStmt()
TPlsqlTableTypeDefStmt(EDbVendor)
public TPlsqlTableTypeDefStmt(EDbVendor dbvendor)
Parameters
dbvendorEDbVendor
Properties
ElementDataType
The data type of the collection element. @return
public virtual TTypeName ElementDataType { get; set; }
Property Value
IndexByDataType
For an associative array, the data type of its indexes PLS_INTEGER, BINARY_INTGER, or VARCHAR2. @return
public virtual TTypeName IndexByDataType { get; set; }
Property Value
NotNull
Specifies that no element of the collection can have the value NULL. @return
public virtual bool? NotNull { get; set; }
Property Value
- bool?
TypeName
The name that you give to the collection type that you are defining. @return
public virtual TObjectName TypeName { get; set; }
Property Value
Methods
accept(TParseTreeVisitor)
public override void accept(TParseTreeVisitor v)
Parameters
acceptChildren(TParseTreeVisitor)
public override void acceptChildren(TParseTreeVisitor v)
Parameters
doParseStatement(TCustomSqlStatement)
analyze SQL
public override int doParseStatement(TCustomSqlStatement psql)
Parameters
psqlTCustomSqlStatement
Returns
init(object, object)
public override void init(object arg1, object arg2)