Module org.jooq

Package org.jooq

Enum Class Clause

java.lang.Object

java.lang.Enum<Clause>

org.jooq.Clause

All Implemented Interfaces:

Serializable, Comparable<Clause>, Constable

@Deprecated(forRemoval=true,
            since="3.11")
public enum Clause
extends Enum<Clause>

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.11.0 - [#7258] - This part of the 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

A listing of clauses that emit events 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 Constants

Enum Constant	Description
ALTER_INDEX	Deprecated, for removal: This API element is subject to removal in a future version. A complete ALTER INDEX statement.
ALTER_INDEX_INDEX	Deprecated, for removal: This API element is subject to removal in a future version. An INDEX clause within an ALTER_INDEX statement.
ALTER_INDEX_RENAME	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME TO clause within an ALTER_INDEX statement.
ALTER_SCHEMA	Deprecated, for removal: This API element is subject to removal in a future version. A complete ALTER SCHEMA statement.
ALTER_SCHEMA_RENAME	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME TO clause within an ALTER_SCHEMA statement.
ALTER_SCHEMA_SCHEMA	Deprecated, for removal: This API element is subject to removal in a future version. A SCHEMA clause within an ALTER_SCHEMA statement.
ALTER_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A complete ALTER SEQUENCE statement.
ALTER_SEQUENCE_RENAME	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME clause within an ALTER_SEQUENCE statement.
ALTER_SEQUENCE_RESTART	Deprecated, for removal: This API element is subject to removal in a future version. A RESTART clause within an ALTER_SEQUENCE statement.
ALTER_SEQUENCE_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A SEQUENCE clause within an ALTER_SEQUENCE statement.
ALTER_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A complete ALTER TABLE statement.
ALTER_TABLE_ADD	Deprecated, for removal: This API element is subject to removal in a future version. A ADD clause within an ALTER_TABLE statement.
ALTER_TABLE_ALTER	Deprecated, for removal: This API element is subject to removal in a future version. A ALTER clause within an ALTER_TABLE statement.
ALTER_TABLE_ALTER_DEFAULT	Deprecated, for removal: This API element is subject to removal in a future version. A ALTER DEFAULT clause within an ALTER_TABLE statement.
ALTER_TABLE_ALTER_NULL	Deprecated, for removal: This API element is subject to removal in a future version. A SET NULL or DROP NULL clause within an ALTER_TABLE statement.
ALTER_TABLE_DROP	Deprecated, for removal: This API element is subject to removal in a future version. A DROP clause within an ALTER_TABLE statement.
ALTER_TABLE_RENAME	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME TO clause within an ALTER_TABLE statement.
ALTER_TABLE_RENAME_COLUMN	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME COLUMN clause within an ALTER_TABLE statement.
ALTER_TABLE_RENAME_CONSTRAINT	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME CONSTRAINT clause within an ALTER_TABLE statement.
ALTER_TABLE_RENAME_INDEX	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME INDEX clause within an ALTER_TABLE statement.
ALTER_TABLE_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A TABLE clause within an ALTER_TABLE statement.
ALTER_VIEW	Deprecated, for removal: This API element is subject to removal in a future version. A complete ALTER VIEW statement.
ALTER_VIEW_RENAME	Deprecated, for removal: This API element is subject to removal in a future version. A RENAME TO clause within an ALTER_VIEW statement.
ALTER_VIEW_VIEW	Deprecated, for removal: This API element is subject to removal in a future version. A TABLE clause within an ALTER_VIEW statement.
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.
CONDITION	Deprecated, for removal: This API element is subject to removal in a future version. A condition expression.
CONDITION_AND	Deprecated, for removal: This API element is subject to removal in a future version. A combined condition using AND.
CONDITION_BETWEEN	Deprecated, for removal: This API element is subject to removal in a future version. A BEWEEN condition.
CONDITION_BETWEEN_SYMMETRIC	Deprecated, for removal: This API element is subject to removal in a future version. A BEWEEN SYMMETRIC condition.
CONDITION_COMPARISON	Deprecated, for removal: This API element is subject to removal in a future version.
CONDITION_EXISTS	Deprecated, for removal: This API element is subject to removal in a future version. An EXISTS condition.
CONDITION_IN	Deprecated, for removal: This API element is subject to removal in a future version. An IN condition.
CONDITION_IS_NOT_NULL	Deprecated, for removal: This API element is subject to removal in a future version. A NOT NULL condition.
CONDITION_IS_NULL	Deprecated, for removal: This API element is subject to removal in a future version. A NULL condition.
CONDITION_NOT	Deprecated, for removal: This API element is subject to removal in a future version. A NOT condition.
CONDITION_NOT_BETWEEN	Deprecated, for removal: This API element is subject to removal in a future version. A NOT BEWEEN condition.
CONDITION_NOT_BETWEEN_SYMMETRIC	Deprecated, for removal: This API element is subject to removal in a future version. A NOT BEWEEN SYMMETRIC condition.
CONDITION_NOT_EXISTS	Deprecated, for removal: This API element is subject to removal in a future version. A NOT EXISTS condition.
CONDITION_NOT_IN	Deprecated, for removal: This API element is subject to removal in a future version. A NOT IN condition.
CONDITION_OR	Deprecated, for removal: This API element is subject to removal in a future version. A combined condition using OR.
CONDITION_OVERLAPS	Deprecated, for removal: This API element is subject to removal in a future version. An OVERLAPS condition.
CONDITION_XOR	Deprecated, for removal: This API element is subject to removal in a future version. A combined condition using XOR.
CONSTRAINT	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 complete CREATE INDEX statement.
CREATE_SCHEMA	Deprecated, for removal: This API element is subject to removal in a future version. A complete CREATE SCHEMA statement.
CREATE_SCHEMA_NAME	Deprecated, for removal: This API element is subject to removal in a future version. A view name clause within a CREATE_SCHEMA statement.
CREATE_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A complete CREATE SEQUENCE statement.
CREATE_SEQUENCE_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A SEQUENCE clause within a CREATE_SEQUENCE statement.
CREATE_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A complete CREATE TABLE statement.
CREATE_TABLE_AS	Deprecated, for removal: This API element is subject to removal in a future version. An AS clause within a CREATE_TABLE statement.
CREATE_TABLE_COLUMNS	Deprecated, for removal: This API element is subject to removal in a future version. A column list within a CREATE_TABLE statement.
CREATE_TABLE_CONSTRAINTS	Deprecated, for removal: This API element is subject to removal in a future version. A constraint list within a CREATE_TABLE statement.
CREATE_TABLE_NAME	Deprecated, for removal: This API element is subject to removal in a future version. A view name clause within a CREATE_TABLE statement.
CREATE_VIEW	Deprecated, for removal: This API element is subject to removal in a future version. A complete CREATE VIEW statement.
CREATE_VIEW_AS	Deprecated, for removal: This API element is subject to removal in a future version. An AS clause within a CREATE_VIEW statement.
CREATE_VIEW_NAME	Deprecated, for removal: This API element is subject to removal in a future version. A view name clause within a CREATE_VIEW statement.
CUSTOM	Deprecated, for removal: This API element is subject to removal in a future version. A custom QueryPart clause.
DELETE	Deprecated, for removal: This API element is subject to removal in a future version. A complete DELETE statement.
DELETE_DELETE	Deprecated, for removal: This API element is subject to removal in a future version. A DELETE clause within an DELETE statement.
DELETE_RETURNING	Deprecated, for removal: This API element is subject to removal in a future version. A RETURNING clause within an DELETE statement.
DELETE_WHERE	Deprecated, for removal: This API element is subject to removal in a future version. A WHERE clause within an DELETE statement.
DROP_INDEX	Deprecated, for removal: This API element is subject to removal in a future version. A complete DROP INDEX statement.
DROP_SCHEMA	Deprecated, for removal: This API element is subject to removal in a future version. A complete DROP SCHEMA statement.
DROP_SCHEMA_SCHEMA	Deprecated, for removal: This API element is subject to removal in a future version. A SCHEMA clause within an DROP_SCHEMA statement.
DROP_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A complete DROP SEQUENCE statement.
DROP_SEQUENCE_SEQUENCE	Deprecated, for removal: This API element is subject to removal in a future version. A SEQUENCE clause within a DROP_SEQUENCE statement.
DROP_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A complete DROP TABLE statement.
DROP_TABLE_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A TABLE clause within an DROP_TABLE statement.
DROP_VIEW	Deprecated, for removal: This API element is subject to removal in a future version. A complete DROP VIEW statement.
DROP_VIEW_TABLE	Deprecated, for removal: This API element is subject to removal in a future version. A VIEW clause within an DROP_VIEW statement.
FIELD	Deprecated, for removal: This API element is subject to removal in a future version. A field expression.
FIELD_ALIAS	Deprecated, for removal: This API element is subject to removal in a future version. A field alias declaration.
FIELD_CASE	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.
FIELD_REFERENCE	Deprecated, for removal: This API element is subject to removal in a future version. A physical or aliased field reference.
FIELD_ROW	Deprecated, for removal: This API element is subject to removal in a future version.
FIELD_VALUE	Deprecated, for removal: This API element is subject to removal in a future version.
GRANT	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_PRIVILEGE	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.
INSERT	Deprecated, for removal: This API element is subject to removal in a future version. A complete INSERT statement.
INSERT_INSERT_INTO	Deprecated, for removal: This API element is subject to removal in a future version. The INSERT INTO clause within an INSERT statement.
INSERT_ON_DUPLICATE_KEY_UPDATE	Deprecated, for removal: This API element is subject to removal in a future version. The ON DUPLICATE KEY UPDATE clause within an INSERT statement.
INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT	Deprecated, for removal: This API element is subject to removal in a future version. The ON DUPLICATE KEY UPDATE clause within an INSERT statement.
INSERT_RETURNING	Deprecated, for removal: This API element is subject to removal in a future version. The RETURNING clause within an INSERT statement.
INSERT_SELECT	Deprecated, for removal: This API element is subject to removal in a future version. The SELECT clause within an INSERT statement.
INSERT_VALUES	Deprecated, for removal: This API element is subject to removal in a future version. The VALUES clause within an INSERT statement.
MERGE	Deprecated, for removal: This API element is subject to removal in a future version. A complete MERGE statement.
MERGE_DELETE_WHERE	Deprecated, for removal: This API element is subject to removal in a future version. A DELETE_WHERE clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within a MERGE statement.
MERGE_MERGE_INTO	Deprecated, for removal: This API element is subject to removal in a future version. A MERGE INTO clause within an MERGE statement.
MERGE_ON	Deprecated, for removal: This API element is subject to removal in a future version. An ON clause within a MERGE statement.
MERGE_SET	Deprecated, for removal: This API element is subject to removal in a future version. A SET clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within an MERGE statement.
MERGE_SET_ASSIGNMENT	Deprecated, for removal: This API element is subject to removal in a future version. An assigment within a MERGE_SET clause within an MERGE statement.
MERGE_USING	Deprecated, for removal: This API element is subject to removal in a future version. A USING clause within a MERGE statement.
MERGE_VALUES	Deprecated, for removal: This API element is subject to removal in a future version. A VALUES clause within a MERGE statement.
MERGE_WHEN_MATCHED_THEN_UPDATE	Deprecated, for removal: This API element is subject to removal in a future version. A WHEN MATCHED THEN UPDATE clause within a MERGE statement.
MERGE_WHEN_NOT_MATCHED_THEN_INSERT	Deprecated, for removal: This API element is subject to removal in a future version. A WHEN NOT MATCHED THEN INSERT clause within a MERGE statement.
MERGE_WHERE	Deprecated, for removal: This API element is subject to removal in a future version. A WHERE clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within a MERGE statement.
PRIVILEGE	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_FROM	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_PRIVILEGE	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.
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.
SELECT	Deprecated, for removal: This API element is subject to removal in a future version. A complete SELECT statement or a subselect.
SELECT_CONNECT_BY	Deprecated, for removal: This API element is subject to removal in a future version. A CONNECT BY clause within a SELECT statement or subselect.
SELECT_EXCEPT	Deprecated, for removal: This API element is subject to removal in a future version. A EXCEPT set operation.
SELECT_EXCEPT_ALL	Deprecated, for removal: This API element is subject to removal in a future version. A EXCEPT ALL set operation.
SELECT_FROM	Deprecated, for removal: This API element is subject to removal in a future version. A FROM clause within a SELECT statement or subselect.
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. A HAVING clause within a SELECT statement or subselect.
SELECT_INTERSECT	Deprecated, for removal: This API element is subject to removal in a future version. A INTERSECT set operation.
SELECT_INTERSECT_ALL	Deprecated, for removal: This API element is subject to removal in a future version. A INTERSECT ALL set operation.
SELECT_INTO	Deprecated, for removal: This API element is subject to removal in a future version. A INTO clause within a SELECT statement.
SELECT_ORDER_BY	Deprecated, for removal: This API element is subject to removal in a future version.
SELECT_SELECT	Deprecated, for removal: This API element is subject to removal in a future version. A SELECT clause within a SELECT statement or subselect.
SELECT_START_WITH	Deprecated, for removal: This API element is subject to removal in a future version. A START WITH clause within a SELECT statement or subselect.
SELECT_UNION	Deprecated, for removal: This API element is subject to removal in a future version. A UNION set operation.
SELECT_UNION_ALL	Deprecated, for removal: This API element is subject to removal in a future version. A UNION ALL set operation.
SELECT_WHERE	Deprecated, for removal: This API element is subject to removal in a future version. A WHERE clause within a SELECT statement or subselect.
SELECT_WINDOW	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.
TABLE_ALIAS	Deprecated, for removal: This API element is subject to removal in a future version. A table alias declaration.
TABLE_JOIN	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_CROSS	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_INNER	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_NATURAL_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_ON	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_OUTER_FULL	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_PARTITION_BY	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_STRAIGHT	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_REFERENCE	Deprecated, for removal: This API element is subject to removal in a future version. A physical or aliased table reference.
TABLE_VALUES	Deprecated, for removal: This API element is subject to removal in a future version. A VALUES table constructor
TEMPLATE	Deprecated, for removal: This API element is subject to removal in a future version. A plain SQL template clause.
TRUNCATE	Deprecated, for removal: This API element is subject to removal in a future version. A complete TRUNCATE statement.
TRUNCATE_TRUNCATE	Deprecated, for removal: This API element is subject to removal in a future version. A TRUNCATE clause within an TRUNCATE statement.
UPDATE	Deprecated, for removal: This API element is subject to removal in a future version. A complete UPDATE statement.
UPDATE_FROM	Deprecated, for removal: This API element is subject to removal in a future version. A vendor-specific FROM clause within an UPDATE statement.
UPDATE_RETURNING	Deprecated, for removal: This API element is subject to removal in a future version. A RETURNING clause within an UPDATE statement.
UPDATE_SET	Deprecated, for removal: This API element is subject to removal in a future version. A SET clause within an UPDATE statement.
UPDATE_SET_ASSIGNMENT	Deprecated, for removal: This API element is subject to removal in a future version. An assigment within a UPDATE_SET clause within an UPDATE statement.
UPDATE_UPDATE	Deprecated, for removal: This API element is subject to removal in a future version. An UPDATE clause within an UPDATE statement.
UPDATE_WHERE	Deprecated, for removal: This API element is subject to removal in a future version. A WHERE clause within an UPDATE statement.
USER	Deprecated, for removal: This API element is subject to removal in a future version.
WITH	Deprecated, for removal: This API element is subject to removal in a future version. A WITH clause preceding all sorts of DML statements.

Method Summary

Modifier and Type	Method	Description
static Clause	valueOf(String name)	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.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

USER

public static final Clause USER

Deprecated, for removal: This API element is subject to removal in a future version.

ROLE

public static final Clause ROLE

Deprecated, for removal: This API element is subject to removal in a future version.

PRIVILEGE

public static final Clause PRIVILEGE

Deprecated, for removal: This API element is subject to removal in a future version.

CONSTRAINT

public static final Clause CONSTRAINT

Deprecated, for removal: This API element is subject to removal in a future version.

CATALOG

public static final Clause CATALOG

Deprecated, for removal: This API element is subject to removal in a future version.

CATALOG_REFERENCE

public static final Clause CATALOG_REFERENCE

Deprecated, for removal: This API element is subject to removal in a future version.

SCHEMA

public static final Clause SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

SCHEMA_REFERENCE

public static final Clause SCHEMA_REFERENCE

Deprecated, for removal: This API element is subject to removal in a future version.

SEQUENCE

public static final Clause SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

SEQUENCE_REFERENCE

public static final Clause SEQUENCE_REFERENCE

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE

public static final Clause 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

• SELECT_FROM
• INSERT_INSERT_INTO
• UPDATE_UPDATE
• DELETE_DELETE
• MERGE_MERGE_INTO
• TRUNCATE_TRUNCATE

TABLE_ALIAS

public static final Clause 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 a TABLE_JOIN clause, wrapping another TABLE.

Referenced table aliases emit TABLE_REFERENCE clauses.

TABLE_REFERENCE

public static final Clause 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

public static final Clause TABLE_JOIN

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_INNER

public static final Clause TABLE_JOIN_INNER

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_CROSS

public static final Clause TABLE_JOIN_CROSS

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_NATURAL

public static final Clause TABLE_JOIN_NATURAL

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_OUTER_LEFT

public static final Clause TABLE_JOIN_OUTER_LEFT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_OUTER_RIGHT

public static final Clause TABLE_JOIN_OUTER_RIGHT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_OUTER_FULL

public static final Clause TABLE_JOIN_OUTER_FULL

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_NATURAL_OUTER_LEFT

public static final Clause TABLE_JOIN_NATURAL_OUTER_LEFT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_NATURAL_OUTER_RIGHT

public static final Clause TABLE_JOIN_NATURAL_OUTER_RIGHT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_NATURAL_OUTER_FULL

public static final Clause TABLE_JOIN_NATURAL_OUTER_FULL

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_CROSS_APPLY

public static final Clause TABLE_JOIN_CROSS_APPLY

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_OUTER_APPLY

public static final Clause TABLE_JOIN_OUTER_APPLY

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_SEMI_LEFT

public static final Clause TABLE_JOIN_SEMI_LEFT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_ANTI_LEFT

public static final Clause TABLE_JOIN_ANTI_LEFT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_STRAIGHT

public static final Clause TABLE_JOIN_STRAIGHT

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_ON

public static final Clause TABLE_JOIN_ON

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_USING

public static final Clause TABLE_JOIN_USING

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_JOIN_PARTITION_BY

public static final Clause TABLE_JOIN_PARTITION_BY

Deprecated, for removal: This API element is subject to removal in a future version.

TABLE_VALUES

public static final Clause TABLE_VALUES

Deprecated, for removal: This API element is subject to removal in a future version.

A VALUES table constructor

This clause surrounds a

• a VALUES keyword
• a table constructor with several FIELD_ROW value expressions

FIELD

public static final Clause 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

public static final Clause 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 another FIELD.

Referenced field aliases emit FIELD_REFERENCE clauses.

FIELD_REFERENCE

public static final Clause 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

public static final Clause FIELD_VALUE

Deprecated, for removal: This API element is subject to removal in a future version.

FIELD_CASE

public static final Clause FIELD_CASE

Deprecated, for removal: This API element is subject to removal in a future version.

FIELD_ROW

public static final Clause FIELD_ROW

Deprecated, for removal: This API element is subject to removal in a future version.

FIELD_FUNCTION

public static final Clause FIELD_FUNCTION

Deprecated, for removal: This API element is subject to removal in a future version.

CONDITION

public static final Clause CONDITION

Deprecated, for removal: This API element is subject to removal in a future version.

A condition expression.

CONDITION_IS_NULL

public static final Clause CONDITION_IS_NULL

Deprecated, for removal: This API element is subject to removal in a future version.

A NULL condition.

This clause surrounds a FIELD.

CONDITION_IS_NOT_NULL

public static final Clause CONDITION_IS_NOT_NULL

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT NULL condition.

This clause surrounds a FIELD.

CONDITION_COMPARISON

public static final Clause CONDITION_COMPARISON

Deprecated, for removal: This API element is subject to removal in a future version.

CONDITION_BETWEEN

public static final Clause CONDITION_BETWEEN

Deprecated, for removal: This API element is subject to removal in a future version.

A BEWEEN condition.

This clause surrounds three FIELD clauses.

CONDITION_BETWEEN_SYMMETRIC

public static final Clause CONDITION_BETWEEN_SYMMETRIC

Deprecated, for removal: This API element is subject to removal in a future version.

A BEWEEN SYMMETRIC condition.

This clause surrounds three FIELD clauses.

CONDITION_NOT_BETWEEN

public static final Clause CONDITION_NOT_BETWEEN

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT BEWEEN condition.

This clause surrounds three FIELD clauses.

CONDITION_NOT_BETWEEN_SYMMETRIC

public static final Clause CONDITION_NOT_BETWEEN_SYMMETRIC

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT BEWEEN SYMMETRIC condition.

This clause surrounds three FIELD clauses.

CONDITION_OVERLAPS

public static final Clause CONDITION_OVERLAPS

Deprecated, for removal: This API element is subject to removal in a future version.

An OVERLAPS condition.

This clause surrounds two FIELD clauses.

CONDITION_AND

public static final Clause CONDITION_AND

Deprecated, for removal: This API element is subject to removal in a future version.

A combined condition using AND.

This clause surrounds several CONDITION clauses.

CONDITION_OR

public static final Clause CONDITION_OR

Deprecated, for removal: This API element is subject to removal in a future version.

A combined condition using OR.

This clause surrounds several CONDITION clauses.

CONDITION_XOR

public static final Clause CONDITION_XOR

Deprecated, for removal: This API element is subject to removal in a future version.

A combined condition using XOR.

This clause surrounds several CONDITION clauses.

CONDITION_NOT

public static final Clause CONDITION_NOT

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT condition.

This clause surrounds a CONDITION clause.

CONDITION_IN

public static final Clause CONDITION_IN

Deprecated, for removal: This API element is subject to removal in a future version.

An IN condition.

This clause surrounds two or more FIELD clauses.

CONDITION_NOT_IN

public static final Clause CONDITION_NOT_IN

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT IN condition.

This clause surrounds two or more FIELD clauses.

CONDITION_EXISTS

public static final Clause CONDITION_EXISTS

Deprecated, for removal: This API element is subject to removal in a future version.

An EXISTS condition.

This clause surrounds a SELECT clause.

CONDITION_NOT_EXISTS

public static final Clause CONDITION_NOT_EXISTS

Deprecated, for removal: This API element is subject to removal in a future version.

A NOT EXISTS condition.

This clause surrounds a SELECT clause.

WITH

public static final Clause WITH

Deprecated, for removal: This API element is subject to removal in a future version.

A WITH clause preceding all sorts of DML statements.

SELECT

public static final Clause SELECT

Deprecated, for removal: This API element is subject to removal in a future version.

A complete SELECT statement or a subselect.

This clause surrounds a complete SELECT statement, a subselect, or a set operation, such as

• SELECT_UNION
• SELECT_UNION_ALL
• SELECT_INTERSECT
• SELECT_EXCEPT

SELECT_UNION

public static final Clause SELECT_UNION

Deprecated, for removal: This API element is subject to removal in a future version.

A UNION set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a UNION set operation.

SELECT_UNION_ALL

public static final Clause SELECT_UNION_ALL

Deprecated, for removal: This API element is subject to removal in a future version.

A UNION ALL set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a UNION ALL set operation.

SELECT_INTERSECT

public static final Clause SELECT_INTERSECT

Deprecated, for removal: This API element is subject to removal in a future version.

A INTERSECT set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a INTERSECT set operation.

SELECT_INTERSECT_ALL

public static final Clause SELECT_INTERSECT_ALL

Deprecated, for removal: This API element is subject to removal in a future version.

A INTERSECT ALL set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a INTERSECT ALL set operation.

SELECT_EXCEPT

public static final Clause SELECT_EXCEPT

Deprecated, for removal: This API element is subject to removal in a future version.

A EXCEPT set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a EXCEPT set operation.

SELECT_EXCEPT_ALL

public static final Clause SELECT_EXCEPT_ALL

Deprecated, for removal: This API element is subject to removal in a future version.

A EXCEPT ALL set operation.

This clause surrounds two or more subselects (see SELECT) concatenating them using a EXCEPT ALL set operation.

SELECT_SELECT

public static final Clause SELECT_SELECT

Deprecated, for removal: This API element is subject to removal in a future version.

A SELECT clause within a SELECT statement or subselect.

This clause surrounds

• the SELECT keyword
• Oracle style hints
• the T-SQL style TOP … START AT clause
• the select field list

SELECT_INTO

public static final Clause SELECT_INTO

Deprecated, for removal: This API element is subject to removal in a future version.

A INTO clause within a SELECT statement.

This clause surrounds

• the INTO keyword
• the table reference

See TABLE and related clauses for possible table references.

See Also:

• TABLE

SELECT_FROM

public static final Clause SELECT_FROM

Deprecated, for removal: This API element is subject to removal in a future version.

A FROM clause within a SELECT statement or subselect.

This clause surrounds

• the FROM keyword
• the table reference list

See TABLE and related clauses for possible table references.

See Also:

• TABLE

SELECT_WHERE

public static final Clause SELECT_WHERE

Deprecated, for removal: This API element is subject to removal in a future version.

A WHERE clause within a SELECT statement or subselect.

This clause surrounds

• the WHERE keyword
• a CONDITION

See CONDITION and related clauses for possible conditions

See Also:

• CONDITION

SELECT_START_WITH

public static final Clause SELECT_START_WITH

Deprecated, for removal: This API element is subject to removal in a future version.

A START WITH clause within a SELECT statement or subselect.

This clause surrounds

• the START WITH keywords
• a CONDITION

See CONDITION and related clauses for possible conditions

See Also:

• CONDITION

SELECT_CONNECT_BY

public static final Clause SELECT_CONNECT_BY

Deprecated, for removal: This API element is subject to removal in a future version.

A CONNECT BY clause within a SELECT statement or subselect.

This clause surrounds

• the CONNECT BY keywords
• a CONDITION

See CONDITION and related clauses for possible conditions

See Also:

• CONDITION

SELECT_GROUP_BY

public static final Clause SELECT_GROUP_BY

Deprecated, for removal: This API element is subject to removal in a future version.

SELECT_HAVING

public static final Clause SELECT_HAVING

Deprecated, for removal: This API element is subject to removal in a future version.

A HAVING clause within a SELECT statement or subselect.

This clause surrounds

• the HAVING keyword
• a CONDITION

See CONDITION and related clauses for possible conditions

See Also:

• CONDITION

SELECT_WINDOW

public static final Clause SELECT_WINDOW

Deprecated, for removal: This API element is subject to removal in a future version.

SELECT_ORDER_BY

public static final Clause SELECT_ORDER_BY

Deprecated, for removal: This API element is subject to removal in a future version.

INSERT

public static final Clause INSERT

Deprecated, for removal: This API element is subject to removal in a future version.

A complete INSERT statement.

INSERT_INSERT_INTO

public static final Clause INSERT_INSERT_INTO

Deprecated, for removal: This API element is subject to removal in a future version.

The INSERT INTO clause within an INSERT statement.

This clause surrounds

• the INSERT INTO keywords
• the table that is being inserted

INSERT_VALUES

public static final Clause INSERT_VALUES

Deprecated, for removal: This API element is subject to removal in a future version.

The VALUES clause within an INSERT statement.

This clause surrounds

• the VALUES keyword
• several FIELD_ROW clauses

INSERT_SELECT

public static final Clause INSERT_SELECT

Deprecated, for removal: This API element is subject to removal in a future version.

The SELECT clause within an INSERT statement.

This clause surrounds a SELECT clause.

INSERT_ON_DUPLICATE_KEY_UPDATE

public static final Clause INSERT_ON_DUPLICATE_KEY_UPDATE

Deprecated, for removal: This API element is subject to removal in a future version.

The ON DUPLICATE KEY UPDATE clause within an INSERT 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

INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT

public static final Clause INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT

Deprecated, for removal: This API element is subject to removal in a future version.

The ON DUPLICATE KEY UPDATE clause within an INSERT statement.

This clause surrounds two FIELD clauses.

INSERT_RETURNING

public static final Clause INSERT_RETURNING

Deprecated, for removal: This API element is subject to removal in a future version.

The RETURNING clause within an INSERT statement.

This clause surrounds

• the RETURNING keyword
• several FIELD clauses

UPDATE

public static final Clause UPDATE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete UPDATE statement.

UPDATE_UPDATE

public static final Clause UPDATE_UPDATE

Deprecated, for removal: This API element is subject to removal in a future version.

An UPDATE clause within an UPDATE statement.

This clause surrounds

• the UPDATE keyword
• the table that is being updated

UPDATE_SET

public static final Clause UPDATE_SET

Deprecated, for removal: This API element is subject to removal in a future version.

A SET clause within an UPDATE statement.

This clause surrounds

• the SET keyword
• one or several assignments: UPDATE_SET_ASSIGNMENT

UPDATE_SET_ASSIGNMENT

public static final Clause UPDATE_SET_ASSIGNMENT

Deprecated, for removal: This API element is subject to removal in a future version.

An assigment within a UPDATE_SET clause within an UPDATE statement.

This clause surrounds

• a FIELD receiving the assignment
• an assigment operator
• a FIELD being assigned

UPDATE_FROM

public static final Clause UPDATE_FROM

Deprecated, for removal: This API element is subject to removal in a future version.

A vendor-specific FROM clause within an UPDATE statement.

This clause surrounds

• the FROM keyword
• the table reference list

See TABLE and related clauses for possible table references.

UPDATE_WHERE

public static final Clause UPDATE_WHERE

Deprecated, for removal: This API element is subject to removal in a future version.

A WHERE clause within an UPDATE statement.

This clause surrounds

• the WHERE keyword
• a CONDITION

UPDATE_RETURNING

public static final Clause UPDATE_RETURNING

Deprecated, for removal: This API element is subject to removal in a future version.

A RETURNING clause within an UPDATE statement.

This clause surrounds

• the RETURNING keyword
• several FIELD clauses

DELETE

public static final Clause DELETE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DELETE statement.

DELETE_DELETE

public static final Clause DELETE_DELETE

Deprecated, for removal: This API element is subject to removal in a future version.

A DELETE clause within an DELETE statement.

This clause surrounds

• the DELETE FROM keywords
• the table that is being deleted

DELETE_WHERE

public static final Clause DELETE_WHERE

Deprecated, for removal: This API element is subject to removal in a future version.

A WHERE clause within an DELETE statement.

This clause surrounds

• the WHERE keyword
• a CONDITION

DELETE_RETURNING

public static final Clause DELETE_RETURNING

Deprecated, for removal: This API element is subject to removal in a future version.

A RETURNING clause within an DELETE statement.

This clause surrounds

• the RETURNING keyword
• several FIELD clauses

MERGE

public static final Clause MERGE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete MERGE statement.

MERGE_MERGE_INTO

public static final Clause MERGE_MERGE_INTO

Deprecated, for removal: This API element is subject to removal in a future version.

A MERGE INTO clause within an MERGE statement.

This clause surrounds

• the MERGE INTO keywords
• the table that is being merged

MERGE_USING

public static final Clause MERGE_USING

Deprecated, for removal: This API element is subject to removal in a future version.

A USING clause within a MERGE statement.

This clause surrounds

• the USING keyword
• a TABLE

MERGE_ON

public static final Clause MERGE_ON

Deprecated, for removal: This API element is subject to removal in a future version.

An ON clause within a MERGE statement.

This clause surrounds

• the ON keyword
• a CONDITION

MERGE_WHEN_MATCHED_THEN_UPDATE

public static final Clause MERGE_WHEN_MATCHED_THEN_UPDATE

Deprecated, for removal: This API element is subject to removal in a future version.

A WHEN MATCHED THEN UPDATE clause within a MERGE statement.

This clause surrounds

• the WHEN MATCHED THEN UPDATE keywords
• a MERGE_SET clause
• a MERGE_WHERE clause
• a MERGE_DELETE_WHERE clause

MERGE_SET

public static final Clause MERGE_SET

Deprecated, for removal: This API element is subject to removal in a future version.

A SET clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within an MERGE statement.

This clause surrounds

• the SET keyword
• several MERGE_SET_ASSIGNMENT clauses

MERGE_SET_ASSIGNMENT

public static final Clause MERGE_SET_ASSIGNMENT

Deprecated, for removal: This API element is subject to removal in a future version.

An assigment within a MERGE_SET clause within an MERGE statement.

This clause surrounds

• a FIELD receiving the assignment
• an assigment operator
• a FIELD being assigned

MERGE_WHERE

public static final Clause MERGE_WHERE

Deprecated, for removal: This API element is subject to removal in a future version.

A WHERE clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within a MERGE statement.

This clause surrounds

• the WHERE keyword
• a CONDITION

MERGE_DELETE_WHERE

public static final Clause MERGE_DELETE_WHERE

Deprecated, for removal: This API element is subject to removal in a future version.

A DELETE_WHERE clause within a MERGE_WHEN_MATCHED_THEN_UPDATE clause within a MERGE statement.

This clause surrounds

• the DELETE WHERE keyword
• a CONDITION

MERGE_WHEN_NOT_MATCHED_THEN_INSERT

public static final Clause MERGE_WHEN_NOT_MATCHED_THEN_INSERT

Deprecated, for removal: This API element is subject to removal in a future version.

A WHEN NOT MATCHED THEN INSERT clause within a MERGE statement.

This clause surrounds

• the WHEN NOT MATCHED THEN INSERT keywords
• several FIELD clauses

MERGE_VALUES

public static final Clause MERGE_VALUES

Deprecated, for removal: This API element is subject to removal in a future version.

A VALUES clause within a MERGE statement.

This clause surrounds

• the VALUES keyword
• several FIELD_ROW clauses

TRUNCATE

public static final Clause TRUNCATE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete TRUNCATE statement.

TRUNCATE_TRUNCATE

public static final Clause TRUNCATE_TRUNCATE

Deprecated, for removal: This API element is subject to removal in a future version.

A TRUNCATE clause within an TRUNCATE statement.

This clause surrounds

• the TRUNCATE TABLE keywords
• the table that is being truncated

CREATE_TABLE

public static final Clause CREATE_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete CREATE TABLE statement.

CREATE_TABLE_NAME

public static final Clause CREATE_TABLE_NAME

Deprecated, for removal: This API element is subject to removal in a future version.

A view name clause within a CREATE_TABLE statement.

This clause surrounds

• The table name
• The (optional) column names

CREATE_TABLE_AS

public static final Clause CREATE_TABLE_AS

Deprecated, for removal: This API element is subject to removal in a future version.

An AS clause within a CREATE_TABLE statement.

This clause surrounds

• The AS keyword
• The select code

CREATE_TABLE_COLUMNS

public static final Clause CREATE_TABLE_COLUMNS

Deprecated, for removal: This API element is subject to removal in a future version.

A column list within a CREATE_TABLE statement.

This clause surrounds

• The column list

CREATE_TABLE_CONSTRAINTS

public static final Clause CREATE_TABLE_CONSTRAINTS

Deprecated, for removal: This API element is subject to removal in a future version.

A constraint list within a CREATE_TABLE statement.

This clause surrounds

• The constraint list

CREATE_SCHEMA

public static final Clause CREATE_SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

A complete CREATE SCHEMA statement.

CREATE_SCHEMA_NAME

public static final Clause CREATE_SCHEMA_NAME

Deprecated, for removal: This API element is subject to removal in a future version.

A view name clause within a CREATE_SCHEMA statement.

This clause surrounds

• The schema name

CREATE_VIEW

public static final Clause CREATE_VIEW

Deprecated, for removal: This API element is subject to removal in a future version.

A complete CREATE VIEW statement.

CREATE_VIEW_NAME

public static final Clause CREATE_VIEW_NAME

Deprecated, for removal: This API element is subject to removal in a future version.

A view name clause within a CREATE_VIEW statement.

This clause surrounds

• The view name
• The (optional) column names

CREATE_VIEW_AS

public static final Clause CREATE_VIEW_AS

Deprecated, for removal: This API element is subject to removal in a future version.

An AS clause within a CREATE_VIEW statement.

This clause surrounds

• The AS keyword
• The view code

CREATE_INDEX

public static final Clause CREATE_INDEX

Deprecated, for removal: This API element is subject to removal in a future version.

A complete CREATE INDEX statement.

CREATE_SEQUENCE

public static final Clause CREATE_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete CREATE SEQUENCE statement.

CREATE_SEQUENCE_SEQUENCE

public static final Clause CREATE_SEQUENCE_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A SEQUENCE clause within a CREATE_SEQUENCE statement.

This clause surrounds

• the CREATE SEQUENCE keywords
• the sequence that is being created

ALTER_SEQUENCE

public static final Clause ALTER_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete ALTER SEQUENCE statement.

ALTER_SEQUENCE_SEQUENCE

public static final Clause ALTER_SEQUENCE_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A SEQUENCE clause within an ALTER_SEQUENCE statement.

This clause surrounds

• the ALTER SEQUENCE keywords
• the sequence that is being altered

ALTER_SEQUENCE_RESTART

public static final Clause ALTER_SEQUENCE_RESTART

Deprecated, for removal: This API element is subject to removal in a future version.

A RESTART clause within an ALTER_SEQUENCE statement.

This clause surrounds

• the RESTART keyword
• the WITH keyword and the new sequence value, if applicable.

ALTER_SEQUENCE_RENAME

public static final Clause ALTER_SEQUENCE_RENAME

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME clause within an ALTER_SEQUENCE statement.

This clause surrounds

• the RENAME TO keywords
• the new sequence name

ALTER_TABLE

public static final Clause ALTER_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete ALTER TABLE statement.

ALTER_TABLE_TABLE

public static final Clause ALTER_TABLE_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A TABLE clause within an ALTER_TABLE statement.

This clause surrounds

• the ALTER TABLE keywords
• the table that is being altered

ALTER_TABLE_RENAME

public static final Clause ALTER_TABLE_RENAME

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME TO clause within an ALTER_TABLE statement.

This clause surrounds

• the RENAME TO keywords
• the new table name

ALTER_TABLE_RENAME_COLUMN

public static final Clause ALTER_TABLE_RENAME_COLUMN

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME COLUMN clause within an ALTER_TABLE statement.

This clause surrounds

• the RENAME COLUMN keywords
• the old column name
• the TO keyword
• the new column name

ALTER_TABLE_RENAME_INDEX

public static final Clause ALTER_TABLE_RENAME_INDEX

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME INDEX clause within an ALTER_TABLE statement.

This clause surrounds

• the RENAME TO keywords
• the old index name
• the TO keyword
• the new index name

ALTER_TABLE_RENAME_CONSTRAINT

public static final Clause ALTER_TABLE_RENAME_CONSTRAINT

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME CONSTRAINT clause within an ALTER_TABLE statement.

This clause surrounds

• the RENAME CONSTRAINT keywords
• the old constraint name
• the TO keyword
• the new constraint name

ALTER_TABLE_ADD

public static final Clause ALTER_TABLE_ADD

Deprecated, for removal: This API element is subject to removal in a future version.

A ADD clause within an ALTER_TABLE statement.

This clause surrounds

• the ADD keywords
• the column that is being added

ALTER_TABLE_ALTER

public static final Clause ALTER_TABLE_ALTER

Deprecated, for removal: This API element is subject to removal in a future version.

A ALTER clause within an ALTER_TABLE statement.

This clause surrounds

• the ALTER keywords
• the column that is being altered

ALTER_TABLE_ALTER_DEFAULT

public static final Clause ALTER_TABLE_ALTER_DEFAULT

Deprecated, for removal: This API element is subject to removal in a future version.

A ALTER DEFAULT clause within an ALTER_TABLE statement.

This clause surrounds

• the default expression that is being altered

ALTER_TABLE_ALTER_NULL

public static final Clause ALTER_TABLE_ALTER_NULL

Deprecated, for removal: This API element is subject to removal in a future version.

A SET NULL or DROP NULL clause within an ALTER_TABLE statement.

This clause surrounds

• the nullability clause being altered

ALTER_TABLE_DROP

public static final Clause ALTER_TABLE_DROP

Deprecated, for removal: This API element is subject to removal in a future version.

A DROP clause within an ALTER_TABLE statement.

This clause surrounds

• the DROP keywords
• the column that is being dropped

ALTER_SCHEMA

public static final Clause ALTER_SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

A complete ALTER SCHEMA statement.

ALTER_SCHEMA_SCHEMA

public static final Clause ALTER_SCHEMA_SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

A SCHEMA clause within an ALTER_SCHEMA statement.

This clause surrounds

• the ALTER SCHEMA keywords
• the schema that is being altered

ALTER_SCHEMA_RENAME

public static final Clause ALTER_SCHEMA_RENAME

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME TO clause within an ALTER_SCHEMA statement.

This clause surrounds

• the RENAME TO keywords
• the new schema name

ALTER_VIEW

public static final Clause ALTER_VIEW

Deprecated, for removal: This API element is subject to removal in a future version.

A complete ALTER VIEW statement.

ALTER_VIEW_VIEW

public static final Clause ALTER_VIEW_VIEW

Deprecated, for removal: This API element is subject to removal in a future version.

A TABLE clause within an ALTER_VIEW statement.

This clause surrounds

• the ALTER VIEW keywords
• the view that is being altered

ALTER_VIEW_RENAME

public static final Clause ALTER_VIEW_RENAME

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME TO clause within an ALTER_VIEW statement.

This clause surrounds

• the RENAME TO keywords
• the new view name

ALTER_INDEX

public static final Clause ALTER_INDEX

Deprecated, for removal: This API element is subject to removal in a future version.

A complete ALTER INDEX statement.

ALTER_INDEX_INDEX

public static final Clause ALTER_INDEX_INDEX

Deprecated, for removal: This API element is subject to removal in a future version.

An INDEX clause within an ALTER_INDEX statement.

This clause surrounds

• the ALTER INDEX keywords
• the index that is being altered

ALTER_INDEX_RENAME

public static final Clause ALTER_INDEX_RENAME

Deprecated, for removal: This API element is subject to removal in a future version.

A RENAME TO clause within an ALTER_INDEX statement.

This clause surrounds

• the RENAME TO keywords
• the new index name

DROP_SCHEMA

public static final Clause DROP_SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DROP SCHEMA statement.

DROP_SCHEMA_SCHEMA

public static final Clause DROP_SCHEMA_SCHEMA

Deprecated, for removal: This API element is subject to removal in a future version.

A SCHEMA clause within an DROP_SCHEMA statement.

This clause surrounds

• the DROP SCHEMA keywords
• the schema that is being dropped

DROP_VIEW

public static final Clause DROP_VIEW

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DROP VIEW statement.

DROP_VIEW_TABLE

public static final Clause DROP_VIEW_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A VIEW clause within an DROP_VIEW statement.

This clause surrounds

• the DROP VIEW keywords
• the view that is being dropped

DROP_TABLE

public static final Clause DROP_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DROP TABLE statement.

DROP_TABLE_TABLE

public static final Clause DROP_TABLE_TABLE

Deprecated, for removal: This API element is subject to removal in a future version.

A TABLE clause within an DROP_TABLE statement.

This clause surrounds

• the DROP TABLE keywords
• the table that is being dropped

DROP_INDEX

public static final Clause DROP_INDEX

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DROP INDEX statement.

DROP_SEQUENCE

public static final Clause DROP_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A complete DROP SEQUENCE statement.

DROP_SEQUENCE_SEQUENCE

public static final Clause DROP_SEQUENCE_SEQUENCE

Deprecated, for removal: This API element is subject to removal in a future version.

A SEQUENCE clause within a DROP_SEQUENCE statement.

This clause surrounds

• the DROP SEQUENCE keywords
• the sequence that is being dropped

GRANT

public static final Clause GRANT

Deprecated, for removal: This API element is subject to removal in a future version.

GRANT_PRIVILEGE

public static final Clause GRANT_PRIVILEGE

Deprecated, for removal: This API element is subject to removal in a future version.

GRANT_ON

public static final Clause GRANT_ON

Deprecated, for removal: This API element is subject to removal in a future version.

GRANT_TO

public static final Clause GRANT_TO

Deprecated, for removal: This API element is subject to removal in a future version.

REVOKE

public static final Clause REVOKE

Deprecated, for removal: This API element is subject to removal in a future version.

REVOKE_PRIVILEGE

public static final Clause REVOKE_PRIVILEGE

Deprecated, for removal: This API element is subject to removal in a future version.

REVOKE_ON

public static final Clause REVOKE_ON

Deprecated, for removal: This API element is subject to removal in a future version.

REVOKE_FROM

public static final Clause REVOKE_FROM

Deprecated, for removal: This API element is subject to removal in a future version.

TEMPLATE

public static final Clause TEMPLATE

Deprecated, for removal: This API element is subject to removal in a future version.

A plain SQL template clause.

CUSTOM

public static final Clause CUSTOM

Deprecated, for removal: This API element is subject to removal in a future version.

A custom QueryPart clause.

Method Details

values

public 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.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static Clause valueOf(String name)

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 name

NullPointerException - if the argument is null