Uses of Interface
gudusoft.gsqlparser.IRelation
Packages that use IRelation
Package
Description
Provides the class
TGSqlParser necessary to create a SQL Parser and the classes a SQL Parser uses
internally to handle different SQL dialects.Provides the classes represents various SQL query parse tree node.
Provides the classes represent various SQL statements.
-
Uses of IRelation in gudusoft.gsqlparser
Classes in gudusoft.gsqlparser that implement IRelationModifier and TypeClassDescriptionclassTCustomSqlStatement is the root class for all SQL statements. -
Uses of IRelation in gudusoft.gsqlparser.nodes
Classes in gudusoft.gsqlparser.nodes that implement IRelationModifier and TypeClassDescriptionclassA common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.classclassRepresents a JOIN expression in SQL statements.classThis class is used to represent a JSON_TABLE function in Oracle and OpenJson function in SQL Server.classuse the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.classRepresents various kinds of table source in from clause.class -
Uses of IRelation in gudusoft.gsqlparser.nodes.functions
Classes in gudusoft.gsqlparser.nodes.functions that implement IRelationModifier and TypeClassDescriptionclassclassclassTeraData UnPack function -
Uses of IRelation in gudusoft.gsqlparser.stmt
Classes in gudusoft.gsqlparser.stmt that implement IRelationModifier and TypeClassDescriptionclassSQL alter audit policy statementclassdatabricks, hanaclassSQL alter database statement.classSQL alter function statement.classclassSQL alter index statement.classSQL alter library statement.classSQL alter materialized view statement
TAlterMaterializedViewStmt.getMaterializedViewName()returns the materialized view nameclassclassclassclassclassclassclassalter session statementclassclassSQL alter table statement.classclassclassclassclassclassThe assignment statement sets the current value of a variable, field, parameter, or element that has been declared in the current scope.classclassBase class for all sql statements that include multiple sql statementsclassclassclassThe CASE statement chooses from a sequence of conditions, and execute a corresponding statement.classThe CLOSE statement closes a cursor or cursor variable, thereby allowing its resources to be reused.classRepresents db2,oracle comment on statement.classclasssql block may have label name.classsql block with exception clauseclassclassclassclassclassclassclassclassclassCreate function.classclasscreate an index.classclassclassOracle create materialized view log Get table nameTCreateMaterializedViewLogSqlStatement.getTableName(), get column listTCreateMaterializedViewLogSqlStatement.getColumnList()classCreate procedure statement.classclassclassclassclassclassSQL create table statement.classCreate trigger statement.classclassclassDefine a view, which is a logical table based on one or more tables or views.classRepresents cursor related statement, including:classclassSingle declare cursor sql statement for GaussDBclassSQL delete statement.classSQLServer, databricksclassclassclassclassclassclassclassclassremove an index or domain index from the database.classclassclassclassclassclassclassclassclassclassclassclassclassmove a table or object table to the recycle bin or to remove the table and all its data from the database entirely.classclassclassremove a view or an object view from the database.classRepresents ELSEIF ...classclassThe EXECUTE IMMEDIATE statement builds and executes a dynamic SQL statement in a single operation.classDeprecated.classexecute statement db: couchbase, netezza,greenplum,mysql, postgresql,redshiftclassThe EXIT statement exits a loop and transfers control to the end of the loop.classclassThe FETCH statement retrieves rows of data from the result set of a multiple-row query.classclassDeprecated.since GSP Java version 2.3.9.3, useTGetDiagStmtinstead.classclassclassThe IF statement executes or skips a sequence of statements, depending on the value of a Boolean expressionclassSQL insert statement.classclassclassclassclassA LOOP statement executes a sequence of statements multiple times.classMerge SQL statement.classclassclassThe OPEN-FOR statement executes the SELECT statement associated with a cursor variable.classThe OPEN statement executes the query associated with a cursor.classclassclassThe RAISE statement stops normal execution of a PL/SQL block or subprogram and transfers control to an exception handler.classclassclassclassclassThis class represents reset statement of GaussDB.classThe RETURN statement immediately completes the execution of a subprogram and returns control to the invokerclassclassclassBase class of procedure and function.classclassClassTSelectSqlStatementrepresents query specification, query expression and select statement.classclassclassclassclassclassclassclassblock with declaration and parameters
Base class for stored procedure such as create function, procedure, trigger and etc.classclassclassAthena, Hana, redshiftclassclassSQL update statement.classclassclassDeprecated.since v2.6.2.8, please useTUseDatabaseinstead.classclassRepresents declare statement that used to decalre variable, constant, exception and subtype.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.bigquery
Classes in gudusoft.gsqlparser.stmt.bigquery that implement IRelationModifier and TypeClassDescriptionclassBigQuery CREATE MODEL statement for machine learning.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.couchbase
Classes in gudusoft.gsqlparser.stmt.couchbase that implement IRelation -
Uses of IRelation in gudusoft.gsqlparser.stmt.databricks
Classes in gudusoft.gsqlparser.stmt.databricks that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.dax
Classes in gudusoft.gsqlparser.stmt.dax that implement IRelationModifier and TypeClassDescriptionclassDAX Evaluate query.classDAX expression statement, syntax likeclassBase class of DAX statement -
Uses of IRelation in gudusoft.gsqlparser.stmt.db2
Classes in gudusoft.gsqlparser.stmt.db2 that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassDeprecated.since v2.6.4.1, useTCreateFunctionStmtinstead.classDeprecated.As of v2.5.1.7, replaced byTCreateProcedureStmtclassDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtclassclassclassclassclassclassclassDeprecated.since v2.8.8.9, useTIfStmtinsteadclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.greenplum
Classes in gudusoft.gsqlparser.stmt.greenplum that implement IRelation -
Uses of IRelation in gudusoft.gsqlparser.stmt.hana
Classes in gudusoft.gsqlparser.stmt.hana that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.hive
Classes in gudusoft.gsqlparser.stmt.hive that implement IRelationModifier and TypeClassDescriptionclassHive create function.classclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassDeprecated.since 2.6.2.6, useTUseDatabaseinsteadclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.impala
Classes in gudusoft.gsqlparser.stmt.impala that implement IRelation -
Uses of IRelation in gudusoft.gsqlparser.stmt.informix
Classes in gudusoft.gsqlparser.stmt.informix that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassInformix create function.classInformix create procedure.classclassDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.mdx
Classes in gudusoft.gsqlparser.stmt.mdx that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassMDX, select statement.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.mssql
Classes in gudusoft.gsqlparser.stmt.mssql that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassSQL Server/ Sybase create function.classSQL Server/ Sybase create procedure statement.classclassDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtSQL SQL create trigger statement.classclassclassclassclassclassDeprecated., use TDropTableSqlStatement instead.classDeprecated., use TDropViewSqlStatement instead.classclassclassclassExecute a stored procedure or function, or Execute a character stringclassclassclassclassclassDeprecated.As of v1.9.4.1, replaced byTGrantStmtclassThis class represents if and while SQL statement of SQL Server.classclassclassclassclassclassclassclassclassclassclasssql server set rowcount statementclassclassclassRepresents SQL Server TRY...CATCH statement.classclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.mysql
Classes in gudusoft.gsqlparser.stmt.mysql that implement IRelationModifier and TypeClassDescriptionclassclassclassDeprecated.since GSP Java version 2.5.1.2, useTCommonBlockinstead.classDeprecated.since GSP Java version 2.5.1.2, useTCallStatementinstead.classclassDeprecated.since GSP Java version 2.5.1.2, useTCreateFunctionStmtinstead.classDeprecated.since GSP Java version 2.3.9.3, useTCreateProcedureStmtinstead.classDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtclassclassclassDeprecated.As of v2.5.1.3, replaced byTFetchStmtclassclassDeprecated.since GSP Java version 2.3.9.3, useTLoopStmtinstead.classDeprecated.As of v2.5.1.3, replaced byTOpenStmtclassclassDeprecated.As of v2.0.4.6, replaced byTRepeatStmtclassDeprecated.since GSP Java version 2.5.1.2, useTReturnStmtinstead.classDeprecated.since GSP Java version 2.5.1.2, useTSetStmtinstead.classclassclassclassclassDeprecated.As of v2.0.5.3, useTWhileStmtinsteadclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.netezza
Classes in gudusoft.gsqlparser.stmt.netezza that implement IRelationModifier and TypeClassDescriptionclassnetezza generate [express] statistics statementclassnetezza groom table statement. -
Uses of IRelation in gudusoft.gsqlparser.stmt.oracle
Classes in gudusoft.gsqlparser.stmt.oracle that implement IRelationModifier and TypeClassDescriptionclassIncludes some basic expression statement in plsql.classclassclassclassclassDeprecated.As of v1.4.4.5, replaced byTCreateSequenceStmtclassDeprecated.As of v1.4.4.5, replaced byTCreateSynonymStmtclassclassclassOracle create function.classThe 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.classThis class represents 3 types of SQL statement: Create procedure statement, creates or replaces a standalone stored procedure or a call specification.classThe 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. For detailed information about Oracle simple_dml_trigger, compound_dml_trigger, non_dml_trigger Please checkTTriggeringClauseclassThe CREATE TYPE statement creates or replacesclassThis class is a placeholder for CREATE TYPE statement.classThe CREATE TYPE BODY defines or implements the member methods defined in the object type specification.classclassThe FORALL statement issues a series of static or dynamic DML statements, usually much faster than an equivalent FOR loop.classThe GOTO statement branches unconditionally to a statement label or block label.classclassclassclassclassA record is a composite variable that can store data values of different types.classclassclassDeprecated.As of v1.6.4.1classA collection groups elements of the same type in a specified order.classA collection groups elements of the same type in a specified order.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.postgresql
Classes in gudusoft.gsqlparser.stmt.postgresql that implement IRelationModifier and TypeClassDescriptionclassclassclassDeprecated.As of v1.6.3.7, replaced byTGrantStmtclassDeprecated.As of v1.6.3.7, May add lock statement under package: gudusoft.gsqlparser.stmtclassclassclassclassclassDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtCreate triggerclassclassclassDeprecated.since GSP Java version 2.6.1.2, useTSetStmtinstead.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.presto
Classes in gudusoft.gsqlparser.stmt.presto that implement IRelation -
Uses of IRelation in gudusoft.gsqlparser.stmt.redshift
Classes in gudusoft.gsqlparser.stmt.redshift that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassDeprecated.since GSP Java version 2.5.2.5, useTCreateSchemaSqlStatementinstead.classclassclassclassclassclassclassclassDeprecated.since version, 2.9.3.5, useTLockTableStmtinstead.classclassclassclassclassDeprecated.since version 2.5.9.1, useTUnloadStmtinstead.class -
Uses of IRelation in gudusoft.gsqlparser.stmt.snowflake
Classes in gudusoft.gsqlparser.stmt.snowflake that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassSnowflake alter taskclassclassclassclassclassclassSnowflake CREATE SEMANTIC VIEW statement.classclassSnowflake create stageclassclassclassclassclassclassexpression used in the create function body will be treated as a pseudo expression statement.classclassclassclassclassclassSnowflake use schemaclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.sparksql
Classes in gudusoft.gsqlparser.stmt.sparksql that implement IRelation -
Uses of IRelation in gudusoft.gsqlparser.stmt.sybase
Classes in gudusoft.gsqlparser.stmt.sybase that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.teradata
Classes in gudusoft.gsqlparser.stmt.teradata that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassTeradata create function.classDeprecated.As of v2.0.7.7, replaced byTCreateProcedureStmtclassDeprecated.As of v2.0.1.0, replaced byTCreateTriggerStmtclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclass -
Uses of IRelation in gudusoft.gsqlparser.stmt.vertica
Classes in gudusoft.gsqlparser.stmt.vertica that implement IRelationModifier and TypeClassDescriptionclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclassclass
TExecuteSqlStatement