Uses of Interface
org.jooq.OrderField
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of OrderField in org.jooq
Modifier and TypeInterfaceDescriptioninterface
The step in the specification of aggregate functions where the SQL:2003 standardFILTER clause
can be added.interface
An aggregate function.interface
The SQL standardARRAY_AGG()
function.interface
The final step in creating a case statement of the typeinterface
CaseWhenStep<V,
T> The final step in creating a case statement of the typeinterface
Field<T>
A column expression.interface
MySQL'sGROUP_CONCAT
function.interface
MySQL'sGROUP_CONCAT
function.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theORDER BY
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theRETURNING
clause can be defined.interface
A step in the construction of theJSON ARRAY
function.interface
A step in the construction of theJSON ARRAY
function.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theRETURNING
clause can be defined.interface
A step in the construction of theJSON OBJECT
function.interface
A step in the construction of theJSON OBJECT
function.interface
A step in the construction ofDSL.jsonValue(Field, Field)
orDSL.jsonbValue(Field, Field)
functions where theON EMPTY
andON ERROR
clauses can be defined.interface
A step in the construction of theJSON VALUE
function.interface
Param<T>
A named parameter and/or bind value.interface
Parameter<T>
A parameter to a stored procedure or function.interface
interface
SortField<T>
A sort specification.interface
TableField<R extends Record,
T> A field contained in a table.interface
A field contained in a UDT.interface
Variable<T>
A local variable reference.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.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
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
The SQL standardARRAY_AGG()
function.Modifier and TypeMethodDescriptionvoid
DeleteQuery.addOrderBy
(OrderField<?>... fields) Adds ordering fields.void
SelectQuery.addOrderBy
(OrderField<?>... fields) Adds ordering fields.void
UpdateQuery.addOrderBy
(OrderField<?>... fields) Adds ordering fields.@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankFirstOrderBy
(OrderField<?>... fields) Restrict this aggregate function toFIRST
values@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankLastOrderBy
(OrderField<?>... fields) Restrict this aggregate function toLAST
values@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Table<?> table, OrderField<?>... on) Add theON
clause to theCREATE INDEX
statement.@NotNull AggregateFilterStep<T>
ArrayAggOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the function.@NotNull DeleteLimitStep<R>
DeleteOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the query.@NotNull GroupConcatSeparatorStep
GroupConcatOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the function.@NotNull JSONArrayAggNullStep<J>
JSONArrayAggOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the function.@NotNull SelectSeekStepN<R>
SelectOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the query<T1> @NotNull SelectSeekStep1<R,
T1> SelectOrderByStep.orderBy
(OrderField<T1> field1) Add anORDER BY
clause to the query.<T1,
T2> @NotNull SelectSeekStep2<R, T1, T2> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2) Add anORDER BY
clause to the query.<T1,
T2, T3> @NotNull SelectSeekStep3<R, T1, T2, T3> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3) Add anORDER BY
clause to the query.<T1,
T2, T3, T4>
@NotNull SelectSeekStep4<R,T1, T2, T3, T4> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5>
@NotNull SelectSeekStep5<R,T1, T2, T3, T4, T5> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6>
@NotNull SelectSeekStep6<R,T1, T2, T3, T4, T5, T6> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull SelectSeekStep7<R,T1, T2, T3, T4, T5, T6, T7> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSeekStep8<R,T1, T2, T3, T4, T5, T6, T7, T8> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSeekStep9<R,T1, T2, T3, T4, T5, T6, T7, T8, T9> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull SelectSeekStep10<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull SelectSeekStep11<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull SelectSeekStep12<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull SelectSeekStep13<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull SelectSeekStep14<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull SelectSeekStep15<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull SelectSeekStep16<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull SelectSeekStep17<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull SelectSeekStep18<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull SelectSeekStep19<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull SelectSeekStep20<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull SelectSeekStep21<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20, OrderField<T21> field21) Add anORDER BY
clause to the query.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull SelectSeekStep22<R,T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> SelectOrderByStep.orderBy
(OrderField<T1> field1, OrderField<T2> field2, OrderField<T3> field3, OrderField<T4> field4, OrderField<T5> field5, OrderField<T6> field6, OrderField<T7> field7, OrderField<T8> field8, OrderField<T9> field9, OrderField<T10> field10, OrderField<T11> field11, OrderField<T12> field12, OrderField<T13> field13, OrderField<T14> field14, OrderField<T15> field15, OrderField<T16> field16, OrderField<T17> field17, OrderField<T18> field18, OrderField<T19> field19, OrderField<T20> field20, OrderField<T21> field21, OrderField<T22> field22) Add anORDER BY
clause to the query.@NotNull UpdateLimitStep<R>
UpdateOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the query.@NotNull WindowRowsStep<T>
WindowOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the window function.@NotNull WindowSpecificationRowsStep
WindowSpecificationOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the window specification.@NotNull AggregateFilterStep<T>
XMLAggOrderByStep.orderBy
(OrderField<?>... fields) Add anORDER BY
clause to the function.@NotNull SelectLimitStep<R>
SelectOrderByStep.orderSiblingsBy
(OrderField<?>... fields) Add anORDER SIBLINGS BY
clause to the query@NotNull AggregateFilterStep<T>
OrderedAggregateFunction.withinGroupOrderBy
(OrderField<?>... fields) Add anWITHIN GROUP (ORDER BY …)
clause to the ordered aggregate function<T> @NotNull AggregateFilterStep<T>
OrderedAggregateFunctionOfDeferredType.withinGroupOrderBy
(OrderField<T> field) Add anWITHIN GROUP (ORDER BY …)
clause to the ordered aggregate functionModifier and TypeMethodDescriptionvoid
DeleteQuery.addOrderBy
(Collection<? extends OrderField<?>> fields) Adds ordering fields.void
SelectQuery.addOrderBy
(Collection<? extends OrderField<?>> fields) Adds ordering fields.void
UpdateQuery.addOrderBy
(Collection<? extends OrderField<?>> fields) Adds ordering fields.@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankFirstOrderBy
(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toFIRST
values@NotNull AggregateFilterStep<T>
AggregateFunction.keepDenseRankLastOrderBy
(Collection<? extends OrderField<?>> fields) Restrict this aggregate function toLAST
values@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Table<?> table, Collection<? extends OrderField<?>> on) Add theON
clause to theCREATE INDEX
statement.@NotNull AggregateFilterStep<T>
ArrayAggOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the function.@NotNull DeleteLimitStep<R>
DeleteOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the query.@NotNull GroupConcatSeparatorStep
GroupConcatOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the function.@NotNull JSONArrayAggNullStep<J>
JSONArrayAggOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the function.@NotNull SelectSeekStepN<R>
SelectOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the query@NotNull UpdateLimitStep<R>
UpdateOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the query.@NotNull WindowRowsStep<T>
WindowOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the window function.@NotNull WindowSpecificationRowsStep
WindowSpecificationOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the window specification.@NotNull AggregateFilterStep<T>
XMLAggOrderByStep.orderBy
(Collection<? extends OrderField<?>> fields) Add anORDER BY
clause to the function.@NotNull SelectLimitStep<R>
SelectOrderByStep.orderSiblingsBy
(Collection<? extends OrderField<?>> fields) Add anORDER SIBLINGS BY
clause to the query@NotNull AggregateFilterStep<T>
OrderedAggregateFunction.withinGroupOrderBy
(Collection<? extends OrderField<?>> fields) Add anWITHIN GROUP (ORDER BY …)
clause to the ordered aggregate function -
Uses of OrderField in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
TheABS
function.static interface
TheACOS
function.static interface
QOM.Add<T>
TheADD
operator.static interface
QOM.AnyValue<T>
TheANY VALUE
function.static interface
QOM.Array<T>
static interface
QOM.ArrayAgg<T>
static interface
QOM.ArrayGet<T>
TheARRAY GET
function.static interface
static interface
TheASCII
function.static interface
TheASIN
function.static interface
TheATAN
function.static interface
TheATAN2
function.static interface
TheAVG
function.static interface
QOM.BitAnd<T extends Number>
TheBIT AND
operator.static interface
QOM.BitAndAgg<T extends Number>
TheBIT AND AGG
function.static interface
TheBIT COUNT
function.static interface
TheBIT LENGTH
function.static interface
QOM.BitNand<T extends Number>
TheBIT NAND
operator.static interface
QOM.BitNor<T extends Number>
TheBIT NOR
operator.static interface
QOM.BitNot<T extends Number>
TheBIT NOT
operator.static interface
TheBIT OR
operator.static interface
QOM.BitOrAgg<T extends Number>
TheBIT OR AGG
function.static interface
QOM.BitXNor<T extends Number>
TheBIT X NOR
operator.static interface
QOM.BitXor<T extends Number>
TheBIT XOR
operator.static interface
QOM.BitXorAgg<T extends Number>
TheBIT XOR AGG
function.static interface
TheBOOL AND
function.static interface
TheBOOL OR
function.static interface
TheCARDINALITY
function.static interface
QOM.Cast<T>
static interface
TheCEIL
function.static interface
TheCHAR LENGTH
function.static interface
QOM.Choose<T>
static interface
TheCHR
function.static interface
QOM.Coalesce<T>
static interface
QOM.Coerce<T>
static interface
static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
static interface
TheFIELD
function.static interface
TheCONNECT BY ISCYCLE
function.static interface
TheCONNECT BY ISLEAF
function.static interface
TheCONNECT BY ROOT
function.static interface
QOM.Convert<T>
static interface
TheCORR
function.static interface
TheCOS
function.static interface
TheCOSH
function.static interface
TheCOT
function.static interface
TheCOTH
function.static interface
TheCOUNT
function.static interface
static interface
TheCOVAR POP
function.static interface
TheCOVAR SAMP
function.static interface
static interface
TheCURRENT CATALOG
function.static interface
static interface
TheCURRENT SCHEMA
function.static interface
static interface
static interface
TheCURRENT USER
function.static interface
QOM.DateAdd<T>
TheDATE ADD
function.static interface
QOM.Default<T>
static interface
TheDEGREES
function.static interface
static interface
TheDIGITS
function.static interface
QOM.Div<T>
TheDIV
operator.static interface
TheE
function.static interface
TheEXP
function.static interface
static interface
static interface
static interface
static interface
TheFLOOR
function.static interface
QOM.Function<T>
static interface
QOM.Greatest<T>
static interface
QOM.Iif<T>
static interface
QOM.Inline<T>
static interface
TheJSON ARRAY
function.static interface
static interface
TheJSON OBJECT
function.static interface
static interface
QOM.Lag<T>
static interface
static interface
QOM.Lead<T>
static interface
QOM.Least<T>
static interface
TheLEFT
function.static interface
TheLEVEL
function.static interface
TheLN
function.static interface
TheLOG10
function.static interface
TheLOWER
function.static interface
TheLPAD
function.static interface
TheLTRIM
function.static interface
QOM.Max<T>
TheMAX
function.static interface
TheMD5
function.static interface
TheMEDIAN
function.static interface
QOM.Min<T>
TheMIN
function.static interface
TheMOD
operator.static interface
QOM.Mode<T>
static interface
QOM.Mul<T>
TheMUL
operator.static interface
QOM.Multiset<R extends Record>
static interface
QOM.MultisetAgg<R extends Record>
static interface
QOM.Neg<T>
static interface
TheNOT
operator.static interface
QOM.NthValue<T>
static interface
static interface
QOM.Nullif<T>
TheNULLIF
function.static interface
QOM.Nvl<T>
TheNVL
function.static interface
QOM.Nvl2<T>
static interface
TheOCTET LENGTH
function.static interface
TheOVERLAY
function.static interface
static interface
ThePI
function.static interface
QOM.PlusJoin<T>
ThePLUS
operator.static interface
ThePOSITION
function.static interface
ThePOWER
operator.static interface
QOM.Prior<T>
ThePRIOR
function.static interface
ThePRODUCT
function.static interface
TheROWID
operator.static interface
TheRADIANS
function.static interface
TheRAND
function.static interface
static interface
static interface
TheREGR AVGX
function.static interface
TheREGR AVGY
function.static interface
TheREGR COUNT
function.static interface
TheREGR INTERCEPT
function.static interface
TheREGR R2
function.static interface
TheREGR SLOPE
function.static interface
TheREGR SXX
function.static interface
TheREGR SXY
function.static interface
TheREGR SYY
function.static interface
TheREPEAT
function.static interface
TheREPLACE
function.static interface
TheREVERSE
function.static interface
TheRIGHT
function.static interface
TheROUND
function.static interface
QOM.RowField<R extends Record>
static interface
TheROWNUM
function.static interface
static interface
TheRPAD
function.static interface
TheRTRIM
function.static interface
static interface
TheSHL
operator.static interface
TheSHR
operator.static interface
TheSIGN
function.static interface
TheSIN
function.static interface
TheSINH
function.static interface
TheSPACE
function.static interface
TheSPLIT PART
function.static interface
TheSQRT
function.static interface
QOM.Square<T extends Number>
TheSQUARE
function.static interface
TheST AREA
function.static interface
TheST ASBINARY
function.static interface
TheST ASTEXT
function.static interface
TheST CENTROID
function.static interface
TheSTDDEV POP
function.static interface
TheSTDDEV SAMP
function.static interface
QOM.StDifference<T extends Spatial>
TheST DIFFERENCE
function.static interface
QOM.StDistance<T extends Spatial>
TheST DISTANCE
function.static interface
QOM.StEndPoint<T extends Spatial>
TheST ENDPOINT
function.static interface
TheST EXTERIORRING
function.static interface
QOM.StGeometryN<T extends Spatial>
TheST GEOMETRYN
function.static interface
TheST GEOMETRYTYPE
function.static interface
TheST GEOMFROMTEXT
function.static interface
TheST GEOMFROMWKB
function.static interface
TheST INTERIORRINGN
function.static interface
QOM.StIntersection<T extends Spatial>
TheST INTERSECTION
function.static interface
TheST LENGTH
function.static interface
TheST NUMGEOMETRIES
function.static interface
TheST NUMINTERIORRING
function.static interface
TheST NUMPOINTS
function.static interface
QOM.StPointN<T extends Spatial>
TheST POINTN
function.static interface
TheST SRID
function.static interface
QOM.StStartPoint<T extends Spatial>
TheST STARTPOINT
function.static interface
QOM.StUnion<T extends Spatial>
TheST UNION
function.static interface
TheST X
function.static interface
TheST Y
function.static interface
TheST Z
function.static interface
QOM.Sub<T>
TheSUB
operator.static interface
TheSUBSTRING
function.static interface
TheSUBSTRING INDEX
function.static interface
TheSUM
function.static interface
TheSYS CONNECT BY PATH
function.static interface
TheTAN
function.static interface
TheTANH
function.static interface
TheTAU
function.static interface
static interface
TheTO CHAR
function.static interface
TheTO DATE
function.static interface
TheTO HEX
function.static interface
TheTO TIMESTAMP
function.static interface
TheTRANSLATE
function.static interface
TheTRIM
function.static interface
TheTRUNC
function.static interface
TheUPPER
function.static interface
TheUUID
function.static interface
QOM.Val<T>
static interface
TheVAR POP
function.static interface
TheVAR SAMP
function.static interface
QOM.WidthBucket<T extends Number>
TheWIDTH BUCKET
function.static interface
static interface
static interface
TheXMLCOMMENT
function.static interface
TheXMLCONCAT
function.static interface
TheXMLDOCUMENT
function.static interface
static interface
TheXMLFOREST
function.static interface
static interface
TheXMLPI
function.static interface
static interface
TheXMLSERIALIZE
function.Modifier and TypeClassDescriptionclass
CustomField<T>
A base class for customField
implementations in client code.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends OrderField<?>>
QOM.CreateIndex.$on()
Modifier and TypeMethodDescriptionstatic Index
AbstractKeys.createIndex
(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic final @NotNull Index
Internal.createIndex
(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#9404] - Please re-generate your code.static final @NotNull Index
Internal.createIndex
(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Factory method for indexes.static @NotNull WindowSpecificationRowsStep
DSL.orderBy
(OrderField<?>... fields) Create aWindowSpecification
with anORDER BY
clause.Modifier and TypeMethodDescription@NotNull QOM.CreateIndex
QOM.CreateIndex.$on
(QOM.UnmodifiableList<? extends OrderField<?>> on) static @NotNull WindowSpecificationRowsStep
DSL.orderBy
(Collection<? extends OrderField<?>> fields) Create aWindowSpecification
with anORDER BY
clause.