Namespace gudusoft.gsqlparser.stmt.oracle
Classes
- TBasicStmt
Includes some basic expression statement in plsql.
- TPlsqlCreateFunction
This class represents 3 types of SQL statement:
- Create function statement, creates or replaces a standalone function or a call specification.
- Declare a function inside a PL/SQL block or package.
- Define a function inside a PL/SQL block or package.
- TPlsqlCreatePackage
The CREATE PACKAGE statement creates or replaces the specification for a stored package, which is an encapsulated collection of related procedures, functions, and other program objects stored together in the database. The package specification declares these objects. The package body, specified subsequently, defines these objects.
- TPlsqlCreateProcedure
This class represents 3 types of SQL statement:
- Create procedure statement, creates or replaces a standalone stored procedure or a call specification.
- Declare a procedure inside a PL/SQL block or package.
- Define a procedure inside a PL/SQL block or package.
- TPlsqlCreateTrigger
The CREATE TRIGGER statement creates or replaces a database trigger, which is either of the following:
- A stored PL/SQL block associated with a table, a schema, or the database.
- An anonymous PL/SQL block or a call to a procedure implemented in PL/SQL or Java.
the database automatically executes a trigger when specified conditions occur.
- TPlsqlCreateType
The CREATE TYPE statement creates or replaces
the specification of an object type,represented by TPlsqlCreateType.
a SQLJ object type (not supported),
a named varying array (varray), represented by TPlsqlVarrayTypeDefStmt.
a nested table type, represented by TPlsqlTableTypeDefStmt.
or an incomplete object type, represented by TPlsqlCreateType.
element specification was generated in parse tree, but not public available currently.
- TPlsqlCreateTypeBody
The CREATE TYPE BODY defines or implements the member methods defined in the object type specification. You create object types with the CREATE TYPE(TPlsqlCreateType) and the CREATE TYPE BODY(TPlsqlCreateTypeBody) statements.
- TPlsqlCreateType_Placeholder
This class is a placeholder for CREATE TYPE statement.
The CREATE TYPE statement creates or replaces
the specification of an object type,represented by TPlsqlCreateType.
a SQLJ object type (not supported),
a named varying array (varray), represented by TPlsqlVarrayTypeDefStmt.
a nested table type, represented by TPlsqlTableTypeDefStmt.
or an incomplete object type, represented by TPlsqlCreateType.
You can check kind property to determine what's kind of SQL statement this class represents for.
Various SQL statement can be fetched via following properties:
ObjectStatement, VarrayStatement,NestedTableStatement accordingly.
- TPlsqlExecImmeStmt
The EXECUTE IMMEDIATE statement builds and executes a dynamic SQL statement in a single operation.
- TPlsqlForallStmt
The FORALL statement issues a series of static or dynamic DML statements, usually much faster than an equivalent FOR loop.
- TPlsqlGotoStmt
The GOTO statement branches unconditionally to a statement label or block label.
- TPlsqlRecordTypeDefStmt
A record is a composite variable that can store data values of different types.
TPlsqlRecordTypeDefStmt was used to define such a data structure.
- TPlsqlTableTypeDefStmt
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.
- TPlsqlVarrayTypeDefStmt
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.