Module org.jooq
Package org.jooq

Enum Clause

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

        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

        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

        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

        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_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

      • 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

      • 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

      • 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

      • 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

      • 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_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​(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:
        IllegalArgumentException - if this enum type has no constant with the specified name
        NullPointerException - if the argument is null