-
- All Superinterfaces:
Attachable
,AutoCloseable
,Flow.Publisher<Integer>
,org.reactivestreams.Publisher<Integer>
,Query
,QueryPart
,RowCountQuery
,Serializable
,Statement
,Update<R>
,UpdateFinalStep<R>
- All Known Subinterfaces:
UpdateConditionStep<R>
,UpdateFromStep<R>
,UpdateLimitStep<R>
,UpdateOrderByStep<R>
,UpdateSetMoreStep<R>
,UpdateWhereStep<R>
public interface UpdateReturningStep<R extends Record> extends UpdateFinalStep<R>
This type is used for theUpdate
's DSL API.Example:
DSLContext create = DSL.using(configuration); TableRecord<?> record = create.update(table) .set(field1, value1) .set(field2, value2) .returning(field1) .fetchOne();
This implemented differently for every dialect:
- Firebird and Postgres have native support for
UPDATE .. RETURNING
clauses - DB2 allows to execute
SELECT .. FROM FINAL TABLE (UPDATE ...)
Referencing
XYZ*Step
types directly from client codeIt is usually not recommended to reference any
XYZ*Step
types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.Drawbacks of referencing the
XYZ*Step
types directly:- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets complex
- They're less readable
- They might have binary incompatible changes between minor releases
- Author:
- Lukas Eder
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description @NotNull UpdateResultStep<R>
returning()
Configure theUPDATE
statement to return all fields inR
.@NotNull UpdateResultStep<R>
returning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.@NotNull UpdateResultStep<R>
returning(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.<T1> @NotNull UpdateResultStep<Record1<T1>>
returningResult(SelectField<T1> field1)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2>
@NotNull UpdateResultStep<Record2<T1,T2>>returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3>
@NotNull UpdateResultStep<Record3<T1,T2,T3>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4>
@NotNull UpdateResultStep<Record4<T1,T2,T3,T4>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5>
@NotNull UpdateResultStep<Record5<T1,T2,T3,T4,T5>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6>
@NotNull UpdateResultStep<Record6<T1,T2,T3,T4,T5,T6>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7>
@NotNull UpdateResultStep<Record7<T1,T2,T3,T4,T5,T6,T7>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8>
@NotNull UpdateResultStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
@NotNull UpdateResultStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
@NotNull UpdateResultStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
@NotNull UpdateResultStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
@NotNull UpdateResultStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
@NotNull UpdateResultStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
@NotNull UpdateResultStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
@NotNull UpdateResultStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
@NotNull UpdateResultStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
@NotNull UpdateResultStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
@NotNull UpdateResultStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
@NotNull UpdateResultStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
@NotNull UpdateResultStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
@NotNull UpdateResultStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
@NotNull UpdateResultStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)
Configure theUPDATE
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
returningResult(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.-
Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
-
Methods inherited from interface java.util.concurrent.Flow.Publisher
subscribe
-
Methods inherited from interface org.jooq.Query
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, poolable, queryTimeout
-
-
-
-
Method Detail
-
returning
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) @NotNull UpdateResultStep<R> returning()
Configure theUPDATE
statement to return all fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returning
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) @NotNull UpdateResultStep<R> returning(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
[#5070] Due to an early API design flaw, this method historically returns the type
R
, not a more generic typeRecord
. This means that only actual columns inR
can be returned. For a more generic set of column expressions, usereturningResult(SelectFieldOrAsterisk...)
instead.- Parameters:
fields
- Fields to be returned- See Also:
UpdateResultStep
-
returning
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) @NotNull UpdateResultStep<R> returning(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
[#5070] Due to an early API design flaw, this method historically returns the type
R
, not a more generic typeRecord
. This means that only actual columns inR
can be returned. For a more generic set of column expressions, usereturningResult(Collection)
instead.- Parameters:
fields
- Fields to be returned- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) @NotNull UpdateResultStep<Record> returningResult(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- Parameters:
fields
- Fields to be returned- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) @NotNull UpdateResultStep<Record> returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- Parameters:
fields
- Fields to be returned- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1> @NotNull UpdateResultStep<Record1<T1>> returningResult(SelectField<T1> field1)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2> @NotNull UpdateResultStep<Record2<T1,T2>> returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3> @NotNull UpdateResultStep<Record3<T1,T2,T3>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4> @NotNull UpdateResultStep<Record4<T1,T2,T3,T4>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5> @NotNull UpdateResultStep<Record5<T1,T2,T3,T4,T5>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6> @NotNull UpdateResultStep<Record6<T1,T2,T3,T4,T5,T6>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7> @NotNull UpdateResultStep<Record7<T1,T2,T3,T4,T5,T6,T7>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8> @NotNull UpdateResultStep<Record8<T1,T2,T3,T4,T5,T6,T7,T8>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9> @NotNull UpdateResultStep<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> @NotNull UpdateResultStep<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> @NotNull UpdateResultStep<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> @NotNull UpdateResultStep<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> @NotNull UpdateResultStep<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> @NotNull UpdateResultStep<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> @NotNull UpdateResultStep<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> @NotNull UpdateResultStep<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> @NotNull UpdateResultStep<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> @NotNull UpdateResultStep<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> @NotNull UpdateResultStep<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> @NotNull UpdateResultStep<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> @NotNull UpdateResultStep<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
returningResult
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,ORACLE,POSTGRES,SQLSERVER}) <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> @NotNull UpdateResultStep<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>> returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9, SelectField<T10> field10, SelectField<T11> field11, SelectField<T12> field12, SelectField<T13> field13, SelectField<T14> field14, SelectField<T15> field15, SelectField<T16> field16, SelectField<T17> field17, SelectField<T18> field18, SelectField<T19> field19, SelectField<T20> field20, SelectField<T21> field21, SelectField<T22> field22)
Configure theUPDATE
statement to return a list of fields inR
.This will return the data after updating and generation of default values and generation of any values produced by triggers.
- See Also:
UpdateResultStep
-
-