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

All Implemented Interfaces:

java.io.Serializable, java.lang.Comparable<Clause>
```
@Deprecated
public enum Clause
extends java.lang.Enum<Clause>
```
Deprecated.
- 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.

Enum Constant Summary

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

Method Summary

All Methods Static Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`static Clause`	`valueOf(java.lang.String name)`	Deprecated. Returns the enum constant of this type with the specified name.
`static Clause[]`	`values()`	Deprecated. 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
  - USER
```
public static final Clause USER
```
    Deprecated.
  - ROLE
```
public static final Clause ROLE
```
    Deprecated.
  - PRIVILEGE
```
public static final Clause PRIVILEGE
```
    Deprecated.
  - CONSTRAINT
```
public static final Clause CONSTRAINT
```
    Deprecated.
  - CATALOG
```
public static final Clause CATALOG
```
    Deprecated.
  - CATALOG_REFERENCE
```
public static final Clause CATALOG_REFERENCE
```
    Deprecated.
  - SCHEMA
```
public static final Clause SCHEMA
```
    Deprecated.
  - SCHEMA_REFERENCE
```
public static final Clause SCHEMA_REFERENCE
```
    Deprecated.
  - SEQUENCE
```
public static final Clause SEQUENCE
```
    Deprecated.
  - SEQUENCE_REFERENCE
```
public static final Clause SEQUENCE_REFERENCE
```
    Deprecated.
  - TABLE
```
public static final Clause TABLE
```
    Deprecated.
    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.
    
    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.
    
    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.
  - TABLE_JOIN_INNER
```
public static final Clause TABLE_JOIN_INNER
```
    Deprecated.
  - TABLE_JOIN_CROSS
```
public static final Clause TABLE_JOIN_CROSS
```
    Deprecated.
  - TABLE_JOIN_NATURAL
```
public static final Clause TABLE_JOIN_NATURAL
```
    Deprecated.
  - TABLE_JOIN_OUTER_LEFT
```
public static final Clause TABLE_JOIN_OUTER_LEFT
```
    Deprecated.
  - TABLE_JOIN_OUTER_RIGHT
```
public static final Clause TABLE_JOIN_OUTER_RIGHT
```
    Deprecated.
  - TABLE_JOIN_OUTER_FULL
```
public static final Clause TABLE_JOIN_OUTER_FULL
```
    Deprecated.
  - TABLE_JOIN_NATURAL_OUTER_LEFT
```
public static final Clause TABLE_JOIN_NATURAL_OUTER_LEFT
```
    Deprecated.
  - TABLE_JOIN_NATURAL_OUTER_RIGHT
```
public static final Clause TABLE_JOIN_NATURAL_OUTER_RIGHT
```
    Deprecated.
  - TABLE_JOIN_NATURAL_OUTER_FULL
```
public static final Clause TABLE_JOIN_NATURAL_OUTER_FULL
```
    Deprecated.
  - TABLE_JOIN_CROSS_APPLY
```
public static final Clause TABLE_JOIN_CROSS_APPLY
```
    Deprecated.
  - TABLE_JOIN_OUTER_APPLY
```
public static final Clause TABLE_JOIN_OUTER_APPLY
```
    Deprecated.
  - TABLE_JOIN_SEMI_LEFT
```
public static final Clause TABLE_JOIN_SEMI_LEFT
```
    Deprecated.
  - TABLE_JOIN_ANTI_LEFT
```
public static final Clause TABLE_JOIN_ANTI_LEFT
```
    Deprecated.
  - TABLE_JOIN_STRAIGHT
```
public static final Clause TABLE_JOIN_STRAIGHT
```
    Deprecated.
  - TABLE_JOIN_ON
```
public static final Clause TABLE_JOIN_ON
```
    Deprecated.
  - TABLE_JOIN_USING
```
public static final Clause TABLE_JOIN_USING
```
    Deprecated.
  - TABLE_JOIN_PARTITION_BY
```
public static final Clause TABLE_JOIN_PARTITION_BY
```
    Deprecated.
  - TABLE_VALUES
```
public static final Clause TABLE_VALUES
```
    Deprecated.
    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.
    
    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.
    
    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.
    
    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.
  - FIELD_CASE
```
public static final Clause FIELD_CASE
```
    Deprecated.
  - FIELD_ROW
```
public static final Clause FIELD_ROW
```
    Deprecated.
  - FIELD_FUNCTION
```
public static final Clause FIELD_FUNCTION
```
    Deprecated.
  - CONDITION
```
public static final Clause CONDITION
```
    Deprecated.
    
    A condition expression.
  - CONDITION_IS_NULL
```
public static final Clause CONDITION_IS_NULL
```
    Deprecated.
    
    A NULL condition.
    This clause surrounds a FIELD.
  - CONDITION_IS_NOT_NULL
```
public static final Clause CONDITION_IS_NOT_NULL
```
    Deprecated.
    
    A NOT NULL condition.
    This clause surrounds a FIELD.
  - CONDITION_COMPARISON
```
public static final Clause CONDITION_COMPARISON
```
    Deprecated.
  - CONDITION_BETWEEN
```
public static final Clause CONDITION_BETWEEN
```
    Deprecated.
    
    A BEWEEN condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_BETWEEN_SYMMETRIC
```
public static final Clause CONDITION_BETWEEN_SYMMETRIC
```
    Deprecated.
    
    A BEWEEN SYMMETRIC condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_NOT_BETWEEN
```
public static final Clause CONDITION_NOT_BETWEEN
```
    Deprecated.
    
    A NOT BEWEEN condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_NOT_BETWEEN_SYMMETRIC
```
public static final Clause CONDITION_NOT_BETWEEN_SYMMETRIC
```
    Deprecated.
    
    A NOT BEWEEN SYMMETRIC condition.
    This clause surrounds three FIELD clauses.
  - CONDITION_OVERLAPS
```
public static final Clause CONDITION_OVERLAPS
```
    Deprecated.
    
    An OVERLAPS condition.
    This clause surrounds two FIELD clauses.
  - CONDITION_AND
```
public static final Clause CONDITION_AND
```
    Deprecated.
    
    A combined condition using AND.
    This clause surrounds several CONDITION clauses.
  - CONDITION_OR
```
public static final Clause CONDITION_OR
```
    Deprecated.
    
    A combined condition using OR.
    This clause surrounds several CONDITION clauses.
  - CONDITION_NOT
```
public static final Clause CONDITION_NOT
```
    Deprecated.
    
    A NOT condition.
    This clause surrounds a CONDITION clause.
  - CONDITION_IN
```
public static final Clause CONDITION_IN
```
    Deprecated.
    
    An IN condition.
    This clause surrounds two or more FIELD clauses.
  - CONDITION_NOT_IN
```
public static final Clause CONDITION_NOT_IN
```
    Deprecated.
    
    A NOT IN condition.
    This clause surrounds two or more FIELD clauses.
  - CONDITION_EXISTS
```
public static final Clause CONDITION_EXISTS
```
    Deprecated.
    
    An EXISTS condition.
    This clause surrounds a SELECT clause.
  - CONDITION_NOT_EXISTS
```
public static final Clause CONDITION_NOT_EXISTS
```
    Deprecated.
    
    A NOT EXISTS condition.
    This clause surrounds a SELECT clause.
  - WITH
```
public static final Clause WITH
```
    Deprecated.
    
    A WITH clause preceding all sorts of DML statements.
  - SELECT
```
public static final Clause SELECT
```
    Deprecated.
    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.
    
    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.
    
    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.
    
    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.
    
    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.
    
    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.
    
    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.
    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.
    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.
    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.
    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.
    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.
    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.
  - SELECT_HAVING
```
public static final Clause SELECT_HAVING
```
    Deprecated.
    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.
  - SELECT_ORDER_BY
```
public static final Clause SELECT_ORDER_BY
```
    Deprecated.
  - INSERT
```
public static final Clause INSERT
```
    Deprecated.
    
    A complete INSERT statement.
  - INSERT_INSERT_INTO
```
public static final Clause INSERT_INSERT_INTO
```
    Deprecated.
    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.
    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.
    
    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.
    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.
    
    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.
    The RETURNING clause within an INSERT statement.
    This clause surrounds
    
    the RETURNING keyword
    
    several FIELD clauses
  - UPDATE
```
public static final Clause UPDATE
```
    Deprecated.
    
    A complete UPDATE statement.
  - UPDATE_UPDATE
```
public static final Clause UPDATE_UPDATE
```
    Deprecated.
    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.
    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.
    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.
    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.
    A WHERE clause within an UPDATE statement.
    This clause surrounds
    
    the WHERE keyword
    
    a CONDITION
  - UPDATE_RETURNING
```
public static final Clause UPDATE_RETURNING
```
    Deprecated.
    A RETURNING clause within an UPDATE statement.
    This clause surrounds
    
    the RETURNING keyword
    
    several FIELD clauses
  - DELETE
```
public static final Clause DELETE
```
    Deprecated.
    
    A complete DELETE statement.
  - DELETE_DELETE
```
public static final Clause DELETE_DELETE
```
    Deprecated.
    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.
    A WHERE clause within an DELETE statement.
    This clause surrounds
    
    the WHERE keyword
    
    a CONDITION
  - DELETE_RETURNING
```
public static final Clause DELETE_RETURNING
```
    Deprecated.
    A RETURNING clause within an DELETE statement.
    This clause surrounds
    
    the RETURNING keyword
    
    several FIELD clauses
  - MERGE
```
public static final Clause MERGE
```
    Deprecated.
    
    A complete MERGE statement.
  - MERGE_MERGE_INTO
```
public static final Clause MERGE_MERGE_INTO
```
    Deprecated.
    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.
    A USING clause within a MERGE statement.
    This clause surrounds
    
    the USING keyword
    
    a TABLE
  - MERGE_ON
```
public static final Clause MERGE_ON
```
    Deprecated.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    A VALUES clause within a MERGE statement.
    This clause surrounds
    
    the VALUES keyword
    
    several FIELD_ROW clauses
  - TRUNCATE
```
public static final Clause TRUNCATE
```
    Deprecated.
    
    A complete TRUNCATE statement.
  - TRUNCATE_TRUNCATE
```
public static final Clause TRUNCATE_TRUNCATE
```
    Deprecated.
    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.
    
    A complete CREATE TABLE statement.
  - CREATE_TABLE_NAME
```
public static final Clause CREATE_TABLE_NAME
```
    Deprecated.
    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.
    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.
    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.
    A constraint list within a CREATE_TABLE statement.
    This clause surrounds
    
    The constraint list
  - CREATE_SCHEMA
```
public static final Clause CREATE_SCHEMA
```
    Deprecated.
    
    A complete CREATE SCHEMA statement.
  - CREATE_SCHEMA_NAME
```
public static final Clause CREATE_SCHEMA_NAME
```
    Deprecated.
    A view name clause within a CREATE_SCHEMA statement.
    This clause surrounds
    
    The schema name
  - CREATE_VIEW
```
public static final Clause CREATE_VIEW
```
    Deprecated.
    
    A complete CREATE VIEW statement.
  - CREATE_VIEW_NAME
```
public static final Clause CREATE_VIEW_NAME
```
    Deprecated.
    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.
    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.
    
    A complete CREATE INDEX statement.
  - CREATE_SEQUENCE
```
public static final Clause CREATE_SEQUENCE
```
    Deprecated.
    
    A complete CREATE SEQUENCE statement.
  - CREATE_SEQUENCE_SEQUENCE
```
public static final Clause CREATE_SEQUENCE_SEQUENCE
```
    Deprecated.
    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.
    
    A complete ALTER SEQUENCE statement.
  - ALTER_SEQUENCE_SEQUENCE
```
public static final Clause ALTER_SEQUENCE_SEQUENCE
```
    Deprecated.
    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.
    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.
    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.
    
    A complete ALTER TABLE statement.
  - ALTER_TABLE_TABLE
```
public static final Clause ALTER_TABLE_TABLE
```
    Deprecated.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    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.
    
    A complete ALTER SCHEMA statement.
  - ALTER_SCHEMA_SCHEMA
```
public static final Clause ALTER_SCHEMA_SCHEMA
```
    Deprecated.
    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.
    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.
    
    A complete ALTER VIEW statement.
  - ALTER_VIEW_VIEW
```
public static final Clause ALTER_VIEW_VIEW
```
    Deprecated.
    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.
    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.
    
    A complete ALTER INDEX statement.
  - ALTER_INDEX_INDEX
```
public static final Clause ALTER_INDEX_INDEX
```
    Deprecated.
    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.
    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.
    
    A complete DROP SCHEMA statement.
  - DROP_SCHEMA_SCHEMA
```
public static final Clause DROP_SCHEMA_SCHEMA
```
    Deprecated.
    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.
    
    A complete DROP VIEW statement.
  - DROP_VIEW_TABLE
```
public static final Clause DROP_VIEW_TABLE
```
    Deprecated.
    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.
    
    A complete DROP TABLE statement.
  - DROP_TABLE_TABLE
```
public static final Clause DROP_TABLE_TABLE
```
    Deprecated.
    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.
    
    A complete DROP INDEX statement.
  - DROP_SEQUENCE
```
public static final Clause DROP_SEQUENCE
```
    Deprecated.
    
    A complete DROP SEQUENCE statement.
  - DROP_SEQUENCE_SEQUENCE
```
public static final Clause DROP_SEQUENCE_SEQUENCE
```
    Deprecated.
    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.
  - GRANT_PRIVILEGE
```
public static final Clause GRANT_PRIVILEGE
```
    Deprecated.
  - GRANT_ON
```
public static final Clause GRANT_ON
```
    Deprecated.
  - GRANT_TO
```
public static final Clause GRANT_TO
```
    Deprecated.
  - REVOKE
```
public static final Clause REVOKE
```
    Deprecated.
  - REVOKE_PRIVILEGE
```
public static final Clause REVOKE_PRIVILEGE
```
    Deprecated.
  - REVOKE_ON
```
public static final Clause REVOKE_ON
```
    Deprecated.
  - REVOKE_FROM
```
public static final Clause REVOKE_FROM
```
    Deprecated.
  - TEMPLATE
```
public static final Clause TEMPLATE
```
    Deprecated.
    
    A plain SQL template clause.
  - CUSTOM
```
public static final Clause CUSTOM
```
    Deprecated.
    
    A custom QueryPart clause.
- Method Detail
  - values
```
public static Clause[] values()
```
    Deprecated.
    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(java.lang.String name)
```
    Deprecated.
    
    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:
    
    java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
    
    java.lang.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

USER

ROLE

PRIVILEGE

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_NATURAL_OUTER_FULL

TABLE_JOIN_CROSS_APPLY

TABLE_JOIN_OUTER_APPLY

TABLE_JOIN_SEMI_LEFT

TABLE_JOIN_ANTI_LEFT

TABLE_JOIN_STRAIGHT

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