Top Description Fields Constructors Methods
org.jooq

public final Enum Clause

extends Enum<Clause>
Class Inheritance
Annotations
@Deprecated
forRemoval:true
since:3.11

Deprecated

for removal since 3.11.

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

Field Summary

Modifier and TypeField and Description
public static final Clause
ALTER_INDEX

A complete ALTER INDEX statement.

public static final Clause
ALTER_INDEX_INDEX

An INDEX clause within an ALTER_INDEX statement.

public static final Clause
ALTER_INDEX_RENAME

A RENAME TO clause within an ALTER_INDEX statement.

public static final Clause
ALTER_SCHEMA

A complete ALTER SCHEMA statement.

public static final Clause
ALTER_SCHEMA_RENAME

A RENAME TO clause within an ALTER_SCHEMA statement.

public static final Clause
ALTER_SCHEMA_SCHEMA

A SCHEMA clause within an ALTER_SCHEMA statement.

public static final Clause
ALTER_SEQUENCE

A complete ALTER SEQUENCE statement.

public static final Clause
ALTER_SEQUENCE_RENAME

A RENAME clause within an ALTER_SEQUENCE statement.

public static final Clause
ALTER_SEQUENCE_RESTART

A RESTART clause within an ALTER_SEQUENCE statement.

public static final Clause
ALTER_SEQUENCE_SEQUENCE

A SEQUENCE clause within an ALTER_SEQUENCE statement.

public static final Clause
ALTER_TABLE

A complete ALTER TABLE statement.

public static final Clause
ALTER_TABLE_ADD

A ADD clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_ALTER

A ALTER clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_ALTER_DEFAULT

A ALTER DEFAULT clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_ALTER_NULL

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

public static final Clause
ALTER_TABLE_DROP

A DROP clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_RENAME

A RENAME TO clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_RENAME_COLUMN

A RENAME COLUMN clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_RENAME_CONSTRAINT

A RENAME CONSTRAINT clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_RENAME_INDEX

A RENAME INDEX clause within an ALTER_TABLE statement.

public static final Clause
ALTER_TABLE_TABLE

A TABLE clause within an ALTER_TABLE statement.

public static final Clause
ALTER_VIEW

A complete ALTER VIEW statement.

public static final Clause
ALTER_VIEW_RENAME

A RENAME TO clause within an ALTER_VIEW statement.

public static final Clause
ALTER_VIEW_VIEW

A TABLE clause within an ALTER_VIEW statement.

public static final Clause
CATALOG

Deprecated as a consequence of Clause being deprecated.
public static final Clause
CATALOG_REFERENCE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
CONDITION

A condition expression.

public static final Clause
CONDITION_AND

A combined condition using AND.

public static final Clause
CONDITION_BETWEEN

A BEWEEN condition.

public static final Clause
CONDITION_BETWEEN_SYMMETRIC

A BEWEEN SYMMETRIC condition.

public static final Clause
CONDITION_COMPARISON

Deprecated as a consequence of Clause being deprecated.
public static final Clause
CONDITION_EXISTS

An EXISTS condition.

public static final Clause
CONDITION_IN

An IN condition.

public static final Clause
CONDITION_IS_NOT_NULL

A NOT NULL condition.

public static final Clause
CONDITION_IS_NULL

A NULL condition.

public static final Clause
CONDITION_NOT

A NOT condition.

public static final Clause
CONDITION_NOT_BETWEEN

A NOT BEWEEN condition.

public static final Clause
CONDITION_NOT_BETWEEN_SYMMETRIC

A NOT BEWEEN SYMMETRIC condition.

public static final Clause
CONDITION_NOT_EXISTS

A NOT EXISTS condition.

public static final Clause
CONDITION_NOT_IN

A NOT IN condition.

public static final Clause
CONDITION_OR

A combined condition using OR.

public static final Clause
CONDITION_OVERLAPS

An OVERLAPS condition.

public static final Clause
CONDITION_XOR

A combined condition using XOR.

public static final Clause
CONSTRAINT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
CREATE_INDEX

A complete CREATE INDEX statement.

public static final Clause
CREATE_SCHEMA

A complete CREATE SCHEMA statement.

public static final Clause
CREATE_SCHEMA_NAME

A view name clause within a CREATE_SCHEMA statement.

public static final Clause
CREATE_SEQUENCE

A complete CREATE SEQUENCE statement.

public static final Clause
CREATE_SEQUENCE_SEQUENCE

A SEQUENCE clause within a CREATE_SEQUENCE statement.

public static final Clause
CREATE_TABLE

A complete CREATE TABLE statement.

public static final Clause
CREATE_TABLE_AS

An AS clause within a CREATE_TABLE statement.

public static final Clause
CREATE_TABLE_COLUMNS

A column list within a CREATE_TABLE statement.

public static final Clause
CREATE_TABLE_CONSTRAINTS

A constraint list within a CREATE_TABLE statement.

public static final Clause
CREATE_TABLE_NAME

A view name clause within a CREATE_TABLE statement.

public static final Clause
CREATE_VIEW

A complete CREATE VIEW statement.

public static final Clause
CREATE_VIEW_AS

An AS clause within a CREATE_VIEW statement.

public static final Clause
CREATE_VIEW_NAME

A view name clause within a CREATE_VIEW statement.

public static final Clause
CUSTOM

A custom QueryPart clause.

public static final Clause
DELETE

A complete DELETE statement.

public static final Clause
DELETE_DELETE

A DELETE clause within an DELETE statement.

public static final Clause
DELETE_RETURNING

A RETURNING clause within an DELETE statement.

public static final Clause
DELETE_WHERE

A WHERE clause within an DELETE statement.

public static final Clause
DROP_INDEX

A complete DROP INDEX statement.

public static final Clause
DROP_SCHEMA

A complete DROP SCHEMA statement.

public static final Clause
DROP_SCHEMA_SCHEMA

A SCHEMA clause within an DROP_SCHEMA statement.

public static final Clause
DROP_SEQUENCE

A complete DROP SEQUENCE statement.

public static final Clause
DROP_SEQUENCE_SEQUENCE

A SEQUENCE clause within a DROP_SEQUENCE statement.

public static final Clause
DROP_TABLE

A complete DROP TABLE statement.

public static final Clause
DROP_TABLE_TABLE

A TABLE clause within an DROP_TABLE statement.

public static final Clause
DROP_VIEW

A complete DROP VIEW statement.

public static final Clause
DROP_VIEW_TABLE

A VIEW clause within an DROP_VIEW statement.

public static final Clause
FIELD

A field expression.

public static final Clause
FIELD_ALIAS

A field alias declaration.

public static final Clause
FIELD_CASE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
FIELD_FUNCTION

Deprecated as a consequence of Clause being deprecated.
public static final Clause
FIELD_REFERENCE

A physical or aliased field reference.

public static final Clause
FIELD_ROW

Deprecated as a consequence of Clause being deprecated.
public static final Clause
FIELD_VALUE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
GRANT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
GRANT_ON

Deprecated as a consequence of Clause being deprecated.
public static final Clause
GRANT_PRIVILEGE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
GRANT_TO

Deprecated as a consequence of Clause being deprecated.
public static final Clause
INSERT

A complete INSERT statement.

public static final Clause
INSERT_INSERT_INTO

The INSERT INTO clause within an INSERT statement.

public static final Clause
INSERT_ON_DUPLICATE_KEY_UPDATE

The ON DUPLICATE KEY UPDATE clause within an INSERT statement.

public static final Clause
INSERT_ON_DUPLICATE_KEY_UPDATE_ASSIGNMENT

The ON DUPLICATE KEY UPDATE clause within an INSERT statement.

public static final Clause
INSERT_RETURNING

The RETURNING clause within an INSERT statement.

public static final Clause
INSERT_SELECT

The SELECT clause within an INSERT statement.

public static final Clause
INSERT_VALUES

The VALUES clause within an INSERT statement.

public static final Clause
MERGE

A complete MERGE statement.

public static final Clause
MERGE_DELETE_WHERE

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

public static final Clause
MERGE_MERGE_INTO

A MERGE INTO clause within an MERGE statement.

public static final Clause
MERGE_ON

An ON clause within a MERGE statement.

public static final Clause
MERGE_SET

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

public static final Clause
MERGE_SET_ASSIGNMENT

An assigment within a MERGE_SET clause within an MERGE statement.

public static final Clause
MERGE_USING

A USING clause within a MERGE statement.

public static final Clause
MERGE_VALUES

A VALUES clause within a MERGE statement.

public static final Clause
MERGE_WHEN_MATCHED_THEN_UPDATE

A WHEN MATCHED THEN UPDATE clause within a MERGE statement.

public static final Clause
MERGE_WHEN_NOT_MATCHED_THEN_INSERT

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

public static final Clause
MERGE_WHERE

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

public static final Clause
PRIVILEGE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
REVOKE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
REVOKE_FROM

Deprecated as a consequence of Clause being deprecated.
public static final Clause
REVOKE_ON

Deprecated as a consequence of Clause being deprecated.
public static final Clause
REVOKE_PRIVILEGE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
ROLE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SCHEMA

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SCHEMA_REFERENCE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SELECT

A complete SELECT statement or a subselect.

public static final Clause
SELECT_CONNECT_BY

A CONNECT BY clause within a SELECT statement or subselect.

public static final Clause
SELECT_EXCEPT

A EXCEPT set operation.

public static final Clause
SELECT_EXCEPT_ALL

A EXCEPT ALL set operation.

public static final Clause
SELECT_FROM

A FROM clause within a SELECT statement or subselect.

public static final Clause
SELECT_GROUP_BY

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SELECT_HAVING

A HAVING clause within a SELECT statement or subselect.

public static final Clause
SELECT_INTERSECT

A INTERSECT set operation.

public static final Clause
SELECT_INTERSECT_ALL

A INTERSECT ALL set operation.

public static final Clause
SELECT_INTO

A INTO clause within a SELECT statement.

public static final Clause
SELECT_ORDER_BY

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SELECT_SELECT

A SELECT clause within a SELECT statement or subselect.

public static final Clause
SELECT_START_WITH

A START WITH clause within a SELECT statement or subselect.

public static final Clause
SELECT_UNION

A UNION set operation.

public static final Clause
SELECT_UNION_ALL

A UNION ALL set operation.

public static final Clause
SELECT_WHERE

A WHERE clause within a SELECT statement or subselect.

public static final Clause
SELECT_WINDOW

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SEQUENCE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
SEQUENCE_REFERENCE

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE

A table expression.

public static final Clause
TABLE_ALIAS

A table alias declaration.

public static final Clause
TABLE_JOIN

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_ANTI_LEFT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_CROSS

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_CROSS_APPLY

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_INNER

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_NATURAL

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_NATURAL_OUTER_FULL

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_NATURAL_OUTER_LEFT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_NATURAL_OUTER_RIGHT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_ON

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_OUTER_APPLY

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_OUTER_FULL

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_OUTER_LEFT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_OUTER_RIGHT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_PARTITION_BY

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_SEMI_LEFT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_STRAIGHT

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_JOIN_USING

Deprecated as a consequence of Clause being deprecated.
public static final Clause
TABLE_REFERENCE

A physical or aliased table reference.

public static final Clause
TABLE_VALUES

A VALUES table constructor

This clause surrounds a

  • a VALUES keyword
  • a table constructor with several FIELD_ROW value expressions
public static final Clause
TEMPLATE

A plain SQL template clause.

public static final Clause
TRUNCATE

A complete TRUNCATE statement.

public static final Clause
TRUNCATE_TRUNCATE

A TRUNCATE clause within an TRUNCATE statement.

public static final Clause
UPDATE

A complete UPDATE statement.

public static final Clause
UPDATE_FROM

A vendor-specific FROM clause within an UPDATE statement.

public static final Clause
UPDATE_RETURNING

A RETURNING clause within an UPDATE statement.

public static final Clause
UPDATE_SET

A SET clause within an UPDATE statement.

public static final Clause
UPDATE_SET_ASSIGNMENT

An assigment within a UPDATE_SET clause within an UPDATE statement.

public static final Clause
UPDATE_UPDATE

An UPDATE clause within an UPDATE statement.

public static final Clause
UPDATE_WHERE

A WHERE clause within an UPDATE statement.

public static final Clause
USER

Deprecated as a consequence of Clause being deprecated.
public static final Clause
WITH

A WITH clause preceding all sorts of DML statements.

Constructor Summary

AccessConstructor and Description
private

Method Summary

Modifier and TypeMethod and Description
public static Clause
valueOf(String name)

Deprecated as a consequence of Clause being deprecated.
public static Clause[]
values()

Deprecated as a consequence of Clause being deprecated.
Inherited from java.lang.Enum:
clonecompareTodescribeConstableequalsfinalizegetDeclaringClasshashCodenameordinaltoStringvalueOf