Module org.jooq
Package org.jooq

Enum Class 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
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete ALTER INDEX statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An INDEX clause within an ALTER_INDEX statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME TO clause within an ALTER_INDEX statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete ALTER SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME TO clause within an ALTER_SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SCHEMA clause within an ALTER_SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete ALTER SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME clause within an ALTER_SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RESTART clause within an ALTER_SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SEQUENCE clause within an ALTER_SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete ALTER TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A ADD clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A ALTER clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A ALTER DEFAULT clause within an ALTER_TABLE statement.
    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.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A DROP clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME TO clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME COLUMN clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME CONSTRAINT clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME INDEX clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A TABLE clause within an ALTER_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete ALTER VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RENAME TO clause within an ALTER_VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A TABLE clause within an ALTER_VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A condition expression.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A combined condition using AND.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A BEWEEN condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A BEWEEN SYMMETRIC condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    An EXISTS condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An IN condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT NULL condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NULL condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT BEWEEN condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT BEWEEN SYMMETRIC condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT EXISTS condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A NOT IN condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A combined condition using OR.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An OVERLAPS condition.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A combined condition using XOR.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete CREATE INDEX statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete CREATE SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A view name clause within a CREATE_SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete CREATE SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SEQUENCE clause within a CREATE_SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete CREATE TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An AS clause within a CREATE_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A column list within a CREATE_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A constraint list within a CREATE_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A view name clause within a CREATE_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete CREATE VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An AS clause within a CREATE_VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A view name clause within a CREATE_VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A custom QueryPart clause.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DELETE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A DELETE clause within an DELETE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RETURNING clause within an DELETE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A WHERE clause within an DELETE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DROP INDEX statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DROP SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SCHEMA clause within an DROP_SCHEMA statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DROP SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SEQUENCE clause within a DROP_SEQUENCE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DROP TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A TABLE clause within an DROP_TABLE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete DROP VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A VIEW clause within an DROP_VIEW statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A field expression.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A field alias declaration.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A physical or aliased field reference.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The INSERT INTO clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The ON DUPLICATE KEY UPDATE clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The ON DUPLICATE KEY UPDATE clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The RETURNING clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The SELECT clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    The VALUES clause within an INSERT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete MERGE statement.
    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.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A MERGE INTO clause within an MERGE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An ON clause within a MERGE statement.
    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.
    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.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A USING clause within a MERGE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A VALUES clause within a MERGE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A WHEN MATCHED THEN UPDATE clause within a MERGE statement.
    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.
    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.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete SELECT statement or a subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A CONNECT BY clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A EXCEPT set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A EXCEPT ALL set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A FROM clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A HAVING clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A INTERSECT set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A INTERSECT ALL set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A INTO clause within a SELECT statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SELECT clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A START WITH clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A UNION set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A UNION ALL set operation.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A WHERE clause within a SELECT statement or subselect.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A table expression.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A table alias declaration.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A physical or aliased table reference.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A VALUES table constructor
    Deprecated, for removal: This API element is subject to removal in a future version.
    A plain SQL template clause.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete TRUNCATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A TRUNCATE clause within an TRUNCATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A complete UPDATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A vendor-specific FROM clause within an UPDATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A RETURNING clause within an UPDATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A SET clause within an UPDATE statement.
    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.
    Deprecated, for removal: This API element is subject to removal in a future version.
    An UPDATE clause within an UPDATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
    A WHERE clause within an UPDATE statement.
    Deprecated, for removal: This API element is subject to removal in a future version.
     
    Deprecated, for removal: This API element is subject to removal in a future version.
    A WITH clause preceding all sorts of DML statements.
  • Method Summary

    Modifier and Type
    Method
    Description
    static Clause
    Deprecated, for removal: This API element is subject to removal in a future version.
    Returns the enum constant of this class with the specified name.
    static Clause[]
    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.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

    • 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

      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:
    • 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:
    • 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

      See CONDITION and related clauses for possible conditions

      See Also:
    • 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

      See CONDITION and related clauses for possible conditions

      See Also:
    • 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

      See CONDITION and related clauses for possible conditions

      See Also:
    • 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

      See CONDITION and related clauses for possible conditions

      See Also:
    • 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.

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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

    • 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