See: Description
| Class | Description |
|---|---|
| TAlterAuditPolicyStmt |
SQL alter audit policy statement
|
| TAlterDatabaseStmt |
SQL alter database statement.
|
| TAlterFunctionStmt |
SQL alter function statement.
|
| TAlterIndexStmt |
SQL alter index statement.
|
| TAlterLibraryStmt |
SQL alter library statement.
|
| TAlterMaterializedViewStmt |
SQL alter materialized view statement
TAlterMaterializedViewStmt.getMaterializedViewName() returns the materialized view name |
| TAlterRoleStmt | |
| TAlterSchemaStmt | |
| TAlterSequenceStatement | |
| TAlterSessionStatement |
alter session statement
|
| TAlterSynonymStmt | |
| TAlterTableStatement |
SQL alter table statement.
|
| TAlterTriggerStmt | |
| TAlterUserStmt | |
| TAlterViewStatement | |
| TAssignStmt |
The assignment statement sets the current value of a variable, field, parameter,
or element that has been declared in the current scope.
|
| TBeginTran | |
| TBlockSqlStatement |
Base class for all sql statements that include multiple sql statements
|
| TCallStatement | |
| TCaseStmt |
The CASE statement chooses from a sequence of conditions, and execute a corresponding statement.
|
| TCloseStmt |
The CLOSE statement closes a cursor or cursor variable, thereby allowing its resources to be reused.
|
| TCommentOnSqlStmt | |
| TCommitStmt | |
| TCommonBlock |
sql block may have label name.
|
| TCommonStoredProcedureSqlStatement |
sql block with exception clause
|
| TConnectStmt | |
| TCreateAliasStmt | |
| TCreateAuditPolicyStmt | |
| TCreateDatabaseLinkStmt | |
| TCreateDatabaseSqlStatement | |
| TCreateFunctionStmt |
Create function.
|
| TCreateIndexSqlStatement |
create an index.
|
| TCreateMaterializedSqlStatement | |
| TCreateMaterializedViewLogSqlStatement |
Oracle create materialized view log
Get table name
TCreateMaterializedViewLogSqlStatement.getTableName(), get column list TCreateMaterializedViewLogSqlStatement.getColumnList() |
| TCreateProcedureStmt | |
| TCreateRoleStmt | |
| TCreateSchemaSqlStatement | |
| TCreateSequenceStmt | |
| TCreateSynonymStmt | |
| TCreateTableSqlStatement |
SQL create table statement.
|
| TCreateTriggerStmt |
Create trigger statement.
|
| TCreateUserStmt | |
| TCreateViewSqlStatement |
Define a view, which is a logical table based on one or more tables or views.
|
| TCursorDeclStmt |
Represents cursor related statement, including:
|
| TDeleteSqlStatement |
SQL delete statement.
|
| TDescribeStmt | |
| TDisconnectStmt | |
| TDropDatabaseLinkStmt | |
| TDropDatabaseStmt | |
| TDropFunctionStmt | |
| TDropIndexSqlStatement |
remove an index or domain index from the database.
|
| TDropLibraryStmt | |
| TDropMaterializedViewLogStmt | |
| TDropMaterializedViewStmt | |
| TDropProcedureStmt | |
| TDropProfileStmt | |
| TDropProjectionStmt | |
| TDropRoleStmt | |
| TDropSchemaSqlStatement | |
| TDropSequenceStmt | |
| TDropStmt | |
| TDropSynonymStmt | |
| TDropTableSqlStatement |
move a table or object table to the recycle bin or to remove the table and all its data from the database entirely.
|
| TDropTriggerSqlStatement | |
| TDropUserStmt | |
| TDropViewSqlStatement |
remove a view or an object view from the database.
|
| TElsifStmt |
Represents ELSEIF ...
|
| TEndTran | |
| TExecutePreparedStatement | |
| TExitStmt |
The EXIT statement exits a loop and transfers control to the end of the loop.
|
| TExplainPlan | |
| TFetchStmt |
The FETCH statement retrieves rows of data from the result set of a multiple-row query.
|
| TGrantStmt | |
| TIfStmt |
The IF statement executes or skips a sequence of statements, depending on the value
of a Boolean expression
|
| TInsertSqlStatement |
SQL insert statement.
|
| TLockTableStmt | |
| TLoopStmt |
A LOOP statement executes a sequence of statements multiple times.
|
| TMergeSqlStatement |
Merge SQL statement.
|
| TMssqlCreateType | |
| TOpenforStmt |
The OPEN-FOR statement executes the SELECT statement associated with a cursor variable.
|
| TOpenStmt |
The OPEN statement executes the query associated with a cursor.
|
| TParseErrorSqlStatement | |
| TRaiseStmt |
The RAISE statement stops normal execution of a PL/SQL block or subprogram and transfers control to an exception handler.
|
| TReleaseSavepointStmt | |
| TRenameStmt | |
| TReturnStmt |
The RETURN statement immediately completes the execution of a subprogram and returns control to the invoker
|
| TRevokeStmt | |
| TRollbackStmt | |
| TSavepointStmt | |
| TSelectSqlStatement |
Class
TSelectSqlStatement represents query specification, query expression and select statement. |
| TSetDatabaseObjectStmt | |
| TSetStmt | |
| TShowStmt | |
| TStoredProcedureSqlStatement |
block with declaration and parameters
Base class for stored procedure such as create function, procedure, trigger and etc. |
| TTruncateStatement | |
| TUnknownSqlStatement | |
| TUnsetStmt | |
| TUpdateSqlStatement |
SQL update statement.
|
| TUseDatabase | |
| TUseStmt |
Some typical SQL statements:
TSelectSqlStatementTDeleteSqlStatementTInsertSqlStatementTUpdateSqlStatementTCreateTableSqlStatementgudusoft.gsqlparser.stmtCopyright © 2019. All rights reserved.