Uses of Interface
org.jooq.Statement
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Statement in org.jooq
Modifier and TypeInterfaceDescriptioninterface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theALTER DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
AlterSequenceFlagsStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
AlterSequenceStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
The step in theALTER TABLE
DSL used toADD
columns.interface
The step in theALTER TABLE
DSL used toDROP
columns or constraints.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
The step in theALTER TABLE … ADD CONSTRAINT
statement where an optional index can be specified to enforce the constraint.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A procedural block.interface
A step in the construction of theCALL
statement.interface
AQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
CloseableResultQuery<R extends Record>
AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of anCONTINUE
statement where aWHEN
clause can be added.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE DOMAIN
statement.interface
A step in the construction of theCREATE DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE INDEX
statement.interface
A step in the construction of theCREATE INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE SEQUENCE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A marker interface for all DDL queries.interface
Declaration<T>
A local variable declaration.interface
ADELETE
statement.interface
DeleteConditionStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
DeleteLimitStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteOrderByStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteQuery<R extends Record>
ADELETE
statement (model API).interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteReturningStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteUsingStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteWhereStep<R extends Record>
This type is used for theDelete
's DSL API.interface
interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP SCHEMA
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
AQuery
that can drop types.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of anEXIT
statement where aWHEN
clause can be added.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theGRANT
statement.interface
An intermediate step in building a proceduralIF
statement.interface
AnINSERT
statement.interface
InsertFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
InsertOnConflictConditionStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertQuery<R extends Record>
AnINSERT
statement (model API).interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertReturningStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertSetMoreStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertValuesStep1<R extends Record,
T1> This type is used for theInsert
's DSL API.interface
InsertValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert
's DSL API.interface
InsertValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert
's DSL API.interface
InsertValuesStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theInsert
's DSL API.interface
InsertValuesStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> This type is used for theInsert
's DSL API.interface
InsertValuesStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> This type is used for theInsert
's DSL API.interface
InsertValuesStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> This type is used for theInsert
's DSL API.interface
InsertValuesStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> This type is used for theInsert
's DSL API.interface
InsertValuesStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> This type is used for theInsert
's DSL API.interface
InsertValuesStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> This type is used for theInsert
's DSL API.interface
InsertValuesStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theInsert
's DSL API.interface
InsertValuesStep2<R extends Record,
T1, T2> This type is used for theInsert
's DSL API.interface
InsertValuesStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theInsert
's DSL API.interface
InsertValuesStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theInsert
's DSL API.interface
InsertValuesStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theInsert
's DSL API.interface
InsertValuesStep3<R extends Record,
T1, T2, T3> This type is used for theInsert
's DSL API.interface
InsertValuesStep4<R extends Record,
T1, T2, T3, T4> This type is used for theInsert
's DSL API.interface
InsertValuesStep5<R extends Record,
T1, T2, T3, T4, T5> This type is used for theInsert
's DSL API.interface
InsertValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> This type is used for theInsert
's DSL API.interface
InsertValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert
's DSL API.interface
InsertValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert
's DSL API.interface
InsertValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert
's DSL API.interface
InsertValuesStepN<R extends Record>
This type is used for theInsert
's DSL API.interface
A label for use in procedural code.interface
AMERGE
statement.interface
MergeFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
MergeMatchedDeleteStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnConditionStep<R extends Record>
This type is used for theMerge
's DSL API.interface
Any query.interface
ResultQuery<R extends Record>
A query that can return results.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Any query that is not aResultQuery
, and thus possibly produces a row count as a result, instead of aResult
.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
A step in the construction of theSIGNAL SQL STATE
function.interface
StoreQuery<R extends Record>
A query storing objects to the database.interface
A step in the construction of theTRUNCATE
statement.interface
TruncateCascadeStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
TruncateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
TruncateIdentityStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
AnUPDATE
statement.interface
UpdateConditionStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
UpdateFromStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateLimitStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateOrderByStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateQuery<R extends Record>
AnUPDATE
statement (model API).interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateReturningStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetMoreStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateWhereStep<R extends Record>
This type is used for theUpdate
's DSL API.Modifier and TypeMethodDescription@NotNull Statement
IfElseStep.else_
(Collection<? extends Statement> statements) Add anELSE
clause to theIF
statement.@NotNull Statement
Add anELSE
clause to theIF
statement.@NotNull Statement
Create a labelled statement.@NotNull Statement
LoopStep.loop
(Collection<? extends Statement> statements) Add aLOOP
clause to theWHILE
orFOR
loop.@NotNull Statement
Add aLOOP
clause to theWHILE
orFOR
loop.@Nullable Statement
Parser.parseStatement
(String sql) Parse a SQL string to a procedural statement.@Nullable Statement
Parser.parseStatement
(String sql, Object... bindings) Parse a SQL string with bind variables to a procedural statement.@NotNull Statement
Initialise this declaration.@NotNull Statement
Initialise this declaration.@NotNull Statement
Initialise this declaration.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row10.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row11.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row12.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row13.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row13.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13) Assign a value to this set of variables.@NotNull Statement
Row14.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row14.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14) Assign a value to this set of variables.@NotNull Statement
Row15.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row15.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15) Assign a value to this set of variables.@NotNull Statement
Row16.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row16.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16) Assign a value to this set of variables.@NotNull Statement
Row17.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row17.set
(Select<? extends Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> value) Assign a value to this set of variables.@NotNull Statement
Row17.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17) Assign a value to this set of variables.@NotNull Statement
Row18.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row18.set
(Select<? extends Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> value) Assign a value to this set of variables.@NotNull Statement
Row18.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18) Assign a value to this set of variables.@NotNull Statement
Row19.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row19.set
(Select<? extends Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> value) Assign a value to this set of variables.@NotNull Statement
Row19.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row20.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row20.set
(Select<? extends Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> value) Assign a value to this set of variables.@NotNull Statement
Row20.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20) Assign a value to this set of variables.@NotNull Statement
Row21.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21) Assign a value to this set of variables.@NotNull Statement
Row21.set
(Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> record) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row21.set
(Select<? extends Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> value) Assign a value to this set of variables.@NotNull Statement
Row21.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21) Assign a value to this set of variables.@NotNull Statement
Row22.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16, Field<T17> t17, Field<T18> t18, Field<T19> t19, Field<T20> t20, Field<T21> t21, Field<T22> t22) Assign a value to this set of variables.@NotNull Statement
Row22.set
(Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> record) Assign a value to this set of variables.@NotNull Statement
Row22.set
(Row22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> row) Assign a value to this set of variables.@NotNull Statement
Row22.set
(Select<? extends Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> value) Assign a value to this set of variables.@NotNull Statement
Row22.set
(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17, T18 t18, T19 t19, T20 t20, T21 t21, T22 t22) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row7.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row8.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Row9.set
(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9) Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this set of variables.@NotNull Statement
Assign a value to this variable.@NotNull Statement
Assign a value to this variable.@NotNull Statement
Assign a value to this variable.@NotNull Statement
SignalSetStep.setMessageText
(String messageText) Add theSET MESSAGE TEXT
clause to theSIGNAL SQL STATE
function.@NotNull Statement
SignalSetStep.setMessageText
(Field<String> messageText) Add theSET MESSAGE TEXT
clause to theSIGNAL SQL STATE
function.@NotNull Statement
Declaration.setNull()
Initialise this declaration withnull
.@NotNull Statement
Variable.setNull()
Assignnull
to this variable.@NotNull Statement
Add anUNTIL
clause to theREPEAT
loop.@NotNull Statement
Add aWHEN
clause to theCONTINUE
statement.@NotNull Statement
Add aWHEN
clause to theCONTINUE
statement.@NotNull Statement
Add aWHEN
clause to theEXIT
statement.@NotNull Statement
Add aWHEN
clause to theEXIT
statement.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Statement>
Block.$statements()
Experimental query object model accessor method, see alsoQOM
.Modifier and TypeMethodDescription@NotNull DDLQuery
Add theAS
clause to theCREATE FUNCTION
statement.@NotNull DDLQuery
Add theAS
clause to theCREATE FUNCTION
statement.@NotNull DDLQuery
Add theAS
clause to theCREATE PROCEDURE
statement.@NotNull DDLQuery
Add theAS
clause to theCREATE PROCEDURE
statement.@NotNull DDLQuery
Add theAS
clause to theCREATE TRIGGER
statement.@NotNull DDLQuery
Add theAS
clause to theCREATE TRIGGER
statement.@NotNull Block
Wrap a collection of statements in an anonymous procedural block.@NotNull Statement
Add anELSE
clause to theIF
statement.@NotNull Statement
Create a labelled statement.@NotNull Statement
Add aLOOP
clause to theWHILE
orFOR
loop.@NotNull Block
DSLContext.statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.@NotNull IfElseStep
Add aTHEN
clause to theIF
statement.Modifier and TypeMethodDescription@NotNull DDLQuery
CreateFunctionAsStep.as
(Collection<? extends Statement> body) Add theAS
clause to theCREATE FUNCTION
statement.@NotNull DDLQuery
CreateProcedureAsStep.as
(Collection<? extends Statement> body) Add theAS
clause to theCREATE PROCEDURE
statement.@NotNull DDLQuery
CreateTriggerActionStep.as
(Collection<? extends Statement> body) Add theAS
clause to theCREATE TRIGGER
statement.@NotNull Block
DSLContext.begin
(Collection<? extends Statement> statements) Wrap a collection of statements in an anoymous procedural block.@NotNull Statement
IfElseStep.else_
(Collection<? extends Statement> statements) Add anELSE
clause to theIF
statement.@NotNull Statement
LoopStep.loop
(Collection<? extends Statement> statements) Add aLOOP
clause to theWHILE
orFOR
loop.@NotNull Block
DSLContext.statements
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.@NotNull IfElseStep
IfThenStep.then
(Collection<? extends Statement> statements) Add aTHEN
clause to theIF
statement. -
Uses of Statement in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
TheALTER DATABASE
statement.static interface
TheALTER DOMAIN
statement.static interface
TheALTER INDEX
statement.static interface
TheALTER SCHEMA
statement.static interface
QOM.AlterSequence<T extends Number>
TheALTER SEQUENCE
statement.static interface
TheALTER TYPE
statement.static interface
TheALTER VIEW
statement.static interface
static interface
TheCALL
statement.static interface
TheCOMMENT ON TABLE
statement.static interface
static interface
TheCREATE DATABASE
statement.static interface
TheCREATE DOMAIN
statement.static interface
TheCREATE FUNCTION
statement.static interface
TheCREATE INDEX
statement.static interface
TheCREATE PROCEDURE
statement.static interface
TheCREATE SCHEMA
statement.static interface
TheCREATE SEQUENCE
statement.static interface
TheCREATE TABLE
statement.static interface
TheCREATE TRIGGER
statement.static interface
static interface
QOM.CreateView<R extends Record>
static interface
static interface
TheDROP DATABASE
statement.static interface
TheDROP DOMAIN
statement.static interface
TheDROP FUNCTION
statement.static interface
TheDROP INDEX
statement.static interface
TheDROP PROCEDURE
statement.static interface
TheDROP SCHEMA
statement.static interface
TheDROP SEQUENCE
statement.static interface
TheDROP TABLE
statement.static interface
TheDROP TRIGGER
statement.static interface
static interface
TheDROP VIEW
statement.static interface
TheEXECUTE
function.static interface
static interface
TheGOTO
function.static interface
TheGRANT
statement.static interface
static interface
static interface
static interface
static interface
static interface
TheRETURN_
function.static interface
TheREVOKE
statement.static interface
static interface
TheSET CATALOG
statement.static interface
TheSET
statement.static interface
TheSET SCHEMA
statement.static interface
TheSIGNAL SQL STATE
function.static interface
QOM.Truncate<R extends Record>
TheTRUNCATE
statement.Modifier and TypeClassDescriptionclass
A base class for customStatement
implementations in client code.Modifier and TypeMethodDescription@NotNull Statement
QOM.CreateFunction.$body()
@NotNull Statement
QOM.CreateProcedure.$body()
@NotNull Statement
QOM.CreateTrigger.$body()
@NotNull Statement
QOM.LabelledStatement.$statement()
static @NotNull Statement
DSL.continueWhen
(Condition condition) Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
DSL.continueWhen
(Field<Boolean> condition) Create anCONTINUE
statement for use in procedural code.static @NotNull Statement
DSL.declare
(Collection<? extends Variable<?>> variables) Create a local variable declaration for use in procedural code.static @NotNull Statement
Create a local variable declaration for use in procedural code.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
TheEXECUTE
function.static @NotNull Statement
Execute a statement dynamically from within procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static @NotNull Statement
Create anEXIT
statement for use in procedural code.static @NotNull Statement
TheGOTO
function.static @NotNull Statement
Inline all bind variables produced by the argumentStatement
.static @NotNull Statement
DSL.loop
(Collection<? extends Statement> statements) Create aLOOP
for use in procedural code.static @NotNull Statement
Create aLOOP
for use in procedural code.static @NotNull Statement
DSL.return_()
TheRETURN_
function.static @NotNull Statement
TheRETURN_
function.static @NotNull Statement
TheRETURN_
function.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.Modifier and TypeMethodDescription@NotNull QOM.CreateFunction
@NotNull QOM.CreateProcedure
@NotNull QOM.CreateTrigger
static @NotNull Block
Wrap a collection of statements in an anonymous procedural block.static @NotNull Statement
Inline all bind variables produced by the argumentStatement
.static @NotNull Statement
Create aLOOP
for use in procedural code.static @NotNull RepeatUntilStep
Create aREPEAT
loop for use in procedural code.DefaultDSLContext.statements
(Statement... statements) static @NotNull Block
DSL.statements
(Statement... statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.Modifier and TypeMethodDescriptionDefaultDSLContext.begin
(Collection<? extends Statement> statements) static @NotNull Block
DSL.begin
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block.static @NotNull Statement
DSL.loop
(Collection<? extends Statement> statements) Create aLOOP
for use in procedural code.static @NotNull RepeatUntilStep
DSL.repeat
(Collection<? extends Statement> statements) Create aREPEAT
loop for use in procedural code.DefaultDSLContext.statements
(Collection<? extends Statement> statements) static @NotNull Block
DSL.statements
(Collection<? extends Statement> statements) Wrap a collection of statements in an anonymous procedural block that does not wrap inBEGIN … END;
, unless explicitly needed.