Uses of Interface
org.h2.util.HasSQL
Packages that use HasSQL
Package
Description
Contains DML (data manipulation language) and related SQL statements.
Database constraints such as check constraints, unique constraints, and referential constraints.
Contains high level classes of the database and classes that don't fit in another sub-package.
Expressions include mathematical operations, simple values, and others.
Aggregate functions.
Base classes for data analysis operations and implementations of window functions.
Condition expressions.
Functions.
Table value functions.
Various table index implementations, as well as cursors to navigate in an index.
Utility classes for compatibility with other database, for example MySQL.
Helper classes to use the MVStore in the H2 database.
Implementation of row and internal result sets.
Schema implementation and objects that are stored in a schema (for example, sequences and constants).
Classes related to a table and table meta data.
Data type and value implementations.
-
Uses of HasSQL in org.h2.command.dml
Classes in org.h2.command.dml that implement HasSQLModifier and TypeClassDescriptionclass
Abstract WHEN command of the MERGE statement.final class
final class
final class
final class
Set clause list. -
Uses of HasSQL in org.h2.constraint
Classes in org.h2.constraint that implement HasSQLModifier and TypeClassDescriptionclass
The base class for constraint checking.class
A check constraint.class
A domain constraint.class
A referential constraint.class
A unique constraint. -
Uses of HasSQL in org.h2.engine
Classes in org.h2.engine that implement HasSQLModifier and TypeClassDescriptionfinal class
Represents a database object comment.class
A database object such as a table, an index, or a user.final class
An access right.class
A right owner (sometimes called principal).final class
Represents a role.final class
A persistent database setting.final class
Represents a user object. -
Uses of HasSQL in org.h2.expression
Classes in org.h2.expression that implement HasSQLModifier and TypeClassDescriptionfinal class
A column alias as in SELECT 'Hello' AS NAME ...final class
Array value constructor by query.final class
Array element reference.class
A mathematical expression, or string concatenation.class
A compatibility mathematical operation with datetime values.final class
Character string concatenation as in'Hello' || 'World'
, binary string concatenation as inX'01' || X'AB'
or an array concatenation as inARRAY[1, 2] || 3
.final class
An expression representing a value for domain constraint.class
An expression is a operation, a value, or a function in a query.final class
A column reference expression that represents a column of a table or view.final class
A list of expressions, as in (ID, NAME).final class
Field reference.final class
A format clause such as FORMAT JSON.class
A mathematical operation with intervals.class
Operation without subexpressions.class
Operation with one argument.class
Operation with one or two arguments.class
Operation with two arguments.class
Operation with many arguments.final class
A parameter of a prepared statement.final class
Represents the ROWNUM function.final class
A searched case.final class
Wraps a sequence when used in a statement.final class
A simple case.final class
A query returning a single value.final class
A time zone specification (AT { TIME ZONE | LOCAL }).class
An expression representing a constant value with a type cast.class
Unary operation.class
An expression representing a constant value.final class
A user-defined variable, for example: @ID.final class
A wildcard expression as in SELECT * FROM TEST. -
Uses of HasSQL in org.h2.expression.aggregate
Classes in org.h2.expression.aggregate that implement HasSQLModifier and TypeClassDescriptionclass
A base class for aggregate functions.class
Implements the integrated aggregate functions, such as COUNT, MAX, SUM.class
This class wraps a user-defined aggregate. -
Uses of HasSQL in org.h2.expression.analysis
Classes in org.h2.expression.analysis that implement HasSQLModifier and TypeClassDescriptionclass
A base class for data analysis operations such as aggregates and window functions.class
A window function. -
Uses of HasSQL in org.h2.expression.condition
Classes in org.h2.expression.condition that implement HasSQLModifier and TypeClassDescriptionfinal class
BETWEEN predicate.final class
Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).final class
Pattern matching comparison expression: WHERE NAME LIKE ?final class
Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.(package private) class
Represents a condition returning a boolean value, or NULL.class
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?class
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.final class
An 'in' condition with a list of values, as in WHERE NAME IN(...)final class
Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.final class
A condition with parameter as= ANY(?)
.final class
An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)class
A global condition or combination of local and global conditions.class
A NOT condition.class
Exists predicate as in EXISTS(SELECT ...)final class
IS JSON predicate.final class
Null predicate (IS [NOT] NULL).(package private) class
Base class for predicates with a subquery.class
Base class for simple predicates.final class
Type predicate (IS [NOT] OF).class
Unique predicate as in UNIQUE(SELECT ...) -
Uses of HasSQL in org.h2.expression.function
Classes in org.h2.expression.function that implement HasSQLModifier and TypeClassDescriptionfinal class
An array function.final class
A bitwise function.final class
Cardinality expression.final class
A cast specification.final class
A COALESCE, GREATEST, or LEAST function.final class
NEXTVAL() and CURRVAL() compatibility functions.final class
A COMPRESS or EXPAND function.final class
A CONCAT or CONCAT_WS function.final class
An ENCRYPT or DECRYPT function.final class
A CSVWRITE function.final class
Current datetime value function.final class
Simple general value specifications.final class
DATA_TYPE_SQL() function.final class
A date-time format function.final class
A date-time function.final class
A DAYNAME() or MONTHNAME() function.final class
DB_OBJECT_ID() and DB_OBJECT_SQL() functions.final class
A FILE_READ or FILE_WRITE function.class
Function with one optional argument.class
Function with one argument.class
Function with two arguments.class
Function with two arguments.class
Function with many arguments.final class
A HASH or ORA_HASH function.final class
This class wraps a user-defined function.final class
JSON constructor function.final class
CHAR_LENGTH(), or OCTET_LENGTH() function.final class
A math function.final class
A math function with one argument and DOUBLE PRECISION result.final class
A math function with two arguments and DOUBLE PRECISION result.final class
A NULLIF function.final class
A RAND, SECURE_RAND, or RANDOM_UUID function.final class
A regular expression function.final class
An ABORT_SESSION() or CANCEL_SESSION() function.final class
A SET function.final class
A SIGNAL function.final class
A SOUNDEX or DIFFERENCE function.final class
An string function with multiple arguments.final class
A string function with one argument.final class
A string function with two arguments.final class
A SUBSTRING function.final class
Database or session information function.final class
A table information function.final class
Emulates Oracle's TO_CHAR function.final class
A TRIM function.final class
A TRUNCATE_VALUE function.final class
An XML function. -
Uses of HasSQL in org.h2.expression.function.table
Classes in org.h2.expression.function.table that implement HasSQLModifier and TypeClassDescriptionfinal class
A table value function.final class
A CSVREAD function.final class
This class wraps a user-defined function.final class
A LINK_SCHEMA function.class
A table value function. -
Uses of HasSQL in org.h2.index
Classes in org.h2.index that implement HasSQLModifier and TypeClassDescriptionclass
An index for the DUAL table.class
An index.class
A linked index is a index for a linked (remote) table.class
The index implementation for meta data tables.class
An index for the SYSTEM_RANGE table.class
This object represents a virtual index for a query.class
An index for a virtual table that returns a result set.class
An base class for indexes of virtual tables. -
Uses of HasSQL in org.h2.mode
Classes in org.h2.mode that implement HasSQLModifier and TypeClassDescriptionfinal class
Functions forMode.ModeEnum.DB2
andMode.ModeEnum.Derby
compatibility modes.class
This class implements some legacy functions not available in Regular mode.final class
Functions forMode.ModeEnum.MSSQLServer
compatibility mode.final class
This class implements some MySQL-specific functions.final class
Functions forMode.ModeEnum.Oracle
compatibility mode.final class
Functions forMode.ModeEnum.PostgreSQL
compatibility mode.class
Base class for mode-specific functions.final class
VALUES(column) function for ON DUPLICATE KEY UPDATE clause.final class
pg_catalog
schema.final class
This class is responsible to build the pg_catalog tables.final class
A ::regclass expression. -
Uses of HasSQL in org.h2.mvstore.db
Classes in org.h2.mvstore.db that implement HasSQLModifier and TypeClassDescriptionclass
An index that delegates indexing to another index.class
MVIndex<K,
V> An index that stores the data in an MVStore.class
A table stored in a MVStore.final class
An index stored in a MVStore.class
This is an index based on a MVRTreeMap.class
A table stored in a MVStore.class
A unique spatial key. -
Uses of HasSQL in org.h2.result
Classes in org.h2.result that implement HasSQLModifier and TypeClassDescriptionclass
The default implementation of a row in a table.class
Represents a row in a table.class
The base class for rows stored in a table, and for partial rows stored in the index.class
A simple row that contains data for only one column.final class
Class Sparse. -
Uses of HasSQL in org.h2.schema
Classes in org.h2.schema that implement HasSQLModifier and TypeClassDescriptionfinal class
A user-defined constant as created by the SQL statement CREATE CONSTANTfinal class
Represents a domain.final class
Represents a user-defined function, or alias.final class
Information schema.class
Meta data schema.class
A schema as created by the SQL statement CREATE SCHEMAclass
Any database object that is stored in a schema.final class
A sequence is created using the statement CREATE SEQUENCEfinal class
A trigger is created using the statement CREATE TRIGGERfinal class
Represents a user-defined aggregate function.class
User-defined Java function or aggregate function. -
Uses of HasSQL in org.h2.table
Classes in org.h2.table that implement HasSQLModifier and TypeClassDescriptionfinal class
This class represents a column in a table.class
A data change delta table.class
The DUAL table for selects without a FROM clause.class
A table backed by a system or user-defined function that returns a result set.final class
This class is responsible to build the INFORMATION_SCHEMA tables.final class
This class is responsible to build the legacy variant of INFORMATION_SCHEMA tables.class
This class is responsible to build the database meta data pseudo tables.class
The table SYSTEM_RANGE is a virtual table that generates incrementing numbers with a given start end point.class
This is the base class for most tables.class
The base class of a regular table, or a user defined table.class
A linked table contains connection information for a table accessible by JDBC.class
Synonym for an existing table or view.class
A table for table value constructor.class
A view is a virtual table that is defined by a query.class
A base class for virtual tables that construct all their content at once.class
A base class for virtual tables. -
Uses of HasSQL in org.h2.value
Classes in org.h2.value that implement HasSQLModifier and TypeClassDescriptionclass
Extended parameters of a data type.final class
Extended parameters of the ENUM data type.final class
Extended parameters of the GEOMETRY data type.final class
Extended parameters of the NUMERIC data type.final class
Extended parameters of the ROW data type.class
Data type with parameters.class
This is the base class for all value classes.final class
Implementation of the ARRAY data type.(package private) class
Base class for BigDecimal-based values.final class
Implementation of the BIGINT data type.final class
Implementation of the BINARY data type.final class
Implementation of the BINARY LARGE OBJECT data type.final class
Implementation of the BOOLEAN data type.(package private) class
Base implementation of byte array based data types.final class
Implementation of the CHARACTER data type.final class
Implementation of the CHARACTER LARGE OBJECT data type.class
Base class for ARRAY and ROW values.final class
Implementation of the DATE data type.final class
Implementation of the DECFLOAT data type.final class
Implementation of the DOUBLE PRECISION data type.final class
ENUM value.class
Base implementation of the ENUM data type.final class
Implementation of the GEOMETRY data type.final class
Implementation of the INTEGER data type.final class
Implementation of the INTERVAL data type.final class
Implementation of the JAVA_OBJECT data type.final class
Implementation of the JSON data type.class
A implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data types.final class
Implementation of NULL.final class
Implementation of the NUMERIC data type.final class
Implementation of the REAL data type.final class
Row value.final class
Implementation of the SMALLINT data type.(package private) class
Base implementation of String based data types.final class
Implementation of the TIME data type.final class
Implementation of the TIMESTAMP data type.final class
Implementation of the TIMESTAMP WITH TIME ZONE data type.final class
Implementation of the TIME WITH TIME ZONE data type.final class
Implementation of the TINYINT data type.final class
Implementation of the UUID data type.final class
Implementation of the BINARY VARYING data type.final class
Implementation of the CHARACTER VARYING data type.final class
Implementation of the VARCHAR_IGNORECASE data type.