Clause (jOOQ 3.7.0 API)

java.lang.Object
- java.lang.Enum<Clause>
- - org.jooq.Clause

All Implemented Interfaces:

Serializable, Comparable<Clause>
```
public enum Clause
extends Enum<Clause>
```
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.

Enum Constant Summary

Enum Constants
Enum Constant and Description
`ALTER_SEQUENCE` A complete `ALTER SEQUENCE` statement.
`ALTER_SEQUENCE_RESTART` A `RESTART` clause within an `ALTER_SEQUENCE` statement.
`ALTER_SEQUENCE_SEQUENCE` A `SEQUENCE` clause within an `ALTER_SEQUENCE` statement.
`ALTER_TABLE` A complete `ALTER TABLE` statement.
`ALTER_TABLE_ADD` A `ADD` clause within an `ALTER_TABLE` statement.
`ALTER_TABLE_ALTER` A `ALTER` clause within an `ALTER_TABLE` statement.
`ALTER_TABLE_ALTER_DEFAULT` A `ALTER DEFAULT` clause within an `ALTER_TABLE` statement.
`ALTER_TABLE_DROP` A `DROP` clause within an `ALTER_TABLE` statement.
`ALTER_TABLE_TABLE` A `TABLE` clause within an `ALTER_TABLE` statement.
`CATALOG`
`CATALOG_REFERENCE`
`CONDITION` A condition expression.
`CONDITION_AND` A combined condition using `AND`.
`CONDITION_BETWEEN` A `BEWEEN` condition.
`CONDITION_BETWEEN_SYMMETRIC` A `BEWEEN SYMMETRIC` condition.
`CONDITION_COMPARISON`
`CONDITION_EXISTS` An `EXISTS` condition.
`CONDITION_IN` An `IN` condition.
`CONDITION_IS_NOT_NULL` A `NOT NULL` condition.
`CONDITION_IS_NULL` A `NULL` condition.
`CONDITION_NOT` A `NOT` condition.
`CONDITION_NOT_BETWEEN` A `NOT BEWEEN` condition.
`CONDITION_NOT_BETWEEN_SYMMETRIC` A `NOT BEWEEN SYMMETRIC` condition.
`CONDITION_NOT_EXISTS` A `NOT EXISTS` condition.
`CONDITION_NOT_IN` A `NOT IN` condition.
`CONDITION_OR` A combined condition using `OR`.
`CONDITION_OVERLAPS` An `OVERLAPS` condition.
`CONSTRAINT`
`CREATE_INDEX` A complete `CREATE INDEX` statement.
`CREATE_SEQUENCE` A complete `CREATE SEQUENCE` statement.
`CREATE_SEQUENCE_SEQUENCE` A `SEQUENCE` clause within a `CREATE_SEQUENCE` statement.
`CREATE_TABLE` A complete `CREATE TABLE` statement.
`CREATE_TABLE_AS` An `AS` clause within a `CREATE_TABLE` statement.
`CREATE_TABLE_COLUMNS` A column list within a `CREATE_TABLE` statement.
`CREATE_TABLE_NAME` A view name clause within a `CREATE_TABLE` statement.
`CREATE_VIEW` A complete `CREATE VIEW` statement.
`CREATE_VIEW_AS` An `AS` clause within a `CREATE_VIEW` statement.
`CREATE_VIEW_NAME` A view name clause within a `CREATE_VIEW` statement.
`CUSTOM` A custom `QueryPart` clause.
`DELETE` A complete `DELETE` statement.
`DELETE_DELETE` A `DELETE` clause within an `DELETE` statement.
`DELETE_RETURNING` A `RETURNING` clause within an `DELETE` statement.
`DELETE_WHERE` A `WHERE` clause within an `DELETE` statement.
`DROP_INDEX` A complete `DROP INDEX` statement.
`DROP_SEQUENCE` A complete `DROP SEQUENCE` statement.
`DROP_SEQUENCE_SEQUENCE` A `SEQUENCE` clause within a `DROP_SEQUENCE` statement.
`DROP_TABLE` A complete `DROP TABLE` statement.
`DROP_TABLE_TABLE` A `TABLE` clause within an `DROP_TABLE` statement.
`DROP_VIEW` A complete `DROP VIEW` statement.
`DROP_VIEW_TABLE` A `VIEW` clause within an `DROP_VIEW` statement.
`FIELD` A field expression.
`FIELD_ALIAS` A field alias declaration.
`FIELD_CASE`
`FIELD_FUNCTION`
`FIELD_REFERENCE` A physical or aliased field reference.
`FIELD_ROW`
`FIELD_VALUE`
`INSERT` A complete `INSERT` statement.
`INSERT_INSERT_INTO` The `INSERT INTO` clause within an `INSERT` statement.
`INSERT_ON_DUPLICATE_KEY_UPDATE` The `ON DUPLICATE KEY UPDATE` clause within an `INSERT` statement.
`INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT` The `ON DUPLICATE KEY UPDATE` clause within an `INSERT` statement.
`INSERT_RETURNING` The `RETURNING` clause within an `INSERT` statement.
`INSERT_SELECT` The `SELECT` clause within an `INSERT` statement.
`INSERT_VALUES` The `VALUES` clause within an `INSERT` statement.
`MERGE` A complete `MERGE` statement.
`MERGE_DELETE_WHERE` A `DELETE_WHERE` clause within a `MERGE_WHEN_MATCHED_THEN_UPDATE` clause within a `MERGE` statement.
`MERGE_MERGE_INTO` A `MERGE INTO` clause within an `MERGE` statement.
`MERGE_ON` An `ON` clause within a `MERGE` statement.
`MERGE_SET` A `SET` clause within a `MERGE_WHEN_MATCHED_THEN_UPDATE` clause within an `MERGE` statement.
`MERGE_SET_ASSIGNMENT` An assigment within a `MERGE_SET` clause within an `MERGE` statement.
`MERGE_USING` A `USING` clause within a `MERGE` statement.
`MERGE_VALUES` A `VALUES` clause within a `MERGE` statement.
`MERGE_WHEN_MATCHED_THEN_UPDATE` A `WHEN MATCHED THEN UPDATE` clause within a `MERGE` statement.
`MERGE_WHEN_NOT_MATCHED_THEN_INSERT` A `WHEN NOT MATCHED THEN INSERT` clause within a `MERGE` statement.
`MERGE_WHERE` A `WHERE` clause within a `MERGE_WHEN_MATCHED_THEN_UPDATE` clause within a `MERGE` statement.
`SCHEMA`
`SCHEMA_REFERENCE`
`SELECT` A complete `SELECT` statement or a subselect.
`SELECT_CONNECT_BY` A `CONNECT BY` clause within a `SELECT` statement or subselect.
`SELECT_EXCEPT` A `EXCEPT` set operation.
`SELECT_EXCEPT_ALL` A `EXCEPT ALL` set operation.
`SELECT_FROM` A `FROM` clause within a `SELECT` statement or subselect.
`SELECT_GROUP_BY`
`SELECT_HAVING` A `HAVING` clause within a `SELECT` statement or subselect.
`SELECT_INTERSECT` A `INTERSECT` set operation.
`SELECT_INTERSECT_ALL` A `INTERSECT ALL` set operation.
`SELECT_INTO` A `INTO` clause within a `SELECT` statement.
`SELECT_ORDER_BY`
`SELECT_SELECT` A `SELECT` clause within a `SELECT` statement or subselect.
`SELECT_START_WITH` A `START WITH` clause within a `SELECT` statement or subselect.
`SELECT_UNION` A `UNION` set operation.
`SELECT_UNION_ALL` A `UNION ALL` set operation.
`SELECT_WHERE` A `WHERE` clause within a `SELECT` statement or subselect.
`SELECT_WINDOW`
`SEQUENCE`
`SEQUENCE_REFERENCE`
`TABLE` A table expression.
`TABLE_ALIAS` A table alias declaration.
`TABLE_JOIN`
`TABLE_JOIN_ANTI_LEFT`
`TABLE_JOIN_CROSS`
`TABLE_JOIN_CROSS_APPLY`
`TABLE_JOIN_INNER`
`TABLE_JOIN_NATURAL`
`TABLE_JOIN_NATURAL_OUTER_LEFT`
`TABLE_JOIN_NATURAL_OUTER_RIGHT`
`TABLE_JOIN_ON`
`TABLE_JOIN_OUTER_APPLY`
`TABLE_JOIN_OUTER_FULL`
`TABLE_JOIN_OUTER_LEFT`
`TABLE_JOIN_OUTER_RIGHT`
`TABLE_JOIN_PARTITION_BY`
`TABLE_JOIN_SEMI_LEFT`
`TABLE_JOIN_USING`
`TABLE_REFERENCE` A physical or aliased table reference.
`TABLE_VALUES` A `VALUES` table constructor This clause surrounds a a `VALUES` keyword a table constructor with several `FIELD_ROW` value expressions
`TEMPLATE` A plain SQL template clause.
`TRUNCATE` A complete `TRUNCATE` statement.
`TRUNCATE_TRUNCATE` A `TRUNCATE` clause within an `TRUNCATE` statement.
`UPDATE` A complete `UPDATE` statement.
`UPDATE_FROM` A vendor-specific `FROM` clause within an `UPDATE` statement.
`UPDATE_RETURNING` A `RETURNING` clause within an `UPDATE` statement.
`UPDATE_SET` A `SET` clause within an `UPDATE` statement.
`UPDATE_SET_ASSIGNMENT` An assigment within a `UPDATE_SET` clause within an `UPDATE` statement.
`UPDATE_UPDATE` An `UPDATE` clause within an `UPDATE` statement.
`UPDATE_WHERE` A `WHERE` clause within an `UPDATE` statement.
`WITH` A `WITH` clause preceding all sorts of DML statements.

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static Clause`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static Clause[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - CONSTRAINT
```
public static final Clause CONSTRAINT
```
  - CATALOG
```
public static final Clause CATALOG
```
  - CATALOG_REFERENCE
```
public static final Clause CATALOG_REFERENCE
```
  - SCHEMA
```
public static final Clause SCHEMA
```
  - SCHEMA_REFERENCE
```
public static final Clause SCHEMA_REFERENCE
```
  - SEQUENCE
```
public static final Clause SEQUENCE
```
  - SEQUENCE_REFERENCE
```
public static final Clause SEQUENCE_REFERENCE
```
  - TABLE
```
public static final Clause TABLE
```
    A table expression.
    This clause surrounds an actual table expression as it can be encountered in
  - TABLE_ALIAS
```
public static final Clause TABLE_ALIAS
```
    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
```
    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
```
  - TABLE_JOIN_INNER
```
public static final Clause TABLE_JOIN_INNER
```
  - TABLE_JOIN_CROSS
```
public static final Clause TABLE_JOIN_CROSS
```
  - TABLE_JOIN_NATURAL
```
public static final Clause TABLE_JOIN_NATURAL
```
  - TABLE_JOIN_OUTER_LEFT
```
public static final Clause TABLE_JOIN_OUTER_LEFT
```
  - TABLE_JOIN_OUTER_RIGHT
```
public static final Clause TABLE_JOIN_OUTER_RIGHT
```
  - TABLE_JOIN_OUTER_FULL
```
public static final Clause TABLE_JOIN_OUTER_FULL
```
  - TABLE_JOIN_NATURAL_OUTER_LEFT
```
public static final Clause TABLE_JOIN_NATURAL_OUTER_LEFT
```
  - TABLE_JOIN_NATURAL_OUTER_RIGHT
```
public static final Clause TABLE_JOIN_NATURAL_OUTER_RIGHT
```
  - TABLE_JOIN_CROSS_APPLY
```
public static final Clause TABLE_JOIN_CROSS_APPLY
```
  - TABLE_JOIN_OUTER_APPLY
```
public static final Clause TABLE_JOIN_OUTER_APPLY
```
  - TABLE_JOIN_SEMI_LEFT
```
public static final Clause TABLE_JOIN_SEMI_LEFT
```
  - TABLE_JOIN_ANTI_LEFT
```
public static final Clause TABLE_JOIN_ANTI_LEFT
```
  - TABLE_JOIN_ON
```
public static final Clause TABLE_JOIN_ON
```
  - TABLE_JOIN_USING
```
public static final Clause TABLE_JOIN_USING
```
  - TABLE_JOIN_PARTITION_BY
```
public static final Clause TABLE_JOIN_PARTITION_BY
```
  - TABLE_VALUES
```
public static final Clause TABLE_VALUES
```
    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
```
    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
```
    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
```
    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
```
  - FIELD_CASE
```
public static final Clause FIELD_CASE
```
  - FIELD_ROW
```
public static final Clause FIELD_ROW
```
  - FIELD_FUNCTION
```
public static final Clause FIELD_FUNCTION
```
  - CONDITION
```
public static final Clause CONDITION
```
    A condition expression.
  - CONDITION_IS_NULL
```
public static final Clause CONDITION_IS_NULL
```
    A NULL condition.
    This clause surrounds a FIELD.
  - CONDITION_IS_NOT_NULL
```
public static final Clause CONDITION_IS_NOT_NULL
```
    A NOT NULL condition.
    This clause surrounds a FIELD.
  - CONDITION_COMPARISON
```
public static final Clause CONDITION_COMPARISON
```
  - CONDITION_BETWEEN
```
public static final Clause CONDITION_BETWEEN
```
    A BEWEEN condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_BETWEEN_SYMMETRIC
```
public static final Clause CONDITION_BETWEEN_SYMMETRIC
```
    A BEWEEN SYMMETRIC condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_NOT_BETWEEN
```
public static final Clause CONDITION_NOT_BETWEEN
```
    A NOT BEWEEN condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_NOT_BETWEEN_SYMMETRIC
```
public static final Clause CONDITION_NOT_BETWEEN_SYMMETRIC
```
    A NOT BEWEEN SYMMETRIC condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_OVERLAPS
```
public static final Clause CONDITION_OVERLAPS
```
    An OVERLAPS condition.
    This clause surrounds two FIELD clauses.
  - CONDITION_AND
```
public static final Clause CONDITION_AND
```
    A combined condition using AND.
    This clause surrounds several CONDITION clauses.
  - CONDITION_OR
```
public static final Clause CONDITION_OR
```
    A combined condition using OR.
    This clause surrounds several CONDITION clauses.
  - CONDITION_NOT
```
public static final Clause CONDITION_NOT
```
    A NOT condition.
    This clause surrounds a CONDITION clause.
  - CONDITION_IN
```
public static final Clause CONDITION_IN
```
    An IN condition.
    This clause surrounds two or more FIELD clauses.
  - CONDITION_NOT_IN
```
public static final Clause CONDITION_NOT_IN
```
    A NOT IN condition.
    This clause surrounds two or more FIELD clauses.
  - CONDITION_EXISTS
```
public static final Clause CONDITION_EXISTS
```
    An EXISTS condition.
    This clause surrounds a SELECT clause.
  - CONDITION_NOT_EXISTS
```
public static final Clause CONDITION_NOT_EXISTS
```
    A NOT EXISTS condition.
    This clause surrounds a SELECT clause.
  - WITH
```
public static final Clause WITH
```
    A WITH clause preceding all sorts of DML statements.
  - SELECT
```
public static final Clause SELECT
```
    A complete SELECT statement or a subselect.
    This clause surrounds a complete SELECT statement, a subselect, or a set operation, such as
  - SELECT_UNION
```
public static final Clause SELECT_UNION
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
  - SELECT_HAVING
```
public static final Clause SELECT_HAVING
```
    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
```
  - SELECT_ORDER_BY
```
public static final Clause SELECT_ORDER_BY
```
  - INSERT
```
public static final Clause INSERT
```
    A complete INSERT statement.
  - INSERT_INSERT_INTO
```
public static final Clause INSERT_INSERT_INTO
```
    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
```
    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
```
    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
```
    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
```
    The ON DUPLICATE KEY UPDATE clause within an INSERT statement.
    This clause surrounds two FIELD clauses.
  - INSERT_RETURNING
```
public static final Clause INSERT_RETURNING
```
    The RETURNING clause within an INSERT statement.
    This clause surrounds
    - the RETURNING keyword
    - several FIELD clauses
  - UPDATE
```
public static final Clause UPDATE
```
    A complete UPDATE statement.
  - UPDATE_UPDATE
```
public static final Clause UPDATE_UPDATE
```
    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
```
    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
```
    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
```
    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
```
    A WHERE clause within an UPDATE statement.
    This clause surrounds
    - the WHERE keyword
    - a CONDITION
  - UPDATE_RETURNING
```
public static final Clause UPDATE_RETURNING
```
    A RETURNING clause within an UPDATE statement.
    This clause surrounds
    - the RETURNING keyword
    - several FIELD clauses
  - DELETE
```
public static final Clause DELETE
```
    A complete DELETE statement.
  - DELETE_DELETE
```
public static final Clause DELETE_DELETE
```
    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
```
    A WHERE clause within an DELETE statement.
    This clause surrounds
    - the WHERE keyword
    - a CONDITION
  - DELETE_RETURNING
```
public static final Clause DELETE_RETURNING
```
    A RETURNING clause within an DELETE statement.
    This clause surrounds
    - the RETURNING keyword
    - several FIELD clauses
  - MERGE
```
public static final Clause MERGE
```
    A complete MERGE statement.
  - MERGE_MERGE_INTO
```
public static final Clause MERGE_MERGE_INTO
```
    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
```
    A USING clause within a MERGE statement.
    This clause surrounds
    - the USING keyword
    - a TABLE
  - MERGE_ON
```
public static final Clause MERGE_ON
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    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
```
    A VALUES clause within a MERGE statement.
    This clause surrounds
    - the VALUES keyword
    - several FIELD_ROW clauses
  - TRUNCATE
```
public static final Clause TRUNCATE
```
    A complete TRUNCATE statement.
  - TRUNCATE_TRUNCATE
```
public static final Clause TRUNCATE_TRUNCATE
```
    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
```
    A complete CREATE TABLE statement.
  - CREATE_TABLE_NAME
```
public static final Clause CREATE_TABLE_NAME
```
    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
```
    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
```
    A column list within a CREATE_TABLE statement.
    This clause surrounds
    - The parentheses
    - The column list
  - CREATE_VIEW
```
public static final Clause CREATE_VIEW
```
    A complete CREATE VIEW statement.
  - CREATE_VIEW_NAME
```
public static final Clause CREATE_VIEW_NAME
```
    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
```
    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
```
    A complete CREATE INDEX statement.
  - CREATE_SEQUENCE
```
public static final Clause CREATE_SEQUENCE
```
    A complete CREATE SEQUENCE statement.
  - CREATE_SEQUENCE_SEQUENCE
```
public static final Clause CREATE_SEQUENCE_SEQUENCE
```
    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
```
    A complete ALTER SEQUENCE statement.
  - ALTER_SEQUENCE_SEQUENCE
```
public static final Clause ALTER_SEQUENCE_SEQUENCE
```
    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
```
    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_TABLE
```
public static final Clause ALTER_TABLE
```
    A complete ALTER TABLE statement.
  - ALTER_TABLE_TABLE
```
public static final Clause ALTER_TABLE_TABLE
```
    A TABLE clause within an ALTER_TABLE statement.
    This clause surrounds
    - the ALTER TABLE keywords
    - the table that is being altered
  - ALTER_TABLE_ADD
```
public static final Clause ALTER_TABLE_ADD
```
    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
```
    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
```
    A ALTER DEFAULT clause within an ALTER_TABLE statement.
    This clause surrounds
    - the default expression that is being altered
  - ALTER_TABLE_DROP
```
public static final Clause ALTER_TABLE_DROP
```
    A DROP clause within an ALTER_TABLE statement.
    This clause surrounds
    - the DROP keywords
    - the column that is being dropped
  - DROP_VIEW
```
public static final Clause DROP_VIEW
```
    A complete DROP VIEW statement.
  - DROP_VIEW_TABLE
```
public static final Clause DROP_VIEW_TABLE
```
    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
```
    A complete DROP TABLE statement.
  - DROP_TABLE_TABLE
```
public static final Clause DROP_TABLE_TABLE
```
    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
```
    A complete DROP INDEX statement.
  - DROP_SEQUENCE
```
public static final Clause DROP_SEQUENCE
```
    A complete DROP SEQUENCE statement.
  - DROP_SEQUENCE_SEQUENCE
```
public static final Clause DROP_SEQUENCE_SEQUENCE
```
    A SEQUENCE clause within a DROP_SEQUENCE statement.
    This clause surrounds
    - the DROP SEQUENCE keywords
    - the sequence that is being dropped
  - TEMPLATE
```
public static final Clause TEMPLATE
```
    A plain SQL template clause.
  - CUSTOM
```
public static final Clause CUSTOM
```
    A custom QueryPart clause.
- Method Detail
  - values
```
public static Clause[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (Clause c : Clause.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static Clause valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (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 type has no constant with the specified name
    
    NullPointerException - if the argument is null

Enum Clause

Disclaimer

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

CONSTRAINT

CATALOG

CATALOG_REFERENCE

SCHEMA

SCHEMA_REFERENCE

SEQUENCE

SEQUENCE_REFERENCE

TABLE

TABLE_ALIAS

TABLE_REFERENCE

TABLE_JOIN

TABLE_JOIN_INNER

TABLE_JOIN_CROSS

TABLE_JOIN_NATURAL

TABLE_JOIN_OUTER_LEFT

TABLE_JOIN_OUTER_RIGHT

TABLE_JOIN_OUTER_FULL

TABLE_JOIN_NATURAL_OUTER_LEFT

TABLE_JOIN_NATURAL_OUTER_RIGHT

TABLE_JOIN_CROSS_APPLY

TABLE_JOIN_OUTER_APPLY

TABLE_JOIN_SEMI_LEFT

TABLE_JOIN_ANTI_LEFT

TABLE_JOIN_ON

TABLE_JOIN_USING

TABLE_JOIN_PARTITION_BY

TABLE_VALUES

FIELD

FIELD_ALIAS

FIELD_REFERENCE

FIELD_VALUE

FIELD_CASE

FIELD_ROW

FIELD_FUNCTION

CONDITION

CONDITION_IS_NULL

CONDITION_IS_NOT_NULL

CONDITION_COMPARISON

CONDITION_BETWEEN

CONDITION_BETWEEN_SYMMETRIC

CONDITION_NOT_BETWEEN

CONDITION_NOT_BETWEEN_SYMMETRIC

CONDITION_OVERLAPS

CONDITION_AND

CONDITION_OR

CONDITION_NOT

CONDITION_IN

CONDITION_NOT_IN

CONDITION_EXISTS

CONDITION_NOT_EXISTS

WITH

SELECT

SELECT_UNION

SELECT_UNION_ALL

SELECT_INTERSECT

SELECT_INTERSECT_ALL

SELECT_EXCEPT

SELECT_EXCEPT_ALL

SELECT_SELECT

SELECT_INTO

SELECT_FROM

SELECT_WHERE

SELECT_START_WITH

SELECT_CONNECT_BY

SELECT_GROUP_BY

SELECT_HAVING

SELECT_WINDOW

SELECT_ORDER_BY

INSERT

INSERT_INSERT_INTO

INSERT_VALUES

INSERT_SELECT

INSERT_ON_DUPLICATE_KEY_UPDATE