Uses of Interface
org.h2.util.HasSQL
-
Packages that use HasSQL Package Description org.h2.command.dml Contains DML (data manipulation language) and related SQL statements.org.h2.constraint Database constraints such as check constraints, unique constraints, and referential constraints.org.h2.engine Contains high level classes of the database and classes that don't fit in another sub-package.org.h2.expression Expressions include mathematical operations, simple values, and others.org.h2.expression.aggregate Aggregate functions.org.h2.expression.analysis Base classes for data analysis operations and implementations of window functions.org.h2.expression.condition Condition expressions.org.h2.expression.function Functions.org.h2.expression.function.table Table value functions.org.h2.index Various table index implementations, as well as cursors to navigate in an index.org.h2.mode Utility classes for compatibility with other database, for example MySQL.org.h2.mvstore.db Helper classes to use the MVStore in the H2 database.org.h2.result Implementation of row and internal result sets.org.h2.schema Schema implementation and objects that are stored in a schema (for example, sequences and constants).org.h2.table Classes related to a table and table meta data.org.h2.value Data type and value implementations. -
-
Uses of HasSQL in org.h2.command.dml
Classes in org.h2.command.dml that implement HasSQL Modifier and Type Class Description class
MergeUsing.When
Abstract WHEN command of the MERGE statement.class
MergeUsing.WhenMatchedThenDelete
class
MergeUsing.WhenMatchedThenUpdate
class
MergeUsing.WhenNotMatched
class
SetClauseList
Set clause list. -
Uses of HasSQL in org.h2.constraint
Classes in org.h2.constraint that implement HasSQL Modifier and Type Class Description class
Constraint
The base class for constraint checking.class
ConstraintCheck
A check constraint.class
ConstraintDomain
A domain constraint.class
ConstraintReferential
A referential constraint.class
ConstraintUnique
A unique constraint. -
Uses of HasSQL in org.h2.engine
Classes in org.h2.engine that implement HasSQL Modifier and Type Class Description class
Comment
Represents a database object comment.class
DbObject
A database object such as a table, an index, or a user.class
Right
An access right.class
RightOwner
A right owner (sometimes called principal).class
Role
Represents a role.class
Setting
A persistent database setting.class
User
Represents a user object. -
Uses of HasSQL in org.h2.expression
Classes in org.h2.expression that implement HasSQL Modifier and Type Class Description class
Alias
A column alias as in SELECT 'Hello' AS NAME ...class
ArrayConstructorByQuery
Array value constructor by query.class
ArrayElementReference
Array element reference.class
BinaryOperation
A mathematical expression, or string concatenation.class
CompatibilityDatePlusTimeOperation
A compatibility mathematical operation with datetime values.class
ConcatenationOperation
Character string concatenation as in'Hello' || 'World'
, binary string concatenation as inX'01' || X'AB'
or an array concatenation as inARRAY[1, 2] || 3
.class
DomainValueExpression
An expression representing a value for domain constraint.class
Expression
An expression is a operation, a value, or a function in a query.class
ExpressionColumn
A column reference expression that represents a column of a table or view.class
ExpressionList
A list of expressions, as in (ID, NAME).class
FieldReference
Field reference.class
Format
A format clause such as FORMAT JSON.class
IntervalOperation
A mathematical operation with intervals.class
Operation0
Operation without subexpressions.class
Operation1
Operation with one argument.class
Operation1_2
Operation with one or two arguments.class
Operation2
Operation with two arguments.class
OperationN
Operation with many arguments.class
Parameter
A parameter of a prepared statement.class
Rownum
Represents the ROWNUM function.class
SearchedCase
A searched case.class
SequenceValue
Wraps a sequence when used in a statement.class
SimpleCase
A simple case.class
Subquery
A query returning a single value.class
TimeZoneOperation
A time zone specification (AT { TIME ZONE | LOCAL }).class
TypedValueExpression
An expression representing a constant value with a type cast.class
UnaryOperation
Unary operation.class
ValueExpression
An expression representing a constant value.class
Variable
A user-defined variable, for example: @ID.class
Wildcard
A wildcard expression as in SELECT * FROM TEST. -
Uses of HasSQL in org.h2.expression.aggregate
Classes in org.h2.expression.aggregate that implement HasSQL Modifier and Type Class Description class
AbstractAggregate
A base class for aggregate functions.class
Aggregate
Implements the integrated aggregate functions, such as COUNT, MAX, SUM.class
JavaAggregate
This class wraps a user-defined aggregate. -
Uses of HasSQL in org.h2.expression.analysis
Classes in org.h2.expression.analysis that implement HasSQL Modifier and Type Class Description class
DataAnalysisOperation
A base class for data analysis operations such as aggregates and window functions.class
WindowFunction
A window function. -
Uses of HasSQL in org.h2.expression.condition
Classes in org.h2.expression.condition that implement HasSQL Modifier and Type Class Description class
BetweenPredicate
BETWEEN predicate.class
BooleanTest
Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).class
CompareLike
Pattern matching comparison expression: WHERE NAME LIKE ?class
Comparison
Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.(package private) class
Condition
Represents a condition returning a boolean value, or NULL.class
ConditionAndOr
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?class
ConditionAndOrN
An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.class
ConditionIn
An 'in' condition with a list of values, as in WHERE NAME IN(...)class
ConditionInConstantSet
Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.class
ConditionInParameter
A condition with parameter as= ANY(?)
.class
ConditionInQuery
An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)class
ConditionLocalAndGlobal
A global condition or combination of local and global conditions.class
ConditionNot
A NOT condition.class
ExistsPredicate
Exists predicate as in EXISTS(SELECT ...)class
IsJsonPredicate
IS JSON predicate.class
NullPredicate
Null predicate (IS [NOT] NULL).(package private) class
PredicateWithSubquery
Base class for predicates with a subquery.class
SimplePredicate
Base class for simple predicates.class
TypePredicate
Type predicate (IS [NOT] OF).class
UniquePredicate
Unique predicate as in UNIQUE(SELECT ...) -
Uses of HasSQL in org.h2.expression.function
Classes in org.h2.expression.function that implement HasSQL Modifier and Type Class Description class
ArrayFunction
An array function.class
BitFunction
A bitwise function.class
CardinalityExpression
Cardinality expression.class
CastSpecification
A cast specification.class
CoalesceFunction
A COALESCE, GREATEST, or LEAST function.class
CompatibilitySequenceValueFunction
NEXTVAL() and CURRVAL() compatibility functions.class
CompressFunction
A COMPRESS or EXPAND function.class
ConcatFunction
A CONCAT or CONCAT_WS function.class
CryptFunction
An ENCRYPT or DECRYPT function.class
CSVWriteFunction
A CSVWRITE function.class
CurrentDateTimeValueFunction
Current datetime value function.class
CurrentGeneralValueSpecification
Simple general value specifications.class
DataTypeSQLFunction
DATA_TYPE_SQL() function.class
DateTimeFormatFunction
A date-time format function.class
DateTimeFunction
A date-time function.class
DayMonthNameFunction
A DAYNAME() or MONTHNAME() function.class
DBObjectFunction
DB_OBJECT_ID() and DB_OBJECT_SQL() functions.class
FileFunction
A FILE_READ or FILE_WRITE function.class
Function0_1
Function with one optional argument.class
Function1
Function with one argument.class
Function1_2
Function with two arguments.class
Function2
Function with two arguments.class
FunctionN
Function with many arguments.class
HashFunction
A HASH or ORA_HASH function.class
JavaFunction
This class wraps a user-defined function.class
JsonConstructorFunction
JSON constructor function.class
LengthFunction
CHAR_LENGTH(), or OCTET_LENGTH() function.class
MathFunction
A math function.class
MathFunction1
A math function with one argument and DOUBLE PRECISION result.class
MathFunction2
A math function with two arguments and DOUBLE PRECISION result.class
NullIfFunction
A NULLIF function.class
RandFunction
A RAND, SECURE_RAND, or RANDOM_UUID function.class
RegexpFunction
A regular expression function.class
SessionControlFunction
An ABORT_SESSION() or CANCEL_SESSION() function.class
SetFunction
A SET function.class
SignalFunction
A SIGNAL function.class
SoundexFunction
A SOUNDEX or DIFFERENCE function.class
StringFunction
An string function with multiple arguments.class
StringFunction1
A string function with one argument.class
StringFunction2
A string function with two arguments.class
SubstringFunction
A SUBSTRING function.class
SysInfoFunction
Database or session information function.class
TableInfoFunction
A table information function.class
ToCharFunction
Emulates Oracle's TO_CHAR function.class
TrimFunction
A TRIM function.class
TruncateValueFunction
A TRUNCATE_VALUE function.class
XMLFunction
An XML function. -
Uses of HasSQL in org.h2.expression.function.table
Classes in org.h2.expression.function.table that implement HasSQL Modifier and Type Class Description class
ArrayTableFunction
A table value function.class
CSVReadFunction
A CSVREAD function.class
JavaTableFunction
This class wraps a user-defined function.class
LinkSchemaFunction
A LINK_SCHEMA function.class
TableFunction
A table value function. -
Uses of HasSQL in org.h2.index
Classes in org.h2.index that implement HasSQL Modifier and Type Class Description class
DualIndex
An index for the DUAL table.class
Index
An index.class
LinkedIndex
A linked index is a index for a linked (remote) table.class
MetaIndex
The index implementation for meta data tables.class
RangeIndex
An index for the SYSTEM_RANGE table.class
ViewIndex
This object represents a virtual index for a query.class
VirtualConstructedTableIndex
An index for a virtual table that returns a result set.class
VirtualTableIndex
An base class for indexes of virtual tables. -
Uses of HasSQL in org.h2.mode
Classes in org.h2.mode that implement HasSQL Modifier and Type Class Description class
FunctionsDB2Derby
Functions forMode.ModeEnum.DB2
andMode.ModeEnum.Derby
compatibility modes.class
FunctionsLegacy
This class implements some legacy functions not available in Regular mode.class
FunctionsMSSQLServer
Functions forMode.ModeEnum.MSSQLServer
compatibility mode.class
FunctionsMySQL
This class implements some MySQL-specific functions.class
FunctionsOracle
Functions forMode.ModeEnum.Oracle
compatibility mode.class
FunctionsPostgreSQL
Functions forMode.ModeEnum.PostgreSQL
compatibility mode.class
ModeFunction
Base class for mode-specific functions.class
OnDuplicateKeyValues
VALUES(column) function for ON DUPLICATE KEY UPDATE clause.class
PgCatalogSchema
pg_catalog
schema.class
PgCatalogTable
This class is responsible to build the pg_catalog tables.class
Regclass
A ::regclass expression. -
Uses of HasSQL in org.h2.mvstore.db
Classes in org.h2.mvstore.db that implement HasSQL Modifier and Type Class Description class
MVDelegateIndex
An index that delegates indexing to another index.class
MVIndex<K,V>
An index that stores the data in an MVStore.class
MVPrimaryIndex
A table stored in a MVStore.class
MVSecondaryIndex
An index stored in a MVStore.class
MVSpatialIndex
This is an index based on a MVRTreeMap.class
MVTable
A table stored in a MVStore.class
SpatialKey
A unique spatial key. -
Uses of HasSQL in org.h2.result
Classes in org.h2.result that implement HasSQL Modifier and Type Class Description class
DefaultRow
The default implementation of a row in a table.class
Row
Represents a row in a table.class
SearchRow
The base class for rows stored in a table, and for partial rows stored in the index.class
SimpleRowValue
A simple row that contains data for only one column.class
Sparse
Class Sparse. -
Uses of HasSQL in org.h2.schema
Classes in org.h2.schema that implement HasSQL Modifier and Type Class Description class
Constant
A user-defined constant as created by the SQL statement CREATE CONSTANTclass
Domain
Represents a domain.class
FunctionAlias
Represents a user-defined function, or alias.class
InformationSchema
Information schema.class
MetaSchema
Meta data schema.class
Schema
A schema as created by the SQL statement CREATE SCHEMAclass
SchemaObject
Any database object that is stored in a schema.class
Sequence
A sequence is created using the statement CREATE SEQUENCEclass
TriggerObject
A trigger is created using the statement CREATE TRIGGERclass
UserAggregate
Represents a user-defined aggregate function.class
UserDefinedFunction
User-defined Java function or aggregate function. -
Uses of HasSQL in org.h2.table
Classes in org.h2.table that implement HasSQL Modifier and Type Class Description class
Column
This class represents a column in a table.class
DataChangeDeltaTable
A data change delta table.class
DualTable
The DUAL table for selects without a FROM clause.class
FunctionTable
A table backed by a system or user-defined function that returns a result set.class
InformationSchemaTable
This class is responsible to build the INFORMATION_SCHEMA tables.class
InformationSchemaTableLegacy
This class is responsible to build the legacy variant of INFORMATION_SCHEMA tables.class
MetaTable
This class is responsible to build the database meta data pseudo tables.class
RangeTable
The table SYSTEM_RANGE is a virtual table that generates incrementing numbers with a given start end point.class
Table
This is the base class for most tables.class
TableBase
The base class of a regular table, or a user defined table.class
TableLink
A linked table contains connection information for a table accessible by JDBC.class
TableSynonym
Synonym for an existing table or view.class
TableValueConstructorTable
A table for table value constructor.class
TableView
A view is a virtual table that is defined by a query.class
VirtualConstructedTable
A base class for virtual tables that construct all their content at once.class
VirtualTable
A base class for virtual tables. -
Uses of HasSQL in org.h2.value
Classes in org.h2.value that implement HasSQL Modifier and Type Class Description class
ExtTypeInfo
Extended parameters of a data type.class
ExtTypeInfoEnum
Extended parameters of the ENUM data type.class
ExtTypeInfoGeometry
Extended parameters of the GEOMETRY data type.class
ExtTypeInfoNumeric
Extended parameters of the NUMERIC data type.class
ExtTypeInfoRow
Extended parameters of the ROW data type.class
TypeInfo
Data type with parameters.class
Value
This is the base class for all value classes.class
ValueArray
Implementation of the ARRAY data type.(package private) class
ValueBigDecimalBase
Base class for BigDecimal-based values.class
ValueBigint
Implementation of the BIGINT data type.class
ValueBinary
Implementation of the BINARY data type.class
ValueBlob
Implementation of the BINARY LARGE OBJECT data type.class
ValueBoolean
Implementation of the BOOLEAN data type.(package private) class
ValueBytesBase
Base implementation of byte array based data types.class
ValueChar
Implementation of the CHARACTER data type.class
ValueClob
Implementation of the CHARACTER LARGE OBJECT data type.class
ValueCollectionBase
Base class for ARRAY and ROW values.class
ValueDate
Implementation of the DATE data type.class
ValueDecfloat
Implementation of the DECFLOAT data type.class
ValueDouble
Implementation of the DOUBLE PRECISION data type.class
ValueEnum
ENUM value.class
ValueEnumBase
Base implementation of the ENUM data type.class
ValueGeometry
Implementation of the GEOMETRY data type.class
ValueInteger
Implementation of the INTEGER data type.class
ValueInterval
Implementation of the INTERVAL data type.class
ValueJavaObject
Implementation of the JAVA_OBJECT data type.class
ValueJson
Implementation of the JSON data type.class
ValueLob
A implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data types.class
ValueNull
Implementation of NULL.class
ValueNumeric
Implementation of the NUMERIC data type.class
ValueReal
Implementation of the REAL data type.class
ValueRow
Row value.class
ValueSmallint
Implementation of the SMALLINT data type.(package private) class
ValueStringBase
Base implementation of String based data types.class
ValueTime
Implementation of the TIME data type.class
ValueTimestamp
Implementation of the TIMESTAMP data type.class
ValueTimestampTimeZone
Implementation of the TIMESTAMP WITH TIME ZONE data type.class
ValueTimeTimeZone
Implementation of the TIME WITH TIME ZONE data type.class
ValueTinyint
Implementation of the TINYINT data type.class
ValueUuid
Implementation of the UUID data type.class
ValueVarbinary
Implementation of the BINARY VARYING data type.class
ValueVarchar
Implementation of the CHARACTER VARYING data type.class
ValueVarcharIgnoreCase
Implementation of the VARCHAR_IGNORECASE data type.
-