Package gudusoft.gsqlparser.stmt
package gudusoft.gsqlparser.stmt
Provides the classes represent various SQL statements.
Some typical SQL statements:
- Select:
TSelectSqlStatement - Delete:
TDeleteSqlStatement - Insert:
TInsertSqlStatement - Update:
TUpdateSqlStatement - Create table:
TCreateTableSqlStatement - More:
gudusoft.gsqlparser.stmt
- Since:
- 1.0
-
ClassDescriptionSQL alter audit policy statementdatabricks, hanaSQL alter database statement.SQL alter function statement.SQL alter index statement.SQL alter library statement.SQL alter materialized view statement
TAlterMaterializedViewStmt.getMaterializedViewName()returns the materialized view namealter session statementSQL alter table statement.The assignment statement sets the current value of a variable, field, parameter, or element that has been declared in the current scope.Base class for all sql statements that include multiple sql statementsThe CASE statement chooses from a sequence of conditions, and execute a corresponding statement.The CLOSE statement closes a cursor or cursor variable, thereby allowing its resources to be reused.Represents db2,oracle comment on statement.sql block may have label name.sql block with exception clauseCreate function.create an index.Oracle create materialized view log Get table nameTCreateMaterializedViewLogSqlStatement.getTableName(), get column listTCreateMaterializedViewLogSqlStatement.getColumnList()Create procedure statement.SQL create table statement.Create trigger statement.Define a view, which is a logical table based on one or more tables or views.Represents cursor related statement, including:Single declare cursor sql statement for GaussDBSQL delete statement.SQLServer, databricksremove an index or domain index from the database.move a table or object table to the recycle bin or to remove the table and all its data from the database entirely.remove a view or an object view from the database.Represents ELSEIF ...The EXECUTE IMMEDIATE statement builds and executes a dynamic SQL statement in a single operation.Deprecated.execute statement db: couchbase, netezza,greenplum,mysql, postgresql,redshiftThe EXIT statement exits a loop and transfers control to the end of the loop.The FETCH statement retrieves rows of data from the result set of a multiple-row query.Deprecated.since GSP Java version 2.3.9.3, useTGetDiagStmtinstead.The IF statement executes or skips a sequence of statements, depending on the value of a Boolean expressionSQL insert statement.A LOOP statement executes a sequence of statements multiple times.Merge SQL statement.The OPEN-FOR statement executes the SELECT statement associated with a cursor variable.The OPEN statement executes the query associated with a cursor.The RAISE statement stops normal execution of a PL/SQL block or subprogram and transfers control to an exception handler.This class represents reset statement of GaussDB.The RETURN statement immediately completes the execution of a subprogram and returns control to the invokerBase class of procedure and function.ClassTSelectSqlStatementrepresents query specification, query expression and select statement.block with declaration and parameters
Base class for stored procedure such as create function, procedure, trigger and etc.Athena, Hana, redshiftSQL update statement.Deprecated.since v2.6.2.8, please useTUseDatabaseinstead.Represents declare statement that used to decalre variable, constant, exception and subtype.
TExecuteSqlStatement