- All Implemented Interfaces:
Serializable
,Comparable<Clause>
,Constable
VisitListener
.
Disclaimer
This SPI is still experimental! Some SPI elements and/or behavioural elements may change in future minor releases.-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>>
-
Enum Constant Summary
Enum ConstantDescriptionDeprecated, for removal: This API element is subject to removal in a future version.A completeALTER INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.AnINDEX
clause within anALTER_INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASCHEMA
clause within anALTER_SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME
clause within anALTER_SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARESTART
clause within anALTER_SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within anALTER_SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AADD
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AALTER
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AALTER DEFAULT
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.ADROP
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME COLUMN
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME CONSTRAINT
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME INDEX
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anALTER_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anALTER_VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A condition expression.Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingAND
.Deprecated, for removal: This API element is subject to removal in a future version.ABEWEEN
condition.Deprecated, for removal: This API element is subject to removal in a future version.ABEWEEN SYMMETRIC
condition.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.AnEXISTS
condition.Deprecated, for removal: This API element is subject to removal in a future version.AnIN
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT NULL
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANULL
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT BEWEEN
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT BEWEEN SYMMETRIC
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT EXISTS
condition.Deprecated, for removal: This API element is subject to removal in a future version.ANOT IN
condition.Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingOR
.Deprecated, for removal: This API element is subject to removal in a future version.AnOVERLAPS
condition.Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingXOR
.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.A view name clause within aCREATE_SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within aCREATE_SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AnAS
clause within aCREATE_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A column list within aCREATE_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A constraint list within aCREATE_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A view name clause within aCREATE_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.AnAS
clause within aCREATE_VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.A view name clause within aCREATE_VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.A customQueryPart
clause.Deprecated, for removal: This API element is subject to removal in a future version.A completeDELETE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ADELETE
clause within anDELETE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARETURNING
clause within anDELETE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AWHERE
clause within anDELETE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP INDEX
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASCHEMA
clause within anDROP_SCHEMA
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within aDROP_SEQUENCE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anDROP_TABLE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.AVIEW
clause within anDROP_VIEW
statement.Deprecated, for removal: This API element is subject to removal in a future version.A field expression.Deprecated, for removal: This API element is subject to removal in a future version.A field alias declaration.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A physical or aliased field reference.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A completeINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheINSERT INTO
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheON DUPLICATE KEY UPDATE
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheON DUPLICATE KEY UPDATE
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheRETURNING
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheSELECT
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.TheVALUES
clause within anINSERT
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.AMERGE INTO
clause within anMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AnON
clause within aMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.AUSING
clause within aMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AVALUES
clause within aMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AWHEN MATCHED THEN UPDATE
clause within aMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AWHEN NOT MATCHED THEN INSERT
clause within aMERGE
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A completeSELECT
statement or a subselect.Deprecated, for removal: This API element is subject to removal in a future version.ACONNECT BY
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.AEXCEPT
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AEXCEPT ALL
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AFROM
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.AHAVING
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.AINTERSECT
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AINTERSECT ALL
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AINTO
clause within aSELECT
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.ASELECT
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.ASTART WITH
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.AUNION
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AUNION ALL
set operation.Deprecated, for removal: This API element is subject to removal in a future version.AWHERE
clause within aSELECT
statement or subselect.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A table expression.Deprecated, for removal: This API element is subject to removal in a future version.A table alias declaration.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.A physical or aliased table reference.Deprecated, for removal: This API element is subject to removal in a future version.AVALUES
table constructorDeprecated, for removal: This API element is subject to removal in a future version.A plain SQL template clause.Deprecated, for removal: This API element is subject to removal in a future version.A completeTRUNCATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ATRUNCATE
clause within anTRUNCATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A completeUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.A vendor-specificFROM
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ARETURNING
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.ASET
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.An assigment within aUPDATE_SET
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AnUPDATE
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.AWHERE
clause within anUPDATE
statement.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.AWITH
clause preceding all sorts of DML statements. -
Method Summary
Modifier and TypeMethodDescriptionstatic Clause
Deprecated, for removal: This API element is subject to removal in a future version.Returns the enum constant of this class with the specified name.static Clause[]
values()
Deprecated, for removal: This API element is subject to removal in a future version.Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
USER
Deprecated, for removal: This API element is subject to removal in a future version. -
ROLE
Deprecated, for removal: This API element is subject to removal in a future version. -
PRIVILEGE
Deprecated, for removal: This API element is subject to removal in a future version. -
CONSTRAINT
Deprecated, for removal: This API element is subject to removal in a future version. -
CATALOG
Deprecated, for removal: This API element is subject to removal in a future version. -
CATALOG_REFERENCE
Deprecated, for removal: This API element is subject to removal in a future version. -
SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version. -
SCHEMA_REFERENCE
Deprecated, for removal: This API element is subject to removal in a future version. -
SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version. -
SEQUENCE_REFERENCE
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE
Deprecated, for removal: This API element is subject to removal in a future version.A table expression.This clause surrounds an actual table expression as it can be encountered in
-
TABLE_ALIAS
Deprecated, for removal: This API element is subject to removal in a future version.A table alias declaration.This clause surrounds a table alias declaration, for instance within the
SELECT_FROM
clause, or within aTABLE_JOIN
clause, wrapping anotherTABLE
.Referenced table aliases emit
TABLE_REFERENCE
clauses. -
TABLE_REFERENCE
Deprecated, for removal: This API element is subject to removal in a future version.A physical or aliased table reference.This is a terminal clause used to reference physical or aliased tables.
-
TABLE_JOIN
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_INNER
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_CROSS
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_NATURAL
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_OUTER_LEFT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_OUTER_RIGHT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_OUTER_FULL
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_NATURAL_OUTER_LEFT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_NATURAL_OUTER_RIGHT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_NATURAL_OUTER_FULL
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_CROSS_APPLY
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_OUTER_APPLY
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_SEMI_LEFT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_ANTI_LEFT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_STRAIGHT
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_ON
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_USING
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_JOIN_PARTITION_BY
Deprecated, for removal: This API element is subject to removal in a future version. -
TABLE_VALUES
Deprecated, for removal: This API element is subject to removal in a future version.AVALUES
table constructorThis clause surrounds a
- a
VALUES
keyword - a table constructor with several
FIELD_ROW
value expressions
- a
-
FIELD
Deprecated, for removal: This API element is subject to removal in a future version.A field expression.This clause surrounds an actual field expression as it can be encountered in various other clauses, such as for instance
SELECT_SELECT
. -
FIELD_ALIAS
Deprecated, for removal: This API element is subject to removal in a future version.A field alias declaration.This clause surrounds a field alias declaration, for instance within the
SELECT_SELECT
clause, wrapping anotherFIELD
.Referenced field aliases emit
FIELD_REFERENCE
clauses. -
FIELD_REFERENCE
Deprecated, for removal: This API element is subject to removal in a future version.A physical or aliased field reference.This is a terminal clause used to reference physical or aliased fields.
-
FIELD_VALUE
Deprecated, for removal: This API element is subject to removal in a future version. -
FIELD_CASE
Deprecated, for removal: This API element is subject to removal in a future version. -
FIELD_ROW
Deprecated, for removal: This API element is subject to removal in a future version. -
FIELD_FUNCTION
Deprecated, for removal: This API element is subject to removal in a future version. -
CONDITION
Deprecated, for removal: This API element is subject to removal in a future version.A condition expression. -
CONDITION_IS_NULL
Deprecated, for removal: This API element is subject to removal in a future version.ANULL
condition.This clause surrounds a
FIELD
. -
CONDITION_IS_NOT_NULL
Deprecated, for removal: This API element is subject to removal in a future version.ANOT NULL
condition.This clause surrounds a
FIELD
. -
CONDITION_COMPARISON
Deprecated, for removal: This API element is subject to removal in a future version. -
CONDITION_BETWEEN
Deprecated, for removal: This API element is subject to removal in a future version.ABEWEEN
condition.This clause surrounds three
FIELD
clauses. -
CONDITION_BETWEEN_SYMMETRIC
Deprecated, for removal: This API element is subject to removal in a future version.ABEWEEN SYMMETRIC
condition.This clause surrounds three
FIELD
clauses. -
CONDITION_NOT_BETWEEN
Deprecated, for removal: This API element is subject to removal in a future version.ANOT BEWEEN
condition.This clause surrounds three
FIELD
clauses. -
CONDITION_NOT_BETWEEN_SYMMETRIC
Deprecated, for removal: This API element is subject to removal in a future version.ANOT BEWEEN SYMMETRIC
condition.This clause surrounds three
FIELD
clauses. -
CONDITION_OVERLAPS
Deprecated, for removal: This API element is subject to removal in a future version.AnOVERLAPS
condition.This clause surrounds two
FIELD
clauses. -
CONDITION_AND
Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingAND
.This clause surrounds several
CONDITION
clauses. -
CONDITION_OR
Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingOR
.This clause surrounds several
CONDITION
clauses. -
CONDITION_XOR
Deprecated, for removal: This API element is subject to removal in a future version.A combined condition usingXOR
.This clause surrounds several
CONDITION
clauses. -
CONDITION_NOT
Deprecated, for removal: This API element is subject to removal in a future version.ANOT
condition.This clause surrounds a
CONDITION
clause. -
CONDITION_IN
Deprecated, for removal: This API element is subject to removal in a future version.AnIN
condition.This clause surrounds two or more
FIELD
clauses. -
CONDITION_NOT_IN
Deprecated, for removal: This API element is subject to removal in a future version.ANOT IN
condition.This clause surrounds two or more
FIELD
clauses. -
CONDITION_EXISTS
Deprecated, for removal: This API element is subject to removal in a future version.AnEXISTS
condition.This clause surrounds a
SELECT
clause. -
CONDITION_NOT_EXISTS
Deprecated, for removal: This API element is subject to removal in a future version.ANOT EXISTS
condition.This clause surrounds a
SELECT
clause. -
WITH
Deprecated, for removal: This API element is subject to removal in a future version.AWITH
clause preceding all sorts of DML statements. -
SELECT
Deprecated, for removal: This API element is subject to removal in a future version.A completeSELECT
statement or a subselect.This clause surrounds a complete
SELECT
statement, a subselect, or a set operation, such as -
SELECT_UNION
Deprecated, for removal: This API element is subject to removal in a future version.AUNION
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aUNION
set operation. -
SELECT_UNION_ALL
Deprecated, for removal: This API element is subject to removal in a future version.AUNION ALL
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aUNION ALL
set operation. -
SELECT_INTERSECT
Deprecated, for removal: This API element is subject to removal in a future version.AINTERSECT
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aINTERSECT
set operation. -
SELECT_INTERSECT_ALL
Deprecated, for removal: This API element is subject to removal in a future version.AINTERSECT ALL
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aINTERSECT ALL
set operation. -
SELECT_EXCEPT
Deprecated, for removal: This API element is subject to removal in a future version.AEXCEPT
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aEXCEPT
set operation. -
SELECT_EXCEPT_ALL
Deprecated, for removal: This API element is subject to removal in a future version.AEXCEPT ALL
set operation.This clause surrounds two or more subselects (see
SELECT
) concatenating them using aEXCEPT ALL
set operation. -
SELECT_SELECT
Deprecated, for removal: This API element is subject to removal in a future version.ASELECT
clause within aSELECT
statement or subselect.This clause surrounds
- the
SELECT
keyword - Oracle style hints
- the T-SQL style
TOP … START AT
clause - the select field list
- the
-
SELECT_INTO
Deprecated, for removal: This API element is subject to removal in a future version.AINTO
clause within aSELECT
statement.This clause surrounds
- the
INTO
keyword - the table reference
See
TABLE
and related clauses for possible table references.- See Also:
- the
-
SELECT_FROM
Deprecated, for removal: This API element is subject to removal in a future version.AFROM
clause within aSELECT
statement or subselect.This clause surrounds
- the
FROM
keyword - the table reference list
See
TABLE
and related clauses for possible table references.- See Also:
- the
-
SELECT_WHERE
Deprecated, for removal: This API element is subject to removal in a future version.AWHERE
clause within aSELECT
statement or subselect.This clause surrounds
- the
WHERE
keyword - a
CONDITION
See
CONDITION
and related clauses for possible conditions- See Also:
- the
-
SELECT_START_WITH
Deprecated, for removal: This API element is subject to removal in a future version.ASTART WITH
clause within aSELECT
statement or subselect.This clause surrounds
- the
START WITH
keywords - a
CONDITION
See
CONDITION
and related clauses for possible conditions- See Also:
- the
-
SELECT_CONNECT_BY
Deprecated, for removal: This API element is subject to removal in a future version.ACONNECT BY
clause within aSELECT
statement or subselect.This clause surrounds
- the
CONNECT BY
keywords - a
CONDITION
See
CONDITION
and related clauses for possible conditions- See Also:
- the
-
SELECT_GROUP_BY
Deprecated, for removal: This API element is subject to removal in a future version. -
SELECT_HAVING
Deprecated, for removal: This API element is subject to removal in a future version.AHAVING
clause within aSELECT
statement or subselect.This clause surrounds
- the
HAVING
keyword - a
CONDITION
See
CONDITION
and related clauses for possible conditions- See Also:
- the
-
SELECT_WINDOW
Deprecated, for removal: This API element is subject to removal in a future version. -
SELECT_ORDER_BY
Deprecated, for removal: This API element is subject to removal in a future version. -
INSERT
Deprecated, for removal: This API element is subject to removal in a future version.A completeINSERT
statement. -
INSERT_INSERT_INTO
Deprecated, for removal: This API element is subject to removal in a future version.TheINSERT INTO
clause within anINSERT
statement.This clause surrounds
- the
INSERT INTO
keywords - the table that is being inserted
- the
-
INSERT_VALUES
Deprecated, for removal: This API element is subject to removal in a future version. -
INSERT_SELECT
Deprecated, for removal: This API element is subject to removal in a future version. -
INSERT_ON_DUPLICATE_KEY_UPDATE
Deprecated, for removal: This API element is subject to removal in a future version.TheON DUPLICATE KEY UPDATE
clause within anINSERT
statement.This clause surrounds several
INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT
clauses.- the
ON DUPLICATE KEY UPDATE
keywords - several
INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT
clauses
- the
-
INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT
Deprecated, for removal: This API element is subject to removal in a future version. -
INSERT_RETURNING
Deprecated, for removal: This API element is subject to removal in a future version. -
UPDATE
Deprecated, for removal: This API element is subject to removal in a future version.A completeUPDATE
statement. -
UPDATE_UPDATE
Deprecated, for removal: This API element is subject to removal in a future version.AnUPDATE
clause within anUPDATE
statement.This clause surrounds
- the
UPDATE
keyword - the table that is being updated
- the
-
UPDATE_SET
Deprecated, for removal: This API element is subject to removal in a future version.ASET
clause within anUPDATE
statement.This clause surrounds
- the
SET
keyword - one or several assignments:
UPDATE_SET_ASSIGNMENT
- the
-
UPDATE_SET_ASSIGNMENT
Deprecated, for removal: This API element is subject to removal in a future version. -
UPDATE_FROM
Deprecated, for removal: This API element is subject to removal in a future version. -
UPDATE_WHERE
Deprecated, for removal: This API element is subject to removal in a future version. -
UPDATE_RETURNING
Deprecated, for removal: This API element is subject to removal in a future version. -
DELETE
Deprecated, for removal: This API element is subject to removal in a future version.A completeDELETE
statement. -
DELETE_DELETE
Deprecated, for removal: This API element is subject to removal in a future version.ADELETE
clause within anDELETE
statement.This clause surrounds
- the
DELETE FROM
keywords - the table that is being deleted
- the
-
DELETE_WHERE
Deprecated, for removal: This API element is subject to removal in a future version. -
DELETE_RETURNING
Deprecated, for removal: This API element is subject to removal in a future version. -
MERGE
Deprecated, for removal: This API element is subject to removal in a future version.A completeMERGE
statement. -
MERGE_MERGE_INTO
Deprecated, for removal: This API element is subject to removal in a future version.AMERGE INTO
clause within anMERGE
statement.This clause surrounds
- the
MERGE INTO
keywords - the table that is being merged
- the
-
MERGE_USING
Deprecated, for removal: This API element is subject to removal in a future version. -
MERGE_ON
Deprecated, for removal: This API element is subject to removal in a future version. -
MERGE_WHEN_MATCHED_THEN_UPDATE
Deprecated, for removal: This API element is subject to removal in a future version.AWHEN MATCHED THEN UPDATE
clause within aMERGE
statement.This clause surrounds
- the
WHEN MATCHED THEN UPDATE
keywords - a
MERGE_SET
clause - a
MERGE_WHERE
clause - a
MERGE_DELETE_WHERE
clause
- the
-
MERGE_SET
Deprecated, for removal: This API element is subject to removal in a future version.ASET
clause within aMERGE_WHEN_MATCHED_THEN_UPDATE
clause within anMERGE
statement.This clause surrounds
- the
SET
keyword - several
MERGE_SET_ASSIGNMENT
clauses
- the
-
MERGE_SET_ASSIGNMENT
Deprecated, for removal: This API element is subject to removal in a future version. -
MERGE_WHERE
Deprecated, for removal: This API element is subject to removal in a future version.AWHERE
clause within aMERGE_WHEN_MATCHED_THEN_UPDATE
clause within aMERGE
statement.This clause surrounds
- the
WHERE
keyword - a
CONDITION
- the
-
MERGE_DELETE_WHERE
Deprecated, for removal: This API element is subject to removal in a future version.ADELETE_WHERE
clause within aMERGE_WHEN_MATCHED_THEN_UPDATE
clause within aMERGE
statement.This clause surrounds
- the
DELETE WHERE
keyword - a
CONDITION
- the
-
MERGE_WHEN_NOT_MATCHED_THEN_INSERT
Deprecated, for removal: This API element is subject to removal in a future version. -
MERGE_VALUES
Deprecated, for removal: This API element is subject to removal in a future version. -
TRUNCATE
Deprecated, for removal: This API element is subject to removal in a future version.A completeTRUNCATE
statement. -
TRUNCATE_TRUNCATE
Deprecated, for removal: This API element is subject to removal in a future version.ATRUNCATE
clause within anTRUNCATE
statement.This clause surrounds
- the
TRUNCATE TABLE
keywords - the table that is being truncated
- the
-
CREATE_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE TABLE
statement. -
CREATE_TABLE_NAME
Deprecated, for removal: This API element is subject to removal in a future version.A view name clause within aCREATE_TABLE
statement.This clause surrounds
- The table name
- The (optional) column names
-
CREATE_TABLE_AS
Deprecated, for removal: This API element is subject to removal in a future version. -
CREATE_TABLE_COLUMNS
Deprecated, for removal: This API element is subject to removal in a future version. -
CREATE_TABLE_CONSTRAINTS
Deprecated, for removal: This API element is subject to removal in a future version. -
CREATE_SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE SCHEMA
statement. -
CREATE_SCHEMA_NAME
Deprecated, for removal: This API element is subject to removal in a future version. -
CREATE_VIEW
Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE VIEW
statement. -
CREATE_VIEW_NAME
Deprecated, for removal: This API element is subject to removal in a future version.A view name clause within aCREATE_VIEW
statement.This clause surrounds
- The view name
- The (optional) column names
-
CREATE_VIEW_AS
Deprecated, for removal: This API element is subject to removal in a future version. -
CREATE_INDEX
Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE INDEX
statement. -
CREATE_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.A completeCREATE SEQUENCE
statement. -
CREATE_SEQUENCE_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within aCREATE_SEQUENCE
statement.This clause surrounds
- the
CREATE SEQUENCE
keywords - the sequence that is being created
- the
-
ALTER_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER SEQUENCE
statement. -
ALTER_SEQUENCE_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within anALTER_SEQUENCE
statement.This clause surrounds
- the
ALTER SEQUENCE
keywords - the sequence that is being altered
- the
-
ALTER_SEQUENCE_RESTART
Deprecated, for removal: This API element is subject to removal in a future version.ARESTART
clause within anALTER_SEQUENCE
statement.This clause surrounds
- the
RESTART
keyword - the
WITH
keyword and the new sequence value, if applicable.
- the
-
ALTER_SEQUENCE_RENAME
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME
clause within anALTER_SEQUENCE
statement.This clause surrounds
- the
RENAME TO
keywords - the new sequence name
- the
-
ALTER_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER TABLE
statement. -
ALTER_TABLE_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anALTER_TABLE
statement.This clause surrounds
- the
ALTER TABLE
keywords - the table that is being altered
- the
-
ALTER_TABLE_RENAME
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_TABLE
statement.This clause surrounds
- the
RENAME TO
keywords - the new table name
- the
-
ALTER_TABLE_RENAME_COLUMN
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME COLUMN
clause within anALTER_TABLE
statement.This clause surrounds
- the
RENAME COLUMN
keywords - the old column name
- the
TO
keyword - the new column name
- the
-
ALTER_TABLE_RENAME_INDEX
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME INDEX
clause within anALTER_TABLE
statement.This clause surrounds
- the
RENAME TO
keywords - the old index name
- the
TO
keyword - the new index name
- the
-
ALTER_TABLE_RENAME_CONSTRAINT
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME CONSTRAINT
clause within anALTER_TABLE
statement.This clause surrounds
- the
RENAME CONSTRAINT
keywords - the old constraint name
- the
TO
keyword - the new constraint name
- the
-
ALTER_TABLE_ADD
Deprecated, for removal: This API element is subject to removal in a future version.AADD
clause within anALTER_TABLE
statement.This clause surrounds
- the
ADD
keywords - the column that is being added
- the
-
ALTER_TABLE_ALTER
Deprecated, for removal: This API element is subject to removal in a future version.AALTER
clause within anALTER_TABLE
statement.This clause surrounds
- the
ALTER
keywords - the column that is being altered
- the
-
ALTER_TABLE_ALTER_DEFAULT
Deprecated, for removal: This API element is subject to removal in a future version.AALTER DEFAULT
clause within anALTER_TABLE
statement.This clause surrounds
- the default expression that is being altered
-
ALTER_TABLE_ALTER_NULL
Deprecated, for removal: This API element is subject to removal in a future version.ASET NULL
orDROP NULL
clause within anALTER_TABLE
statement.This clause surrounds
- the nullability clause being altered
-
ALTER_TABLE_DROP
Deprecated, for removal: This API element is subject to removal in a future version.ADROP
clause within anALTER_TABLE
statement.This clause surrounds
- the
DROP
keywords - the column that is being dropped
- the
-
ALTER_SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER SCHEMA
statement. -
ALTER_SCHEMA_SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version.ASCHEMA
clause within anALTER_SCHEMA
statement.This clause surrounds
- the
ALTER SCHEMA
keywords - the schema that is being altered
- the
-
ALTER_SCHEMA_RENAME
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_SCHEMA
statement.This clause surrounds
- the
RENAME TO
keywords - the new schema name
- the
-
ALTER_VIEW
Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER VIEW
statement. -
ALTER_VIEW_VIEW
Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anALTER_VIEW
statement.This clause surrounds
- the
ALTER VIEW
keywords - the view that is being altered
- the
-
ALTER_VIEW_RENAME
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_VIEW
statement.This clause surrounds
- the
RENAME TO
keywords - the new view name
- the
-
ALTER_INDEX
Deprecated, for removal: This API element is subject to removal in a future version.A completeALTER INDEX
statement. -
ALTER_INDEX_INDEX
Deprecated, for removal: This API element is subject to removal in a future version.AnINDEX
clause within anALTER_INDEX
statement.This clause surrounds
- the
ALTER INDEX
keywords - the index that is being altered
- the
-
ALTER_INDEX_RENAME
Deprecated, for removal: This API element is subject to removal in a future version.ARENAME TO
clause within anALTER_INDEX
statement.This clause surrounds
- the
RENAME TO
keywords - the new index name
- the
-
DROP_SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP SCHEMA
statement. -
DROP_SCHEMA_SCHEMA
Deprecated, for removal: This API element is subject to removal in a future version.ASCHEMA
clause within anDROP_SCHEMA
statement.This clause surrounds
- the
DROP SCHEMA
keywords - the schema that is being dropped
- the
-
DROP_VIEW
Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP VIEW
statement. -
DROP_VIEW_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.AVIEW
clause within anDROP_VIEW
statement.This clause surrounds
- the
DROP VIEW
keywords - the view that is being dropped
- the
-
DROP_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP TABLE
statement. -
DROP_TABLE_TABLE
Deprecated, for removal: This API element is subject to removal in a future version.ATABLE
clause within anDROP_TABLE
statement.This clause surrounds
- the
DROP TABLE
keywords - the table that is being dropped
- the
-
DROP_INDEX
Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP INDEX
statement. -
DROP_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.A completeDROP SEQUENCE
statement. -
DROP_SEQUENCE_SEQUENCE
Deprecated, for removal: This API element is subject to removal in a future version.ASEQUENCE
clause within aDROP_SEQUENCE
statement.This clause surrounds
- the
DROP SEQUENCE
keywords - the sequence that is being dropped
- the
-
GRANT
Deprecated, for removal: This API element is subject to removal in a future version. -
GRANT_PRIVILEGE
Deprecated, for removal: This API element is subject to removal in a future version. -
GRANT_ON
Deprecated, for removal: This API element is subject to removal in a future version. -
GRANT_TO
Deprecated, for removal: This API element is subject to removal in a future version. -
REVOKE
Deprecated, for removal: This API element is subject to removal in a future version. -
REVOKE_PRIVILEGE
Deprecated, for removal: This API element is subject to removal in a future version. -
REVOKE_ON
Deprecated, for removal: This API element is subject to removal in a future version. -
REVOKE_FROM
Deprecated, for removal: This API element is subject to removal in a future version. -
TEMPLATE
Deprecated, for removal: This API element is subject to removal in a future version.A plain SQL template clause. -
CUSTOM
Deprecated, for removal: This API element is subject to removal in a future version.A customQueryPart
clause.
-
-
Method Details
-
values
Deprecated, for removal: This API element is subject to removal in a future version.Returns an array containing the constants of this enum class, in the order they are declared.- Returns:
- an array containing the constants of this enum class, in the order they are declared
-
valueOf
Deprecated, for removal: This API element is subject to removal in a future version.Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)- Parameters:
name
- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException
- if this enum class has no constant with the specified nameNullPointerException
- if the argument is null
-
VisitListener
SPI is deprecated. There are currently no plans of replacing it. Please get in touch if you think this functionality needs to be kept in one way or another: https://github.com/jOOQ/jOOQ/issues/7258