This API is EXPERIMENTAL. Use at your own risk.
Purpose
This class provides a single namespace for jOOQ's query object model API.
Every QueryPart
from the DSL API has a matching QueryPart
representation in this query object model API, and a shared internal
implementation in the org.jooq.impl
package, that covers both
the DSL and model API functionality.
The goal of this model API is to allow for expression tree transformations
via QueryPart.$replace(Replacer)
as well as via per-querypart
methods, such as for example QOM.Substring.$startingPosition(Field)
, and
traversals via QueryPart.$traverse(Traverser)
that are independent of
the DSL API that would otherwise be too noisy for this task.
Design
In order to avoid conflicts between the model API and the DSL API, all model API in this class follows these naming conventions:
- All public model API types are nested in the
QOM
class, whereas DSL API types are top level types in theorg.jooq
package. - All accessor methods and their corresponding "immutable setters"
(returning a copy containing the modification) are named
$property()
, e.g.QOM.Substring.$startingPosition()
andQOM.Substring.$startingPosition(Field)
. - All private model API utility types are named
UXyz
, e.g.QOM.UEmpty
Limitations
The API offers public access to jOOQ's internal representation, and as such, is prone to incompatible changes between minor releases, in addition to the incompatible changes that may arise due to this API being experimental. In this experimental stage, the following limitations are accepted:
- Not all
QueryPart
implementations have a corresponding publicQueryPart
type yet, but may just implement the API via aQOM.UEmpty
orQOM.UNotYetImplemented
subtype, and may not provide access to contents via accessor methods. - Some child elements of a
QueryPart
may not yet be represented in the model API, such as for example theSELECT … FOR UPDATE
clause, as substantial changes to the internal model are still required before being able to offer public access to it.
Mutability
While some elements of this API are historically mutable (either mutable
objects are returned from QueryPart
subtypes, or argument objects
when constructing an QueryPart
remains mutable, rather than copied),
users must not rely on this mutable behaviour. Once this API stabilises, all
mutability will be gone, accidental remaining mutability will be considered a
bug.
Notes
A future Java 17 distribution of jOOQ might make use of sealed types to improve the usability of the model API in pattern matching expressions etc. Other Java language features that benefit pattern matching expression trees might be adopted in the future in this area of the jOOQ API.
- Author:
- Lukas Eder
-
Nested Class Summary
Modifier and TypeClassDescriptionstatic interface
TheABS
function.static interface
TheACOS
function.static interface
TheACOSH
function.static interface
TheACOTH
function.static interface
TheADD
operator.static interface
QOM.Aliasable<Q extends QueryPart>
static 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
TheAND
operator.static interface
TheANY VALUE
function.static interface
static interface
static interface
TheARRAY APPEND
function.static interface
TheARRAY CONCAT
function.static interface
TheARRAY GET
function.static interface
TheARRAY OVERLAP
function.static interface
TheARRAY PREPEND
function.static interface
static interface
TheARRAY REMOVE
function.static interface
TheARRAY REPLACE
function.static interface
TheASCII
function.static interface
TheASIN
function.static interface
TheASINH
function.static interface
static interface
TheATAN
function.static interface
TheATAN2
function.static interface
TheATANH
function.static interface
TheAVG
function.static interface
TheBETWEEN
predicate.static interface
TheBINARY BIT LENGTH
function.static interface
TheBINARY CONCAT
function.static interface
TheBINARY LENGTH
function.static interface
TheBINARY LTRIM
function.static interface
TheBINARY MD5
function.static interface
TheBINARY OCTET LENGTH
function.static interface
TheBINARY OVERLAY
function.static interface
TheBINARY POSITION
function.static interface
TheBINARY RTRIM
function.static interface
TheBINARY SUBSTRING
function.static interface
TheBINARY TRIM
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
QOM.BitGet<T extends Number>
TheBIT GET
function.static interface
TheBIT LENGTH
function.static interface
QOM.BitNand<T extends Number>
TheBIT NAND
operator.static interface
QOM.BitNandAgg<T extends Number>
TheBIT NAND AGG
function.static interface
QOM.BitNor<T extends Number>
TheBIT NOR
operator.static interface
QOM.BitNorAgg<T extends Number>
TheBIT NOR AGG
function.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.BitSet<T extends Number>
TheBIT SET
function.static interface
QOM.BitXNor<T extends Number>
TheBIT X NOR
operator.static interface
QOM.BitXNorAgg<T extends Number>
TheBIT X NOR AGG
function.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
TheCALL
statement.static interface
TheCARDINALITY
function.static enum
TheCascade
type.static interface
static interface
static interface
static interface
TheCBRT
function.static interface
TheCEIL
function.static interface
TheCHAR LENGTH
function.static interface
static interface
static interface
TheCHR
function.static interface
static interface
static interface
static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>
static interface
TheCOMMENT ON TABLE
statement.static interface
TheCOMMIT
statement.static interface
QOM.CompareCondition<T,
R extends QOM.CompareCondition<T, R>> 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
TheCONTAINS
operator.static interface
TheCONTAINS IGNORE CASE
operator.static interface
static interface
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
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
QOM.CreateSequence<T extends Number>
TheCREATE SEQUENCE
statement.static interface
TheCREATE TABLE
statement.static interface
TheCREATE TRIGGER
statement.static interface
TheCREATE TYPE
statement.static interface
QOM.CreateView<R extends Record>
TheCREATE VIEW
statement.static interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
static interface
static interface
TheCURRENT CATALOG
function.static interface
static interface
TheCURRENT SCHEMA
function.static interface
static interface
static interface
TheCURRENT USER
function.static enum
TheCycleOption
type.static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
TheDATE ADD
function.static interface
static interface
QOM.Decode<V,
T> static interface
static interface
TheDEGREES
function.static interface
QOM.Delete<R extends Record>
TheDELETE
statement.static interface
QOM.DeleteReturning<R extends Record>
AnDELETE
statement with aRETURNING
clause.static interface
TheDELETING
function.static interface
static interface
QOM.DerivedTable<R extends Record>
static enum
TheDeterministic
type.static interface
TheDIGITS
function.static interface
TheDIV
operator.static enum
TheDocumentOrContent
type.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
TheDROP TYPE
statement.static interface
TheDROP VIEW
statement.static interface
static interface
static interface
TheENDS WITH
operator.static interface
TheENDS WITH IGNORE CASE
operator.static interface
TheEQ
operator.static interface
TheEQ
operator.static interface
TheE
function.static interface
TheEXCLUDED
function.static interface
TheEXECUTE
function.static interface
TheEXISTS
function.static interface
static interface
TheEXP
function.static interface
static interface
ACondition
that is alwaysFALSE
.static interface
static interface
TheCONDITION
function.static interface
static interface
static interface
TheFLOOR
function.static interface
static enum
TheFrameExclude
type.static enum
TheFrameUnits
type.static enum
TheFromFirstOrLast
type.static interface
QOM.FullJoin<R extends Record>
static interface
static interface
TheGE
operator.static interface
static enum
TheGenerationLocation
type.static enum
TheGenerationOption
type.static interface
TheGE
operator.static interface
TheGOTO
function.static interface
TheGRANT
statement.static interface
static interface
static interface
TheGT
operator.static interface
TheGT
operator.static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static enum
TheIdentityRestartOption
type.static interface
static interface
static interface
TheIN
operator.static interface
TheIN
predicate accepting a list of values.static interface
QOM.Insert<R extends Record>
TheINSERT
statement.static interface
TheINSERTING
function.static interface
QOM.InsertReturning<R extends Record>
AnINSERT
statement with aRETURNING
clause.static interface
TheIS DISTINCT FROM
operator.static interface
TheIS DOCUMENT
operator.static interface
TheIS JSON
operator.static interface
TheIS NOT DISTINCT FROM
operator.static interface
TheIS NOT DOCUMENT
operator.static interface
TheIS NOT JSON
operator.static interface
TheIS NOT NULL
operator.static interface
TheIS NULL
operator.static interface
static enum
TheJoinHint
type.static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
TheJSON ARRAY
function.static interface
static interface
TheJSON ARRAY LENGTH
function.static interface
TheJSONB ARRAY LENGTH
function.static interface
TheJSONB GET ATTRIBUTE
function.static interface
TheJSONB GET ATTRIBUTE AS TEXT
function.static interface
TheJSONB GET ELEMENT
function.static interface
TheJSONB GET ELEMENT AS TEXT
function.static interface
TheJSONB INSERT
function.static interface
TheJSONB KEYS
function.static interface
TheJSONB REMOVE
function.static interface
TheJSONB REPLACE
function.static interface
TheJSONB SET
function.static interface
TheJSON GET ATTRIBUTE
function.static interface
TheJSON GET ATTRIBUTE AS TEXT
function.static interface
TheJSON GET ELEMENT
function.static interface
TheJSON GET ELEMENT AS TEXT
function.static interface
TheJSON INSERT
function.static interface
TheJSON KEYS
function.static interface
TheJSON OBJECT
function.static interface
static enum
TheJSONOnNull
type.static interface
TheJSON REMOVE
function.static interface
TheJSON REPLACE
function.static interface
TheJSON SET
function.static interface
static interface
static interface
static interface
static interface
QOM.Lateral<R extends Record>
static interface
TheLE
operator.static interface
static interface
static interface
TheLEFT
function.static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
TheLE
operator.static interface
TheLEVEL
function.static interface
TheLIKE
operator.static interface
TheLIKE IGNORE CASE
operator.static interface
TheLIKE
operator.static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
TheLN
function.static interface
TheLOG
function.static interface
TheLOG10
function.static interface
static interface
TheLOWER
function.static interface
TheLPAD
function.static interface
TheLT
operator.static interface
TheLT
operator.static interface
TheLTRIM
function.static enum
TheMaterialized
type.static interface
TheMAX
function.static interface
TheMD5
function.static interface
TheMEDIAN
function.static interface
TheMIN
function.static interface
TheMOD
operator.static interface
static interface
TheMUL
operator.static interface
QOM.Multiset<R extends Record>
static interface
QOM.MultisetAgg<R extends Record>
static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
TheNE
operator.static interface
static interface
TheNE
operator.static interface
TheNOT
operator.static interface
TheNOT
operator.static interface
TheNOT IN
operator.static interface
TheNOT IN
predicate accepting a list of values.static interface
TheNOT LIKE
operator.static interface
TheNOT LIKE IGNORE CASE
operator.static interface
TheNOT LIKE
operator.static interface
TheNOT SIMILAR TO
operator.static interface
TheNOT SIMILAR TO
operator.static class
Deprecated, for removal: This API element is subject to removal in a future version.- [#12425] - 3.16.0 - Missing implementations should be added as soon as possible!static interface
static interface
static interface
ACondition
that is alwaysNULL
.static enum
TheNullCallClause
type.static interface
TheNULLIF
function.static enum
TheNullOrdering
type.static interface
static enum
TheNullTreatment
type.static interface
TheNVL
function.static interface
static interface
TheOCTET LENGTH
function.static interface
TheOR
operator.static interface
QOM.OuterApply<R extends Record>
static interface
TheOVERLAY
function.static interface
static interface
ThePI
function.static interface
ThePLUS
operator.static interface
ThePOSITION
function.static interface
ThePOWER
operator.static interface
static interface
ThePRIOR
function.static interface
ThePRODUCT
function.static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
TheROWID
operator.static interface
static interface
static interface
QOM.QuantifiedSelect<R extends Record>
static enum
TheQuantifier
type.static interface
TheRADIANS
function.static interface
TheRAND
function.static interface
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
TheRELEASE SAVEPOINT
statement.static interface
TheREPEAT
function.static interface
TheREPLACE
function.static enum
TheResultOption
type.static interface
TheRETURN_
function.static interface
TheREVERSE
function.static interface
TheREVOKE
statement.static interface
TheRIGHT
function.static interface
QOM.RightJoin<R extends Record>
static interface
TheROLLBACK
statement.static interface
static interface
TheROOT
function.static interface
TheROUND
function.static interface
QOM.RowAsField<R extends Record>
static interface
static interface
TheROW EQ
operator.static interface
TheROW GE
operator.static interface
TheROW GT
operator.static interface
static interface
static interface
TheROW LE
operator.static interface
TheROW LT
operator.static interface
TheROW NE
operator.static interface
TheROWNUM
function.static interface
static interface
static interface
static interface
static interface
TheRPAD
function.static interface
TheRTRIM
function.static interface
TheSAVEPOINT
statement.static interface
static interface
static interface
static interface
TheSET CATALOG
statement.static interface
TheSET
statement.static interface
TheSET SCHEMA
statement.static interface
TheSHL
operator.static interface
TheSHR
operator.static interface
TheSIGN
function.static interface
TheSIGNAL SQL STATE
function.static interface
TheSIMILAR TO
operator.static interface
TheSIMILAR TO
operator.static interface
TheSIN
function.static interface
TheSINH
function.static interface
TheSPACE
function.static interface
TheSPLIT PART
function.static enum
TheSQLDataAccess
type.static interface
TheSQRT
function.static interface
QOM.Square<T extends Number>
TheSQUARE
function.static interface
TheST AREA
function.static interface
TheSTARTS WITH
operator.static interface
TheSTARTS WITH IGNORE CASE
operator.static interface
TheSTART TRANSACTION
statement.static interface
TheST ASBINARY
function.static interface
TheST ASTEXT
function.static interface
TheST CENTROID
function.static interface
QOM.StContains<T extends Spatial>
TheST CONTAINS
function.static interface
TheST CROSSES
function.static interface
TheSTDDEV POP
function.static interface
TheSTDDEV SAMP
function.static interface
QOM.StDifference<T extends Spatial>
TheST DIFFERENCE
function.static interface
QOM.StDisjoint<T extends Spatial>
TheST DISJOINT
function.static interface
QOM.StDistance<T extends Spatial>
TheST DISTANCE
function.static interface
QOM.StEndPoint<T extends Spatial>
TheST ENDPOINT
function.static interface
QOM.StEquals<T extends Spatial>
TheST EQUALS
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
QOM.StIntersects<T extends Spatial>
TheST INTERSECTS
function.static interface
TheST ISCLOSED
function.static interface
TheST ISEMPTY
function.static interface
TheST LENGTH
function.static interface
TheST NUMGEOMETRIES
function.static interface
TheST NUMINTERIORRING
function.static interface
TheST NUMPOINTS
function.static interface
QOM.StOverlaps<T extends Spatial>
TheST OVERLAPS
function.static interface
QOM.StPointN<T extends Spatial>
TheST POINTN
function.static interface
QOM.StraightJoin<R extends Record>
static interface
TheST SRID
function.static interface
QOM.StStartPoint<T extends Spatial>
TheST STARTPOINT
function.static interface
QOM.StTouches<T extends Spatial>
TheST TOUCHES
function.static interface
QOM.StUnion<T extends Spatial>
TheST UNION
function.static interface
QOM.StWithin<T extends Spatial>
TheST WITHIN
function.static interface
TheST X
function.static interface
TheST Y
function.static interface
TheST Z
function.static interface
TheSUB
operator.static interface
TheSUBSTRING
function.static interface
TheSUBSTRING INDEX
function.static interface
TheSUM
function.static interface
TheSYS CONNECT BY PATH
function.static interface
QOM.TableAlias<R extends Record>
static interface
QOM.TableAsField<R extends Record>
static enum
TheTableCommitAction
type.static interface
QOM.TableEq<R extends Record>
TheEQ
operator.static interface
QOM.TableNe<R extends Record>
TheNE
operator.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
ACondition
that is alwaysTRUE
.static interface
TheTRUNC
function.static interface
QOM.Truncate<R extends Record>
TheTRUNCATE
statement.static interface
TheTRY CAST
function.static interface
QOM.Tuple2<Q1 extends QueryPart,
Q2 extends QueryPart> A generic tuple of degree 2 for use inQOM
types.static interface
TheUNIQUE
function.static interface
static interface
QOM.UnmodifiableCollection<Q extends QueryPart>
An unmodifiableCollection
ofQueryPart
elements.static interface
QOM.UnmodifiableList<Q extends QueryPart>
static interface
QOM.UnmodifiableMap<K extends QueryPart,
V extends QueryPart> static interface
QOM.Update<R extends Record>
TheUPDATE
statement.static interface
QOM.UpdateReturning<R extends Record>
AnUPDATE
statement with aRETURNING
clause.static interface
TheUPDATING
function.static interface
TheUPPER
function.static interface
TheUUID
function.static interface
QOM.Values<R extends Record>
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
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static enum
TheWithOrWithoutData
type.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.static interface
static interface
TheXMLCOMMENT
function.static interface
TheXMLCONCAT
function.static interface
TheXMLDOCUMENT
function.static interface
static interface
static interface
TheXMLFOREST
function.static interface
static enum
TheXMLPassingMechanism
type.static interface
TheXMLPI
function.static interface
static interface
TheXMLSERIALIZE
function.static interface
TheXOR
operator. -
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionAbs()
TheABS
function.TheABS
function.static final QOM.Acos
Acos()
TheACOS
function.static final QOM.Acos
TheACOS
function.static final QOM.Acosh
Acosh()
TheACOSH
function.static final QOM.Acosh
TheACOSH
function.static final QOM.Acoth
Acoth()
TheACOTH
function.static final QOM.Acoth
TheACOTH
function.static final <T> QOM.Add<T>
Add()
TheADD
operator.static final <T> QOM.Add<T>
TheADD
operator.static final QOM.AlterDatabase
TheALTER DATABASE
statement.static final QOM.AlterDatabase
AlterDatabase
(Catalog database, boolean ifExists, Catalog renameTo) TheALTER DATABASE
statement.static final <T> QOM.AlterDomain<T>
TheALTER DOMAIN
statement.static final <T> QOM.AlterDomain<T>
AlterDomain
(Domain<T> domain, boolean ifExists, Constraint addConstraint, Constraint dropConstraint, boolean dropConstraintIfExists, Domain<?> renameTo, Constraint renameConstraint, boolean renameConstraintIfExists, Field<T> setDefault, boolean dropDefault, boolean setNotNull, boolean dropNotNull, QOM.Cascade cascade, Constraint renameConstraintTo) TheALTER DOMAIN
statement.static final QOM.AlterIndex
TheALTER INDEX
statement.static final QOM.AlterIndex
AlterIndex
(Index index, boolean ifExists, Table<?> on, Index renameTo) TheALTER INDEX
statement.static final QOM.AlterSchema
TheALTER SCHEMA
statement.static final QOM.AlterSchema
AlterSchema
(Schema schema, boolean ifExists, Schema renameTo) TheALTER SCHEMA
statement.static final <T extends Number>
QOM.AlterSequence<T>TheALTER SEQUENCE
statement.static final <T extends Number>
QOM.AlterSequence<T>AlterSequence
(Sequence<T> sequence, boolean ifExists, Sequence<?> renameTo, boolean restart, Field<T> restartWith, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache) TheALTER SEQUENCE
statement.static final QOM.AlterType
TheALTER TYPE
statement.static final QOM.AlterType
AlterType
(Name type, boolean ifExists, Name renameTo, Schema setSchema, Field<String> addValue, Field<String> renameValue, Field<String> renameValueTo) TheALTER TYPE
statement.static final QOM.AlterView
TheALTER VIEW
statement.static final QOM.AlterView
AlterView
(Table<?> view, Collection<? extends Field<?>> fields, boolean materialized, boolean ifExists, Comment comment, Table<?> renameTo, Select<?> as) TheALTER VIEW
statement.static final QOM.And
And()
TheAND
operator.static final QOM.And
TheAND
operator.static final <T> QOM.AnyValue<T>
AnyValue()
TheANY VALUE
function.static final <T> QOM.AnyValue<T>
TheANY VALUE
function.static final <T> QOM.ArrayAppend<T>
TheARRAY APPEND
function.static final <T> QOM.ArrayAppend<T>
ArrayAppend
(Field<T[]> arg1, Field<T> arg2) TheARRAY APPEND
function.static final <T> QOM.ArrayConcat<T>
TheARRAY CONCAT
function.static final <T> QOM.ArrayConcat<T>
ArrayConcat
(Field<T[]> arg1, Field<T[]> arg2) TheARRAY CONCAT
function.static final <T> QOM.ArrayGet<T>
ArrayGet()
TheARRAY GET
function.static final <T> QOM.ArrayGet<T>
TheARRAY GET
function.static final <T> QOM.ArrayOverlap<T>
TheARRAY OVERLAP
function.static final <T> QOM.ArrayOverlap<T>
ArrayOverlap
(Field<T[]> arg1, Field<T[]> arg2) TheARRAY OVERLAP
function.static final <T> QOM.ArrayPrepend<T>
TheARRAY PREPEND
function.static final <T> QOM.ArrayPrepend<T>
ArrayPrepend
(Field<T> arg1, Field<T[]> arg2) TheARRAY PREPEND
function.static final <T> QOM.ArrayRemove<T>
TheARRAY REMOVE
function.static final <T> QOM.ArrayRemove<T>
ArrayRemove
(Field<T[]> arg1, Field<T> arg2) TheARRAY REMOVE
function.static final <T> QOM.ArrayReplace<T>
TheARRAY REPLACE
function.static final <T> QOM.ArrayReplace<T>
ArrayReplace
(Field<T[]> arg1, Field<T> arg2, Field<T> arg3) TheARRAY REPLACE
function.static final QOM.Ascii
Ascii()
TheASCII
function.static final QOM.Ascii
TheASCII
function.static final QOM.Asin
Asin()
TheASIN
function.static final QOM.Asin
TheASIN
function.static final QOM.Asinh
Asinh()
TheASINH
function.static final QOM.Asinh
TheASINH
function.static final QOM.Atan
Atan()
TheATAN
function.static final QOM.Atan
TheATAN
function.static final QOM.Atan2
Atan2()
TheATAN2
function.static final QOM.Atan2
TheATAN2
function.static final QOM.Atanh
Atanh()
TheATANH
function.static final QOM.Atanh
TheATANH
function.static final QOM.Avg
Avg()
TheAVG
function.static final QOM.Avg
TheAVG
function.static final QOM.BinaryBitLength
TheBINARY BIT LENGTH
function.static final QOM.BinaryBitLength
BinaryBitLength
(Field<byte[]> bytes) TheBINARY BIT LENGTH
function.static final QOM.BinaryConcat
TheBINARY CONCAT
function.static final QOM.BinaryConcat
BinaryConcat
(Field<byte[]> bytes1, Field<byte[]> bytes2) TheBINARY CONCAT
function.static final QOM.BinaryLength
TheBINARY LENGTH
function.static final QOM.BinaryLength
BinaryLength
(Field<byte[]> bytes) TheBINARY LENGTH
function.static final QOM.BinaryLtrim
TheBINARY LTRIM
function.static final QOM.BinaryLtrim
BinaryLtrim
(Field<byte[]> bytes, Field<byte[]> characters) TheBINARY LTRIM
function.static final QOM.BinaryMd5
TheBINARY MD5
function.static final QOM.BinaryMd5
TheBINARY MD5
function.static final QOM.BinaryOctetLength
TheBINARY OCTET LENGTH
function.static final QOM.BinaryOctetLength
BinaryOctetLength
(Field<byte[]> bytes) TheBINARY OCTET LENGTH
function.static final QOM.BinaryOverlay
TheBINARY OVERLAY
function.static final QOM.BinaryOverlay
BinaryOverlay
(Field<byte[]> in, Field<byte[]> placing, Field<? extends Number> startIndex, Field<? extends Number> length) TheBINARY OVERLAY
function.static final QOM.BinaryPosition
TheBINARY POSITION
function.static final QOM.BinaryPosition
BinaryPosition
(Field<byte[]> in, Field<byte[]> search, Field<? extends Number> startIndex) TheBINARY POSITION
function.static final QOM.BinaryRtrim
TheBINARY RTRIM
function.static final QOM.BinaryRtrim
BinaryRtrim
(Field<byte[]> bytes, Field<byte[]> characters) TheBINARY RTRIM
function.static final QOM.BinarySubstring
TheBINARY SUBSTRING
function.static final QOM.BinarySubstring
BinarySubstring
(Field<byte[]> string, Field<? extends Number> startingPosition, Field<? extends Number> length) TheBINARY SUBSTRING
function.static final QOM.BinaryTrim
TheBINARY TRIM
function.static final QOM.BinaryTrim
BinaryTrim
(Field<byte[]> bytes, Field<byte[]> characters) TheBINARY TRIM
function.static final <T extends Number>
QOM.BitAnd<T>BitAnd()
TheBIT AND
operator.static final <T extends Number>
QOM.BitAnd<T>TheBIT AND
operator.static final <T extends Number>
QOM.BitAndAgg<T>TheBIT AND AGG
function.static final <T extends Number>
QOM.BitAndAgg<T>TheBIT AND AGG
function.static final QOM.BitCount
BitCount()
TheBIT COUNT
function.static final QOM.BitCount
TheBIT COUNT
function.static final <T extends Number>
QOM.BitGet<T>BitGet()
TheBIT GET
function.static final <T extends Number>
QOM.BitGet<T>TheBIT GET
function.static final QOM.BitLength
TheBIT LENGTH
function.static final QOM.BitLength
TheBIT LENGTH
function.static final <T extends Number>
QOM.BitNand<T>BitNand()
TheBIT NAND
operator.static final <T extends Number>
QOM.BitNand<T>TheBIT NAND
operator.static final <T extends Number>
QOM.BitNandAgg<T>TheBIT NAND AGG
function.static final <T extends Number>
QOM.BitNandAgg<T>BitNandAgg
(Field<T> value) TheBIT NAND AGG
function.static final <T extends Number>
QOM.BitNor<T>BitNor()
TheBIT NOR
operator.static final <T extends Number>
QOM.BitNor<T>TheBIT NOR
operator.static final <T extends Number>
QOM.BitNorAgg<T>TheBIT NOR AGG
function.static final <T extends Number>
QOM.BitNorAgg<T>TheBIT NOR AGG
function.static final <T extends Number>
QOM.BitNot<T>BitNot()
TheBIT NOT
operator.static final <T extends Number>
QOM.BitNot<T>TheBIT NOT
operator.BitOr()
TheBIT OR
operator.TheBIT OR
operator.static final <T extends Number>
QOM.BitOrAgg<T>BitOrAgg()
TheBIT OR AGG
function.static final <T extends Number>
QOM.BitOrAgg<T>TheBIT OR AGG
function.static final <T extends Number>
QOM.BitSet<T>BitSet()
TheBIT SET
function.static final <T extends Number>
QOM.BitSet<T>TheBIT SET
function.static final <T extends Number>
QOM.BitXNor<T>BitXNor()
TheBIT X NOR
operator.static final <T extends Number>
QOM.BitXNor<T>TheBIT X NOR
operator.static final <T extends Number>
QOM.BitXNorAgg<T>TheBIT X NOR AGG
function.static final <T extends Number>
QOM.BitXNorAgg<T>BitXNorAgg
(Field<T> value) TheBIT X NOR AGG
function.static final <T extends Number>
QOM.BitXor<T>BitXor()
TheBIT XOR
operator.static final <T extends Number>
QOM.BitXor<T>TheBIT XOR
operator.static final <T extends Number>
QOM.BitXorAgg<T>TheBIT XOR AGG
function.static final <T extends Number>
QOM.BitXorAgg<T>TheBIT XOR AGG
function.static final QOM.BoolAnd
BoolAnd()
TheBOOL AND
function.static final QOM.BoolAnd
TheBOOL AND
function.static final QOM.BoolOr
BoolOr()
TheBOOL OR
function.static final QOM.BoolOr
TheBOOL OR
function.static final QOM.Call
Call()
TheCALL
statement.static final QOM.Call
Call
(Name procedure, Collection<? extends Field<?>> args) TheCALL
statement.static final QOM.Cardinality
TheCARDINALITY
function.static final QOM.Cardinality
Cardinality
(Field<? extends Object[]> array) TheCARDINALITY
function.static final QOM.Cbrt
Cbrt()
TheCBRT
function.static final QOM.Cbrt
TheCBRT
function.Ceil()
TheCEIL
function.TheCEIL
function.static final QOM.CharLength
TheCHAR LENGTH
function.static final QOM.CharLength
CharLength
(Field<String> string) TheCHAR LENGTH
function.static final QOM.Chr
Chr()
TheCHR
function.static final QOM.Chr
TheCHR
function.static final QOM.CommentOn
TheCOMMENT ON TABLE
statement.static final QOM.CommentOn
CommentOn
(Table<?> table, boolean isView, boolean isMaterializedView, Field<?> field, Comment comment) TheCOMMENT ON TABLE
statement.static final QOM.Commit
Commit()
TheCOMMIT
statement.static final QOM.ConditionAsField
TheFIELD
function.static final QOM.ConditionAsField
ConditionAsField
(Condition condition) TheFIELD
function.static final QOM.ConnectByIsCycle
TheCONNECT BY ISCYCLE
function.static final QOM.ConnectByIsLeaf
TheCONNECT BY ISLEAF
function.static final <T> QOM.ConnectByRoot<T>
TheCONNECT BY ROOT
function.static final <T> QOM.ConnectByRoot<T>
ConnectByRoot
(Field<T> field) TheCONNECT BY ROOT
function.static final <T> QOM.Contains<T>
Contains()
TheCONTAINS
operator.static final <T> QOM.Contains<T>
TheCONTAINS
operator.static final <T> QOM.ContainsIgnoreCase<T>
TheCONTAINS IGNORE CASE
operator.static final <T> QOM.ContainsIgnoreCase<T>
ContainsIgnoreCase
(Field<T> value, Field<T> content) TheCONTAINS IGNORE CASE
operator.static final QOM.Corr
Corr()
TheCORR
function.static final QOM.Corr
TheCORR
function.static final QOM.Cos
Cos()
TheCOS
function.static final QOM.Cos
TheCOS
function.static final QOM.Cosh
Cosh()
TheCOSH
function.static final QOM.Cosh
TheCOSH
function.static final QOM.Cot
Cot()
TheCOT
function.static final QOM.Cot
TheCOT
function.static final QOM.Coth
Coth()
TheCOTH
function.static final QOM.Coth
TheCOTH
function.static final QOM.Count
Count()
TheCOUNT
function.static final QOM.Count
TheCOUNT
function.static final QOM.CovarPop
CovarPop()
TheCOVAR POP
function.static final QOM.CovarPop
TheCOVAR POP
function.static final QOM.CovarSamp
TheCOVAR SAMP
function.static final QOM.CovarSamp
TheCOVAR SAMP
function.static final QOM.CreateDatabase
TheCREATE DATABASE
statement.static final QOM.CreateDatabase
CreateDatabase
(Catalog database, boolean ifNotExists) TheCREATE DATABASE
statement.static final <T> QOM.CreateDomain<T>
TheCREATE DOMAIN
statement.static final <T> QOM.CreateDomain<T>
CreateDomain
(Domain<?> domain, boolean ifNotExists, DataType<T> dataType, Field<T> default_, Collection<? extends Constraint> constraints) TheCREATE DOMAIN
statement.static final QOM.CreateFunction
TheCREATE FUNCTION
statement.static final QOM.CreateFunction
CreateFunction
(Name function, boolean orReplace, Collection<? extends Parameter<?>> parameters, DataType<?> returns, Collection<? extends Field<?>> returnsTable, QOM.SQLDataAccess sqlDataAccess, QOM.NullCallClause returnsNullOnNullInput, QOM.Deterministic deterministic, Statement body) TheCREATE FUNCTION
statement.static final QOM.CreateIndex
TheCREATE INDEX
statement.static final QOM.CreateIndex
CreateIndex
(boolean unique, Index index, boolean ifNotExists, Table<?> table, Collection<? extends OrderField<?>> on, Collection<? extends Field<?>> include, Condition where, boolean excludeNullKeys) TheCREATE INDEX
statement.static final QOM.CreateProcedure
TheCREATE PROCEDURE
statement.static final QOM.CreateProcedure
CreateProcedure
(Name procedure, boolean orReplace, Collection<? extends Parameter<?>> parameters, QOM.SQLDataAccess sqlDataAccess, Statement body) TheCREATE PROCEDURE
statement.static final QOM.CreateSchema
TheCREATE SCHEMA
statement.static final QOM.CreateSchema
CreateSchema
(Schema schema, boolean ifNotExists) TheCREATE SCHEMA
statement.static final <T extends Number>
QOM.CreateSequence<T>TheCREATE SEQUENCE
statement.static final <T extends Number>
QOM.CreateSequence<T>CreateSequence
(Sequence<?> sequence, boolean ifNotExists, DataType<T> dataType, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache) TheCREATE SEQUENCE
statement.static final QOM.CreateTable
TheCREATE TABLE
statement.static final QOM.CreateTable
CreateTable
(Table<?> table, boolean temporary, boolean ifNotExists, Collection<? extends TableElement> tableElements, Select<?> select, QOM.WithOrWithoutData withData, QOM.TableCommitAction onCommit, Comment comment, SQL storage) TheCREATE TABLE
statement.static final QOM.CreateTrigger
TheCREATE TRIGGER
statement.static final QOM.CreateTrigger
CreateTrigger
(Trigger trigger, boolean orReplace, boolean before, boolean after, boolean insteadOf, boolean insert, boolean update, boolean delete, Collection<? extends Field<?>> of, Table<?> on, Name referencingOldAs, Name referencingNewAs, boolean forEachRow, boolean forEachStatement, Condition when, Statement body) TheCREATE TRIGGER
statement.static final QOM.CreateType
TheCREATE TYPE
statement.static final QOM.CreateType
CreateType
(Type<?> type, boolean ifNotExists, Collection<? extends Field<String>> values, Collection<? extends Field<?>> attributes) TheCREATE TYPE
statement.static final <R extends Record>
QOM.CreateView<R>TheCREATE VIEW
statement.static final <R extends Record>
QOM.CreateView<R>CreateView
(Table<?> view, Collection<? extends Field<?>> fields, boolean orReplace, boolean materialized, boolean ifNotExists, ResultQuery<? extends R> query) TheCREATE VIEW
statement.static final QOM.CurrentCatalog
TheCURRENT CATALOG
function.static final QOM.CurrentSchema
TheCURRENT SCHEMA
function.static final QOM.CurrentUser
TheCURRENT USER
function.static final <T> QOM.DateAdd<T>
DateAdd()
TheDATE ADD
function.static final <T> QOM.DateAdd<T>
TheDATE ADD
function.static final QOM.Degrees
Degrees()
TheDEGREES
function.static final QOM.Degrees
TheDEGREES
function.static final QOM.Deleting
Deleting()
TheDELETING
function.static final QOM.Digits
Digits()
TheDIGITS
function.static final QOM.Digits
TheDIGITS
function.static final <T> QOM.Div<T>
Div()
TheDIV
operator.static final <T> QOM.Div<T>
TheDIV
operator.static final QOM.DropDatabase
TheDROP DATABASE
statement.static final QOM.DropDatabase
DropDatabase
(Catalog database, boolean ifExists) TheDROP DATABASE
statement.static final QOM.DropDomain
TheDROP DOMAIN
statement.static final QOM.DropDomain
DropDomain
(Domain<?> domain, boolean ifExists, QOM.Cascade cascade) TheDROP DOMAIN
statement.static final QOM.DropFunction
TheDROP FUNCTION
statement.static final QOM.DropFunction
DropFunction
(Name function, boolean ifExists) TheDROP FUNCTION
statement.static final QOM.DropIndex
TheDROP INDEX
statement.static final QOM.DropIndex
DropIndex
(Index index, boolean ifExists, Table<?> on, QOM.Cascade cascade) TheDROP INDEX
statement.static final QOM.DropProcedure
TheDROP PROCEDURE
statement.static final QOM.DropProcedure
DropProcedure
(Name procedure, boolean ifExists) TheDROP PROCEDURE
statement.static final QOM.DropSchema
TheDROP SCHEMA
statement.static final QOM.DropSchema
DropSchema
(Schema schema, boolean ifExists, QOM.Cascade cascade) TheDROP SCHEMA
statement.static final QOM.DropSequence
TheDROP SEQUENCE
statement.static final QOM.DropSequence
DropSequence
(Sequence<?> sequence, boolean ifExists) TheDROP SEQUENCE
statement.static final QOM.DropTable
TheDROP TABLE
statement.static final QOM.DropTable
DropTable
(boolean temporary, Table<?> table, boolean ifExists, QOM.Cascade cascade) TheDROP TABLE
statement.static final QOM.DropTrigger
TheDROP TRIGGER
statement.static final QOM.DropTrigger
DropTrigger
(Trigger trigger, boolean ifExists, Table<?> on) TheDROP TRIGGER
statement.static final QOM.DropType
DropType()
TheDROP TYPE
statement.static final QOM.DropType
DropType
(Collection<? extends Type<?>> types, boolean ifExists, QOM.Cascade cascade) TheDROP TYPE
statement.static final QOM.DropView
DropView()
TheDROP VIEW
statement.static final QOM.DropView
TheDROP VIEW
statement.static final <T> QOM.EndsWith<T>
EndsWith()
TheENDS WITH
operator.static final <T> QOM.EndsWith<T>
TheENDS WITH
operator.static final <T> QOM.EndsWithIgnoreCase<T>
TheENDS WITH IGNORE CASE
operator.static final <T> QOM.EndsWithIgnoreCase<T>
EndsWithIgnoreCase
(Field<T> string, Field<T> suffix) TheENDS WITH IGNORE CASE
operator.static final <T> QOM.Eq<T>
Eq()
TheEQ
operator.static final <T> QOM.Eq<T>
TheEQ
operator.static final <T> QOM.EqQuantified<T>
TheEQ
operator.static final <T> QOM.EqQuantified<T>
EqQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheEQ
operator.static final QOM.Euler
Euler()
TheE
function.static final <T> QOM.Excluded<T>
Excluded()
TheEXCLUDED
function.static final <T> QOM.Excluded<T>
TheEXCLUDED
function.static final QOM.Execute
Execute()
TheEXECUTE
function.static final QOM.Execute
TheEXECUTE
function.static final QOM.Exists
Exists()
TheEXISTS
function.static final QOM.Exists
TheEXISTS
function.static final QOM.Exp
Exp()
TheEXP
function.static final QOM.Exp
TheEXP
function.static final QOM.FieldCondition
TheCONDITION
function.static final QOM.FieldCondition
FieldCondition
(Field<Boolean> field) TheCONDITION
function.Floor()
TheFLOOR
function.TheFLOOR
function.static final <T> QOM.Ge<T>
Ge()
TheGE
operator.static final <T> QOM.Ge<T>
TheGE
operator.static final <T> QOM.GeQuantified<T>
TheGE
operator.static final <T> QOM.GeQuantified<T>
GeQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheGE
operator.static final QOM.Goto
Goto()
TheGOTO
function.static final QOM.Goto
TheGOTO
function.static final QOM.Grant
Grant()
TheGRANT
statement.static final QOM.Grant
Grant
(Collection<? extends Privilege> privileges, Table<?> on, Role to, boolean toPublic, boolean withGrantOption) TheGRANT
statement.static final <T> QOM.Gt<T>
Gt()
TheGT
operator.static final <T> QOM.Gt<T>
TheGT
operator.static final <T> QOM.GtQuantified<T>
TheGT
operator.static final <T> QOM.GtQuantified<T>
GtQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheGT
operator.static final <T> QOM.In<T>
In()
TheIN
operator.static final <T> QOM.In<T>
TheIN
operator.static final QOM.Inserting
TheINSERTING
function.static final <T> QOM.IsDistinctFrom<T>
TheIS DISTINCT FROM
operator.static final <T> QOM.IsDistinctFrom<T>
IsDistinctFrom
(Field<T> arg1, Field<T> arg2) TheIS DISTINCT FROM
operator.static final QOM.IsDocument
TheIS DOCUMENT
operator.static final QOM.IsDocument
IsDocument
(Field<?> field) TheIS DOCUMENT
operator.static final QOM.IsJson
IsJson()
TheIS JSON
operator.static final QOM.IsJson
TheIS JSON
operator.static final <T> QOM.IsNotDistinctFrom<T>
TheIS NOT DISTINCT FROM
operator.static final <T> QOM.IsNotDistinctFrom<T>
IsNotDistinctFrom
(Field<T> arg1, Field<T> arg2) TheIS NOT DISTINCT FROM
operator.static final QOM.IsNotDocument
TheIS NOT DOCUMENT
operator.static final QOM.IsNotDocument
IsNotDocument
(Field<?> field) TheIS NOT DOCUMENT
operator.static final QOM.IsNotJson
TheIS NOT JSON
operator.static final QOM.IsNotJson
TheIS NOT JSON
operator.static final QOM.IsNotNull
TheIS NOT NULL
operator.static final QOM.IsNotNull
TheIS NOT NULL
operator.static final QOM.IsNull
IsNull()
TheIS NULL
operator.static final QOM.IsNull
TheIS NULL
operator.static final <T> QOM.JSONArray<T>
TheJSON ARRAY
function.static final <T> QOM.JSONArray<T>
JSONArray
(DataType<T> type, Collection<? extends Field<?>> fields, QOM.JSONOnNull onNull, DataType<?> returning) TheJSON ARRAY
function.static final QOM.JSONArrayLength
TheJSON ARRAY LENGTH
function.static final QOM.JSONArrayLength
JSONArrayLength
(Field<JSON> field) TheJSON ARRAY LENGTH
function.static final QOM.JSONBArrayLength
TheJSONB ARRAY LENGTH
function.static final QOM.JSONBArrayLength
JSONBArrayLength
(Field<JSONB> field) TheJSONB ARRAY LENGTH
function.static final QOM.JSONBGetAttribute
TheJSONB GET ATTRIBUTE
function.static final QOM.JSONBGetAttribute
JSONBGetAttribute
(Field<JSONB> field, Field<String> attribute) TheJSONB GET ATTRIBUTE
function.static final QOM.JSONBGetAttributeAsText
TheJSONB GET ATTRIBUTE AS TEXT
function.static final QOM.JSONBGetAttributeAsText
JSONBGetAttributeAsText
(Field<JSONB> field, Field<String> attribute) TheJSONB GET ATTRIBUTE AS TEXT
function.static final QOM.JSONBGetElement
TheJSONB GET ELEMENT
function.static final QOM.JSONBGetElement
JSONBGetElement
(Field<JSONB> field, Field<Integer> index) TheJSONB GET ELEMENT
function.static final QOM.JSONBGetElementAsText
TheJSONB GET ELEMENT AS TEXT
function.static final QOM.JSONBGetElementAsText
JSONBGetElementAsText
(Field<JSONB> field, Field<Integer> index) TheJSONB GET ELEMENT AS TEXT
function.static final QOM.JSONBInsert
TheJSONB INSERT
function.static final QOM.JSONBInsert
TheJSONB INSERT
function.static final QOM.JSONBKeys
TheJSONB KEYS
function.static final QOM.JSONBKeys
TheJSONB KEYS
function.static final QOM.JSONBRemove
TheJSONB REMOVE
function.static final QOM.JSONBRemove
JSONBRemove
(Field<JSONB> field, Field<String> path) TheJSONB REMOVE
function.static final QOM.JSONBReplace
TheJSONB REPLACE
function.static final QOM.JSONBReplace
TheJSONB REPLACE
function.static final QOM.JSONBSet
JSONBSet()
TheJSONB SET
function.static final QOM.JSONBSet
TheJSONB SET
function.static final QOM.JSONGetAttribute
TheJSON GET ATTRIBUTE
function.static final QOM.JSONGetAttribute
JSONGetAttribute
(Field<JSON> field, Field<String> attribute) TheJSON GET ATTRIBUTE
function.static final QOM.JSONGetAttributeAsText
TheJSON GET ATTRIBUTE AS TEXT
function.static final QOM.JSONGetAttributeAsText
JSONGetAttributeAsText
(Field<JSON> field, Field<String> attribute) TheJSON GET ATTRIBUTE AS TEXT
function.static final QOM.JSONGetElement
TheJSON GET ELEMENT
function.static final QOM.JSONGetElement
JSONGetElement
(Field<JSON> field, Field<Integer> index) TheJSON GET ELEMENT
function.static final QOM.JSONGetElementAsText
TheJSON GET ELEMENT AS TEXT
function.static final QOM.JSONGetElementAsText
JSONGetElementAsText
(Field<JSON> field, Field<Integer> index) TheJSON GET ELEMENT AS TEXT
function.static final QOM.JSONInsert
TheJSON INSERT
function.static final QOM.JSONInsert
TheJSON INSERT
function.static final QOM.JSONKeys
JSONKeys()
TheJSON KEYS
function.static final QOM.JSONKeys
TheJSON KEYS
function.static final <T> QOM.JSONObject<T>
TheJSON OBJECT
function.static final <T> QOM.JSONObject<T>
JSONObject
(DataType<T> type, Collection<? extends JSONEntry<?>> entries, QOM.JSONOnNull onNull, DataType<?> returning) TheJSON OBJECT
function.static final QOM.JSONRemove
TheJSON REMOVE
function.static final QOM.JSONRemove
JSONRemove
(Field<JSON> field, Field<String> path) TheJSON REMOVE
function.static final QOM.JSONReplace
TheJSON REPLACE
function.static final QOM.JSONReplace
TheJSON REPLACE
function.static final QOM.JSONSet
JSONSet()
TheJSON SET
function.static final QOM.JSONSet
TheJSON SET
function.static final <T> QOM.Le<T>
Le()
TheLE
operator.static final <T> QOM.Le<T>
TheLE
operator.static final QOM.Left
Left()
TheLEFT
function.static final QOM.Left
TheLEFT
function.static final <T> QOM.LeQuantified<T>
TheLE
operator.static final <T> QOM.LeQuantified<T>
LeQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheLE
operator.static final QOM.Level
Level()
TheLEVEL
function.static final QOM.Like
Like()
TheLIKE
operator.static final QOM.Like
TheLIKE
operator.static final QOM.LikeIgnoreCase
TheLIKE IGNORE CASE
operator.static final QOM.LikeIgnoreCase
LikeIgnoreCase
(Field<?> value, Field<String> pattern, Character escape) TheLIKE IGNORE CASE
operator.static final QOM.LikeQuantified
TheLIKE
operator.static final QOM.LikeQuantified
LikeQuantified
(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheLIKE
operator.static final QOM.Ln
Ln()
TheLN
function.static final QOM.Ln
TheLN
function.static final QOM.Log
Log()
TheLOG
function.static final QOM.Log
TheLOG
function.static final QOM.Log10
Log10()
TheLOG10
function.static final QOM.Log10
TheLOG10
function.static final QOM.Lower
Lower()
TheLOWER
function.static final QOM.Lower
TheLOWER
function.static final QOM.Lpad
Lpad()
TheLPAD
function.static final QOM.Lpad
TheLPAD
function.static final <T> QOM.Lt<T>
Lt()
TheLT
operator.static final <T> QOM.Lt<T>
TheLT
operator.static final <T> QOM.LtQuantified<T>
TheLT
operator.static final <T> QOM.LtQuantified<T>
LtQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheLT
operator.static final QOM.Ltrim
Ltrim()
TheLTRIM
function.static final QOM.Ltrim
TheLTRIM
function.static final <T> QOM.Max<T>
Max()
TheMAX
function.static final <T> QOM.Max<T>
TheMAX
function.static final QOM.Md5
Md5()
TheMD5
function.static final QOM.Md5
TheMD5
function.static final QOM.Median
Median()
TheMEDIAN
function.static final QOM.Median
TheMEDIAN
function.static final <T> QOM.Min<T>
Min()
TheMIN
function.static final <T> QOM.Min<T>
TheMIN
function.Mod()
TheMOD
operator.TheMOD
operator.static final <T> QOM.Mul<T>
Mul()
TheMUL
operator.static final <T> QOM.Mul<T>
TheMUL
operator.static final <T> QOM.Ne<T>
Ne()
TheNE
operator.static final <T> QOM.Ne<T>
TheNE
operator.static final <T> QOM.NeQuantified<T>
TheNE
operator.static final <T> QOM.NeQuantified<T>
NeQuantified
(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheNE
operator.static final QOM.Not
Not()
TheNOT
operator.static final QOM.Not
TheNOT
operator.static final QOM.NotField
NotField()
TheNOT
operator.static final QOM.NotField
TheNOT
operator.static final <T> QOM.NotIn<T>
NotIn()
TheNOT IN
operator.static final <T> QOM.NotIn<T>
TheNOT IN
operator.static final QOM.NotLike
NotLike()
TheNOT LIKE
operator.static final QOM.NotLike
TheNOT LIKE
operator.static final QOM.NotLikeIgnoreCase
TheNOT LIKE IGNORE CASE
operator.static final QOM.NotLikeIgnoreCase
NotLikeIgnoreCase
(Field<?> value, Field<String> pattern, Character escape) TheNOT LIKE IGNORE CASE
operator.static final QOM.NotLikeQuantified
TheNOT LIKE
operator.static final QOM.NotLikeQuantified
NotLikeQuantified
(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheNOT LIKE
operator.static final QOM.NotSimilarTo
TheNOT SIMILAR TO
operator.static final QOM.NotSimilarTo
NotSimilarTo
(Field<?> value, Field<String> pattern, Character escape) TheNOT SIMILAR TO
operator.static final QOM.NotSimilarToQuantified
TheNOT SIMILAR TO
operator.static final QOM.NotSimilarToQuantified
NotSimilarToQuantified
(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheNOT SIMILAR TO
operator.static final <T> QOM.Nullif<T>
Nullif()
TheNULLIF
function.static final <T> QOM.Nullif<T>
TheNULLIF
function.static final <T> QOM.Nvl<T>
Nvl()
TheNVL
function.static final <T> QOM.Nvl<T>
TheNVL
function.static final QOM.OctetLength
TheOCTET LENGTH
function.static final QOM.OctetLength
OctetLength
(Field<String> string) TheOCTET LENGTH
function.static final QOM.Or
Or()
TheOR
operator.static final QOM.Or
TheOR
operator.static final QOM.Overlay
Overlay()
TheOVERLAY
function.static final QOM.Overlay
Overlay
(Field<String> in, Field<String> placing, Field<? extends Number> startIndex, Field<? extends Number> length) TheOVERLAY
function.static final QOM.Pi
Pi()
ThePI
function.static final <T> QOM.PlusJoin<T>
PlusJoin()
ThePLUS
operator.static final <T> QOM.PlusJoin<T>
ThePLUS
operator.static final QOM.Position
Position()
ThePOSITION
function.static final QOM.Position
ThePOSITION
function.static final QOM.Power
Power()
ThePOWER
operator.static final QOM.Power
ThePOWER
operator.static final <T> QOM.Prior<T>
Prior()
ThePRIOR
function.static final <T> QOM.Prior<T>
ThePRIOR
function.static final QOM.Product
Product()
ThePRODUCT
function.static final QOM.Product
ThePRODUCT
function.static final QOM.QualifiedRowid
TheROWID
operator.static final QOM.QualifiedRowid
QualifiedRowid
(Table<?> table) TheROWID
operator.static final QOM.Radians
Radians()
TheRADIANS
function.static final QOM.Radians
TheRADIANS
function.static final QOM.Rand
Rand()
TheRAND
function.static final QOM.RegrAvgX
RegrAvgX()
TheREGR AVGX
function.static final QOM.RegrAvgX
TheREGR AVGX
function.static final QOM.RegrAvgY
RegrAvgY()
TheREGR AVGY
function.static final QOM.RegrAvgY
TheREGR AVGY
function.static final QOM.RegrCount
TheREGR COUNT
function.static final QOM.RegrCount
TheREGR COUNT
function.static final QOM.RegrIntercept
TheREGR INTERCEPT
function.static final QOM.RegrIntercept
RegrIntercept
(Field<? extends Number> y, Field<? extends Number> x) TheREGR INTERCEPT
function.static final QOM.RegrR2
RegrR2()
TheREGR R2
function.static final QOM.RegrR2
TheREGR R2
function.static final QOM.RegrSlope
TheREGR SLOPE
function.static final QOM.RegrSlope
TheREGR SLOPE
function.static final QOM.RegrSxx
RegrSxx()
TheREGR SXX
function.static final QOM.RegrSxx
TheREGR SXX
function.static final QOM.RegrSxy
RegrSxy()
TheREGR SXY
function.static final QOM.RegrSxy
TheREGR SXY
function.static final QOM.RegrSyy
RegrSyy()
TheREGR SYY
function.static final QOM.RegrSyy
TheREGR SYY
function.static final QOM.ReleaseSavepoint
TheRELEASE SAVEPOINT
statement.static final QOM.ReleaseSavepoint
ReleaseSavepoint
(Name name) TheRELEASE SAVEPOINT
statement.static final QOM.Repeat
Repeat()
TheREPEAT
function.static final QOM.Repeat
TheREPEAT
function.static final QOM.Replace
Replace()
TheREPLACE
function.static final QOM.Replace
TheREPLACE
function.static final QOM.Return
Return()
TheRETURN_
function.static final QOM.Return
TheRETURN_
function.static final QOM.Reverse
Reverse()
TheREVERSE
function.static final QOM.Reverse
TheREVERSE
function.static final QOM.Revoke
Revoke()
TheREVOKE
statement.static final QOM.Revoke
Revoke
(Collection<? extends Privilege> privileges, boolean grantOptionFor, Table<?> on, Role from, boolean fromPublic) TheREVOKE
statement.static final QOM.Right
Right()
TheRIGHT
function.static final QOM.Right
TheRIGHT
function.static final QOM.Rollback
Rollback()
TheROLLBACK
statement.static final QOM.Rollback
TheROLLBACK
statement.static final QOM.Root
Root()
TheROOT
function.static final QOM.Root
TheROOT
function.Round()
TheROUND
function.TheROUND
function.RowEq()
TheROW EQ
operator.RowEq
(T arg1, T arg2) TheROW EQ
operator.RowGe()
TheROW GE
operator.RowGe
(T arg1, T arg2) TheROW GE
operator.RowGt()
TheROW GT
operator.RowGt
(T arg1, T arg2) TheROW GT
operator.RowLe()
TheROW LE
operator.RowLe
(T arg1, T arg2) TheROW LE
operator.RowLt()
TheROW LT
operator.RowLt
(T arg1, T arg2) TheROW LT
operator.RowNe()
TheROW NE
operator.RowNe
(T arg1, T arg2) TheROW NE
operator.static final QOM.Rownum
Rownum()
TheROWNUM
function.static final QOM.Rpad
Rpad()
TheRPAD
function.static final QOM.Rpad
TheRPAD
function.static final QOM.Rtrim
Rtrim()
TheRTRIM
function.static final QOM.Rtrim
TheRTRIM
function.static final QOM.Savepoint
TheSAVEPOINT
statement.static final QOM.Savepoint
TheSAVEPOINT
statement.static final QOM.SetCatalog
TheSET CATALOG
statement.static final QOM.SetCatalog
SetCatalog
(Catalog catalog) TheSET CATALOG
statement.static final QOM.SetCommand
TheSET
statement.static final QOM.SetCommand
SetCommand
(Name name, Param<?> value, boolean local) TheSET
statement.static final QOM.SetSchema
TheSET SCHEMA
statement.static final QOM.SetSchema
TheSET SCHEMA
statement.Shl()
TheSHL
operator.TheSHL
operator.Shr()
TheSHR
operator.TheSHR
operator.static final QOM.Sign
Sign()
TheSIGN
function.static final QOM.Sign
TheSIGN
function.static final QOM.Signal
Signal()
TheSIGNAL SQL STATE
function.static final QOM.Signal
TheSIGNAL SQL STATE
function.static final QOM.SimilarTo
TheSIMILAR TO
operator.static final QOM.SimilarTo
TheSIMILAR TO
operator.static final QOM.SimilarToQuantified
TheSIMILAR TO
operator.static final QOM.SimilarToQuantified
SimilarToQuantified
(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheSIMILAR TO
operator.static final QOM.Sin
Sin()
TheSIN
function.static final QOM.Sin
TheSIN
function.static final QOM.Sinh
Sinh()
TheSINH
function.static final QOM.Sinh
TheSINH
function.static final QOM.Space
Space()
TheSPACE
function.static final QOM.Space
TheSPACE
function.static final QOM.SplitPart
TheSPLIT PART
function.static final QOM.SplitPart
TheSPLIT PART
function.static final QOM.Sqrt
Sqrt()
TheSQRT
function.static final QOM.Sqrt
TheSQRT
function.static final <T extends Number>
QOM.Square<T>Square()
TheSQUARE
function.static final <T extends Number>
QOM.Square<T>TheSQUARE
function.static final QOM.StArea
StArea()
TheST AREA
function.static final QOM.StArea
TheST AREA
function.static final <T> QOM.StartsWith<T>
TheSTARTS WITH
operator.static final <T> QOM.StartsWith<T>
StartsWith
(Field<T> string, Field<T> prefix) TheSTARTS WITH
operator.static final <T> QOM.StartsWithIgnoreCase<T>
TheSTARTS WITH IGNORE CASE
operator.static final <T> QOM.StartsWithIgnoreCase<T>
StartsWithIgnoreCase
(Field<T> string, Field<T> prefix) TheSTARTS WITH IGNORE CASE
operator.static final QOM.StartTransaction
TheSTART TRANSACTION
statement.static final QOM.StAsBinary
TheST ASBINARY
function.static final QOM.StAsBinary
StAsBinary
(Field<? extends Spatial> value) TheST ASBINARY
function.static final QOM.StAsText
StAsText()
TheST ASTEXT
function.static final QOM.StAsText
TheST ASTEXT
function.static final QOM.StCentroid
TheST CENTROID
function.static final QOM.StCentroid
StCentroid
(Field<Geometry> value) TheST CENTROID
function.static final <T extends Spatial>
QOM.StContains<T>TheST CONTAINS
function.static final <T extends Spatial>
QOM.StContains<T>StContains
(Field<T> arg1, Field<T> arg2) TheST CONTAINS
function.static final QOM.StCrosses
TheST CROSSES
function.static final QOM.StCrosses
TheST CROSSES
function.static final QOM.StddevPop
TheSTDDEV POP
function.static final QOM.StddevPop
TheSTDDEV POP
function.static final QOM.StddevSamp
TheSTDDEV SAMP
function.static final QOM.StddevSamp
StddevSamp
(Field<? extends Number> field) TheSTDDEV SAMP
function.static final <T extends Spatial>
QOM.StDifference<T>TheST DIFFERENCE
function.static final <T extends Spatial>
QOM.StDifference<T>StDifference
(Field<T> arg1, Field<T> arg2) TheST DIFFERENCE
function.static final <T extends Spatial>
QOM.StDisjoint<T>TheST DISJOINT
function.static final <T extends Spatial>
QOM.StDisjoint<T>StDisjoint
(Field<T> arg1, Field<T> arg2) TheST DISJOINT
function.static final <T extends Spatial>
QOM.StDistance<T>TheST DISTANCE
function.static final <T extends Spatial>
QOM.StDistance<T>StDistance
(Field<T> arg1, Field<T> arg2) TheST DISTANCE
function.static final <T extends Spatial>
QOM.StEndPoint<T>TheST ENDPOINT
function.static final <T extends Spatial>
QOM.StEndPoint<T>StEndPoint
(Field<T> value) TheST ENDPOINT
function.static final <T extends Spatial>
QOM.StEquals<T>StEquals()
TheST EQUALS
function.static final <T extends Spatial>
QOM.StEquals<T>TheST EQUALS
function.static final QOM.StExteriorRing
TheST EXTERIORRING
function.static final QOM.StExteriorRing
StExteriorRing
(Field<Geometry> value) TheST EXTERIORRING
function.static final <T extends Spatial>
QOM.StGeometryN<T>TheST GEOMETRYN
function.static final <T extends Spatial>
QOM.StGeometryN<T>StGeometryN
(Field<T> value, Field<? extends Number> position) TheST GEOMETRYN
function.static final QOM.StGeometryType
TheST GEOMETRYTYPE
function.static final QOM.StGeometryType
StGeometryType
(Field<? extends Spatial> value) TheST GEOMETRYTYPE
function.static final QOM.StGeomFromText
TheST GEOMFROMTEXT
function.static final QOM.StGeomFromText
StGeomFromText
(Field<String> text, Field<? extends Number> srid) TheST GEOMFROMTEXT
function.static final QOM.StGeomFromWKB
TheST GEOMFROMWKB
function.static final QOM.StGeomFromWKB
StGeomFromWKB
(Field<byte[]> wkb, Field<? extends Number> srid) TheST GEOMFROMWKB
function.static final QOM.StInteriorRingN
TheST INTERIORRINGN
function.static final QOM.StInteriorRingN
StInteriorRingN
(Field<Geometry> value, Field<? extends Number> position) TheST INTERIORRINGN
function.static final <T extends Spatial>
QOM.StIntersection<T>TheST INTERSECTION
function.static final <T extends Spatial>
QOM.StIntersection<T>StIntersection
(Field<T> arg1, Field<T> arg2) TheST INTERSECTION
function.static final <T extends Spatial>
QOM.StIntersects<T>TheST INTERSECTS
function.static final <T extends Spatial>
QOM.StIntersects<T>StIntersects
(Field<T> arg1, Field<T> arg2) TheST INTERSECTS
function.static final QOM.StIsClosed
TheST ISCLOSED
function.static final QOM.StIsClosed
StIsClosed
(Field<? extends Spatial> value) TheST ISCLOSED
function.static final QOM.StIsEmpty
TheST ISEMPTY
function.static final QOM.StIsEmpty
TheST ISEMPTY
function.static final QOM.StLength
StLength()
TheST LENGTH
function.static final QOM.StLength
TheST LENGTH
function.static final QOM.StNumGeometries
TheST NUMGEOMETRIES
function.static final QOM.StNumGeometries
StNumGeometries
(Field<? extends Spatial> value) TheST NUMGEOMETRIES
function.static final QOM.StNumInteriorRings
TheST NUMINTERIORRING
function.static final QOM.StNumInteriorRings
StNumInteriorRings
(Field<Geometry> value) TheST NUMINTERIORRING
function.static final QOM.StNumPoints
TheST NUMPOINTS
function.static final QOM.StNumPoints
StNumPoints
(Field<? extends Spatial> value) TheST NUMPOINTS
function.static final <T extends Spatial>
QOM.StOverlaps<T>TheST OVERLAPS
function.static final <T extends Spatial>
QOM.StOverlaps<T>StOverlaps
(Field<T> arg1, Field<T> arg2) TheST OVERLAPS
function.static final <T extends Spatial>
QOM.StPointN<T>StPointN()
TheST POINTN
function.static final <T extends Spatial>
QOM.StPointN<T>TheST POINTN
function.static final QOM.StSrid
StSrid()
TheST SRID
function.static final QOM.StSrid
TheST SRID
function.static final <T extends Spatial>
QOM.StStartPoint<T>TheST STARTPOINT
function.static final <T extends Spatial>
QOM.StStartPoint<T>StStartPoint
(Field<T> value) TheST STARTPOINT
function.static final <T extends Spatial>
QOM.StTouches<T>TheST TOUCHES
function.static final <T extends Spatial>
QOM.StTouches<T>TheST TOUCHES
function.static final <T extends Spatial>
QOM.StUnion<T>StUnion()
TheST UNION
function.static final <T extends Spatial>
QOM.StUnion<T>TheST UNION
function.static final <T extends Spatial>
QOM.StWithin<T>StWithin()
TheST WITHIN
function.static final <T extends Spatial>
QOM.StWithin<T>TheST WITHIN
function.static final QOM.StX
StX()
TheST X
function.static final QOM.StX
TheST X
function.static final QOM.StY
StY()
TheST Y
function.static final QOM.StY
TheST Y
function.static final QOM.StZ
StZ()
TheST Z
function.static final QOM.StZ
TheST Z
function.static final <T> QOM.Sub<T>
Sub()
TheSUB
operator.static final <T> QOM.Sub<T>
TheSUB
operator.static final QOM.Substring
TheSUBSTRING
function.static final QOM.Substring
Substring
(Field<String> string, Field<? extends Number> startingPosition, Field<? extends Number> length) TheSUBSTRING
function.static final QOM.SubstringIndex
TheSUBSTRING INDEX
function.static final QOM.SubstringIndex
TheSUBSTRING INDEX
function.static final QOM.Sum
Sum()
TheSUM
function.static final QOM.Sum
TheSUM
function.static final QOM.SysConnectByPath
TheSYS CONNECT BY PATH
function.static final QOM.SysConnectByPath
SysConnectByPath
(Field<?> field, String separator) TheSYS CONNECT BY PATH
function.static final <R extends Record>
QOM.TableEq<R>TableEq()
TheEQ
operator.static final <R extends Record>
QOM.TableEq<R>TheEQ
operator.static final <R extends Record>
QOM.TableNe<R>TableNe()
TheNE
operator.static final <R extends Record>
QOM.TableNe<R>TheNE
operator.static final QOM.Tan
Tan()
TheTAN
function.static final QOM.Tan
TheTAN
function.static final QOM.Tanh
Tanh()
TheTANH
function.static final QOM.Tanh
TheTANH
function.static final QOM.Tau
Tau()
TheTAU
function.static final QOM.ToChar
ToChar()
TheTO CHAR
function.static final QOM.ToChar
TheTO CHAR
function.static final QOM.ToDate
ToDate()
TheTO DATE
function.static final QOM.ToDate
TheTO DATE
function.static final QOM.ToHex
ToHex()
TheTO HEX
function.static final QOM.ToHex
TheTO HEX
function.static final QOM.ToTimestamp
TheTO TIMESTAMP
function.static final QOM.ToTimestamp
ToTimestamp
(Field<String> value, Field<String> formatMask) TheTO TIMESTAMP
function.static final QOM.Translate
TheTRANSLATE
function.static final QOM.Translate
TheTRANSLATE
function.static final QOM.Trim
Trim()
TheTRIM
function.static final QOM.Trim
TheTRIM
function.Trunc()
TheTRUNC
function.TheTRUNC
function.static final <R extends Record>
QOM.Truncate<R>Truncate()
TheTRUNCATE
statement.static final <R extends Record>
QOM.Truncate<R>Truncate
(Collection<? extends Table<?>> table, QOM.IdentityRestartOption restartIdentity, QOM.Cascade cascade) TheTRUNCATE
statement.static final <T> QOM.TryCast<T>
TryCast()
TheTRY CAST
function.static final <T> QOM.TryCast<T>
TheTRY CAST
function.static final <Q1 extends QueryPart,
Q2 extends QueryPart>
QOM.Tuple2<Q1,Q2> tuple
(Q1 q1, Q2 q2) static final QOM.Unique
Unique()
TheUNIQUE
function.static final QOM.Unique
TheUNIQUE
function.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q>unmodifiable
(Collection<Q> collection) Turn aCollection
into an unmodifiableQOM.UnmodifiableList
.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q>unmodifiable
(List<Q> list) Turn aList
into an unmodifiableQOM.UnmodifiableList
.static final <K extends QueryPart,
V extends QueryPart>
QOM.UnmodifiableMap<K,V> unmodifiable
(Map<K, V> map) Turn aMap
into an unmodifiableQOM.UnmodifiableMap
.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q>unmodifiable
(Q[] array) Turn an array into an unmodifiableQOM.UnmodifiableList
.static final QOM.Updating
Updating()
TheUPDATING
function.static final QOM.Upper
Upper()
TheUPPER
function.static final QOM.Upper
TheUPPER
function.static final QOM.Uuid
Uuid()
TheUUID
function.static final QOM.VarPop
VarPop()
TheVAR POP
function.static final QOM.VarPop
TheVAR POP
function.static final QOM.VarSamp
VarSamp()
TheVAR SAMP
function.static final QOM.VarSamp
TheVAR SAMP
function.static final <T extends Number>
QOM.WidthBucket<T>TheWIDTH BUCKET
function.static final <T extends Number>
QOM.WidthBucket<T>TheWIDTH BUCKET
function.static final QOM.XMLComment
TheXMLCOMMENT
function.static final QOM.XMLComment
XMLComment
(Field<String> comment) TheXMLCOMMENT
function.static final QOM.XMLConcat
TheXMLCONCAT
function.static final QOM.XMLConcat
XMLConcat
(Collection<? extends Field<?>> args) TheXMLCONCAT
function.static final QOM.XMLDocument
TheXMLDOCUMENT
function.static final QOM.XMLDocument
XMLDocument
(Field<XML> content) TheXMLDOCUMENT
function.static final QOM.XMLForest
TheXMLFOREST
function.static final QOM.XMLForest
XMLForest
(Collection<? extends Field<?>> fields) TheXMLFOREST
function.static final QOM.XMLPi
XMLPi()
TheXMLPI
function.static final QOM.XMLPi
TheXMLPI
function.static final <T> QOM.XMLSerialize<T>
TheXMLSERIALIZE
function.static final <T> QOM.XMLSerialize<T>
XMLSerialize
(boolean content, Field<XML> value, DataType<T> type) TheXMLSERIALIZE
function.static final QOM.Xor
Xor()
TheXOR
operator.static final QOM.Xor
TheXOR
operator.
-
Constructor Details
-
QOM
public QOM()
-
-
Method Details
-
AlterDatabase
TheALTER DATABASE
statement. -
AlterDatabase
public static final QOM.AlterDatabase AlterDatabase(Catalog database, boolean ifExists, Catalog renameTo) TheALTER DATABASE
statement. -
AlterDomain
TheALTER DOMAIN
statement. -
AlterDomain
public static final <T> QOM.AlterDomain<T> AlterDomain(Domain<T> domain, boolean ifExists, Constraint addConstraint, Constraint dropConstraint, boolean dropConstraintIfExists, Domain<?> renameTo, Constraint renameConstraint, boolean renameConstraintIfExists, Field<T> setDefault, boolean dropDefault, boolean setNotNull, boolean dropNotNull, QOM.Cascade cascade, Constraint renameConstraintTo) TheALTER DOMAIN
statement. -
AlterIndex
TheALTER INDEX
statement. -
AlterIndex
public static final QOM.AlterIndex AlterIndex(Index index, boolean ifExists, Table<?> on, Index renameTo) TheALTER INDEX
statement. -
AlterSchema
TheALTER SCHEMA
statement. -
AlterSchema
TheALTER SCHEMA
statement. -
AlterSequence
TheALTER SEQUENCE
statement. -
AlterSequence
public static final <T extends Number> QOM.AlterSequence<T> AlterSequence(Sequence<T> sequence, boolean ifExists, Sequence<?> renameTo, boolean restart, Field<T> restartWith, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache) TheALTER SEQUENCE
statement. -
AlterType
TheALTER TYPE
statement. -
AlterType
public static final QOM.AlterType AlterType(Name type, boolean ifExists, Name renameTo, Schema setSchema, Field<String> addValue, Field<String> renameValue, Field<String> renameValueTo) TheALTER TYPE
statement. -
AlterView
TheALTER VIEW
statement. -
AlterView
public static final QOM.AlterView AlterView(Table<?> view, Collection<? extends Field<?>> fields, boolean materialized, boolean ifExists, Comment comment, Table<?> renameTo, Select<?> as) TheALTER VIEW
statement. -
CommentOn
TheCOMMENT ON TABLE
statement. -
CommentOn
public static final QOM.CommentOn CommentOn(Table<?> table, boolean isView, boolean isMaterializedView, Field<?> field, Comment comment) TheCOMMENT ON TABLE
statement. -
CreateDatabase
TheCREATE DATABASE
statement. -
CreateDatabase
TheCREATE DATABASE
statement. -
CreateDomain
TheCREATE DOMAIN
statement. -
CreateDomain
public static final <T> QOM.CreateDomain<T> CreateDomain(Domain<?> domain, boolean ifNotExists, DataType<T> dataType, Field<T> default_, Collection<? extends Constraint> constraints) TheCREATE DOMAIN
statement. -
CreateFunction
TheCREATE FUNCTION
statement. -
CreateFunction
@Pro public static final QOM.CreateFunction CreateFunction(Name function, boolean orReplace, Collection<? extends Parameter<?>> parameters, DataType<?> returns, Collection<? extends Field<?>> returnsTable, QOM.SQLDataAccess sqlDataAccess, QOM.NullCallClause returnsNullOnNullInput, QOM.Deterministic deterministic, Statement body) TheCREATE FUNCTION
statement. -
CreateIndex
TheCREATE INDEX
statement. -
CreateIndex
public static final QOM.CreateIndex CreateIndex(boolean unique, Index index, boolean ifNotExists, Table<?> table, Collection<? extends OrderField<?>> on, Collection<? extends Field<?>> include, Condition where, boolean excludeNullKeys) TheCREATE INDEX
statement. -
CreateProcedure
TheCREATE PROCEDURE
statement. -
CreateProcedure
@Pro public static final QOM.CreateProcedure CreateProcedure(Name procedure, boolean orReplace, Collection<? extends Parameter<?>> parameters, QOM.SQLDataAccess sqlDataAccess, Statement body) TheCREATE PROCEDURE
statement. -
CreateTable
TheCREATE TABLE
statement. -
CreateTable
public static final QOM.CreateTable CreateTable(Table<?> table, boolean temporary, boolean ifNotExists, Collection<? extends TableElement> tableElements, Select<?> select, QOM.WithOrWithoutData withData, QOM.TableCommitAction onCommit, Comment comment, SQL storage) TheCREATE TABLE
statement. -
CreateView
TheCREATE VIEW
statement. -
CreateView
public static final <R extends Record> QOM.CreateView<R> CreateView(Table<?> view, Collection<? extends Field<?>> fields, boolean orReplace, boolean materialized, boolean ifNotExists, ResultQuery<? extends R> query) TheCREATE VIEW
statement. -
CreateTrigger
TheCREATE TRIGGER
statement. -
CreateTrigger
@Pro public static final QOM.CreateTrigger CreateTrigger(Trigger trigger, boolean orReplace, boolean before, boolean after, boolean insteadOf, boolean insert, boolean update, boolean delete, Collection<? extends Field<?>> of, Table<?> on, Name referencingOldAs, Name referencingNewAs, boolean forEachRow, boolean forEachStatement, Condition when, Statement body) TheCREATE TRIGGER
statement. -
CreateType
TheCREATE TYPE
statement. -
CreateType
public static final QOM.CreateType CreateType(Type<?> type, boolean ifNotExists, Collection<? extends Field<String>> values, Collection<? extends Field<?>> attributes) TheCREATE TYPE
statement. -
CreateSchema
TheCREATE SCHEMA
statement. -
CreateSchema
TheCREATE SCHEMA
statement. -
CreateSequence
TheCREATE SEQUENCE
statement. -
CreateSequence
public static final <T extends Number> QOM.CreateSequence<T> CreateSequence(Sequence<?> sequence, boolean ifNotExists, DataType<T> dataType, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache) TheCREATE SEQUENCE
statement. -
DropDatabase
TheDROP DATABASE
statement. -
DropDatabase
TheDROP DATABASE
statement. -
DropDomain
TheDROP DOMAIN
statement. -
DropDomain
public static final QOM.DropDomain DropDomain(Domain<?> domain, boolean ifExists, QOM.Cascade cascade) TheDROP DOMAIN
statement. -
DropFunction
TheDROP FUNCTION
statement. -
DropFunction
TheDROP FUNCTION
statement. -
DropIndex
TheDROP INDEX
statement. -
DropIndex
public static final QOM.DropIndex DropIndex(Index index, boolean ifExists, Table<?> on, QOM.Cascade cascade) TheDROP INDEX
statement. -
DropProcedure
TheDROP PROCEDURE
statement. -
DropProcedure
TheDROP PROCEDURE
statement. -
DropSchema
TheDROP SCHEMA
statement. -
DropSchema
TheDROP SCHEMA
statement. -
DropSequence
TheDROP SEQUENCE
statement. -
DropSequence
TheDROP SEQUENCE
statement. -
DropTable
TheDROP TABLE
statement. -
DropTable
public static final QOM.DropTable DropTable(boolean temporary, Table<?> table, boolean ifExists, QOM.Cascade cascade) TheDROP TABLE
statement. -
DropTrigger
TheDROP TRIGGER
statement. -
DropTrigger
@Pro public static final QOM.DropTrigger DropTrigger(Trigger trigger, boolean ifExists, Table<?> on) TheDROP TRIGGER
statement. -
DropType
TheDROP TYPE
statement. -
DropType
public static final QOM.DropType DropType(Collection<? extends Type<?>> types, boolean ifExists, QOM.Cascade cascade) TheDROP TYPE
statement. -
DropView
TheDROP VIEW
statement. -
DropView
TheDROP VIEW
statement. -
Grant
TheGRANT
statement. -
Grant
public static final QOM.Grant Grant(Collection<? extends Privilege> privileges, Table<?> on, Role to, boolean toPublic, boolean withGrantOption) TheGRANT
statement. -
Revoke
TheREVOKE
statement. -
Revoke
public static final QOM.Revoke Revoke(Collection<? extends Privilege> privileges, boolean grantOptionFor, Table<?> on, Role from, boolean fromPublic) TheREVOKE
statement. -
SetCommand
TheSET
statement.Set a vendor specific session configuration to a new value.
-
SetCommand
TheSET
statement.Set a vendor specific session configuration to a new value.
-
SetCatalog
TheSET CATALOG
statement.Set the current catalog to a new value.
-
SetCatalog
TheSET CATALOG
statement.Set the current catalog to a new value.
-
SetSchema
TheSET SCHEMA
statement.Set the current schema to a new value.
-
SetSchema
TheSET SCHEMA
statement.Set the current schema to a new value.
-
Truncate
TheTRUNCATE
statement. -
Truncate
public static final <R extends Record> QOM.Truncate<R> Truncate(Collection<? extends Table<?>> table, QOM.IdentityRestartOption restartIdentity, QOM.Cascade cascade) TheTRUNCATE
statement. -
Call
TheCALL
statement.Call a stored procedure.
-
Call
TheCALL
statement.Call a stored procedure.
-
StartTransaction
TheSTART TRANSACTION
statement.Start a transaction
-
Savepoint
TheSAVEPOINT
statement.Specify a savepoint
-
Savepoint
TheSAVEPOINT
statement.Specify a savepoint
-
ReleaseSavepoint
TheRELEASE SAVEPOINT
statement.Release a savepoint
-
ReleaseSavepoint
TheRELEASE SAVEPOINT
statement.Release a savepoint
-
Commit
TheCOMMIT
statement.Commit a transaction
-
Rollback
TheROLLBACK
statement.Rollback a transaction
-
Rollback
TheROLLBACK
statement.Rollback a transaction
-
And
TheAND
operator. -
And
TheAND
operator. -
TableEq
TheEQ
operator. -
TableEq
TheEQ
operator. -
Eq
TheEQ
operator. -
Eq
TheEQ
operator. -
EqQuantified
TheEQ
operator. -
EqQuantified
public static final <T> QOM.EqQuantified<T> EqQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheEQ
operator. -
Exists
TheEXISTS
function. -
Exists
TheEXISTS
function. -
Ge
TheGE
operator. -
Ge
TheGE
operator. -
GeQuantified
TheGE
operator. -
GeQuantified
public static final <T> QOM.GeQuantified<T> GeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheGE
operator. -
Gt
TheGT
operator. -
Gt
TheGT
operator. -
GtQuantified
TheGT
operator. -
GtQuantified
public static final <T> QOM.GtQuantified<T> GtQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheGT
operator. -
In
TheIN
operator.The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
-
In
TheIN
operator.The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
-
IsDistinctFrom
TheIS DISTINCT FROM
operator.The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality
-
IsDistinctFrom
TheIS DISTINCT FROM
operator.The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality
-
IsNull
TheIS NULL
operator. -
IsNull
TheIS NULL
operator. -
IsNotDistinctFrom
TheIS NOT DISTINCT FROM
operator.The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality
-
IsNotDistinctFrom
TheIS NOT DISTINCT FROM
operator.The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality
-
IsNotNull
TheIS NOT NULL
operator. -
IsNotNull
TheIS NOT NULL
operator. -
Le
TheLE
operator. -
Le
TheLE
operator. -
LeQuantified
TheLE
operator. -
LeQuantified
public static final <T> QOM.LeQuantified<T> LeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheLE
operator. -
Like
TheLIKE
operator. -
Like
TheLIKE
operator. -
LikeQuantified
TheLIKE
operator. -
LikeQuantified
public static final QOM.LikeQuantified LikeQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheLIKE
operator. -
LikeIgnoreCase
TheLIKE IGNORE CASE
operator.Create a condition to case-insensitively pattern-check this field against a value.
This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects. -
LikeIgnoreCase
public static final QOM.LikeIgnoreCase LikeIgnoreCase(Field<?> value, Field<String> pattern, Character escape) TheLIKE IGNORE CASE
operator.Create a condition to case-insensitively pattern-check this field against a value.
This translates to
this ilike value
inSQLDialect.POSTGRES
, or tolower(this) like lower(value)
in all other dialects. -
Lt
TheLT
operator. -
Lt
TheLT
operator. -
LtQuantified
TheLT
operator. -
LtQuantified
public static final <T> QOM.LtQuantified<T> LtQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheLT
operator. -
TableNe
TheNE
operator. -
TableNe
TheNE
operator. -
Ne
TheNE
operator. -
Ne
TheNE
operator. -
NeQuantified
TheNE
operator. -
NeQuantified
public static final <T> QOM.NeQuantified<T> NeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2) TheNE
operator. -
Not
TheNOT
operator. -
Not
TheNOT
operator. -
NotField
TheNOT
operator. -
NotField
TheNOT
operator. -
NotIn
TheNOT IN
operator.The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
If any of the passed values is
NULL
, then the condition will beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour. -
NotIn
TheNOT IN
operator.The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.
If any of the passed values is
NULL
, then the condition will beNULL
(orfalse
, depending on the dialect) as well. This is standard SQL behaviour. -
NotLike
TheNOT LIKE
operator. -
NotLike
TheNOT LIKE
operator. -
NotLikeQuantified
TheNOT LIKE
operator. -
NotLikeQuantified
public static final QOM.NotLikeQuantified NotLikeQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheNOT LIKE
operator. -
NotLikeIgnoreCase
TheNOT LIKE IGNORE CASE
operator.Create a condition to case-insensitively pattern-check this field against a value.
This translates to
this not ilike value
inSQLDialect.POSTGRES
, or tolower(this) not like lower(value)
in all other dialects. -
NotLikeIgnoreCase
public static final QOM.NotLikeIgnoreCase NotLikeIgnoreCase(Field<?> value, Field<String> pattern, Character escape) TheNOT LIKE IGNORE CASE
operator.Create a condition to case-insensitively pattern-check this field against a value.
This translates to
this not ilike value
inSQLDialect.POSTGRES
, or tolower(this) not like lower(value)
in all other dialects. -
NotSimilarTo
TheNOT SIMILAR TO
operator. -
NotSimilarTo
public static final QOM.NotSimilarTo NotSimilarTo(Field<?> value, Field<String> pattern, Character escape) TheNOT SIMILAR TO
operator. -
NotSimilarToQuantified
TheNOT SIMILAR TO
operator. -
NotSimilarToQuantified
public static final QOM.NotSimilarToQuantified NotSimilarToQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheNOT SIMILAR TO
operator. -
Or
TheOR
operator. -
Or
TheOR
operator. -
SimilarTo
TheSIMILAR TO
operator. -
SimilarTo
public static final QOM.SimilarTo SimilarTo(Field<?> value, Field<String> pattern, Character escape) TheSIMILAR TO
operator. -
SimilarToQuantified
TheSIMILAR TO
operator. -
SimilarToQuantified
public static final QOM.SimilarToQuantified SimilarToQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape) TheSIMILAR TO
operator. -
Unique
TheUNIQUE
function. -
Unique
TheUNIQUE
function. -
Xor
TheXOR
operator. -
Xor
TheXOR
operator. -
RowEq
TheROW EQ
operator. -
RowEq
TheROW EQ
operator. -
RowNe
TheROW NE
operator. -
RowNe
TheROW NE
operator. -
RowGt
TheROW GT
operator. -
RowGt
TheROW GT
operator. -
RowGe
TheROW GE
operator. -
RowGe
TheROW GE
operator. -
RowLt
TheROW LT
operator. -
RowLt
TheROW LT
operator. -
RowLe
TheROW LE
operator. -
RowLe
TheROW LE
operator. -
IsDocument
TheIS DOCUMENT
operator.Create a condition to check if this field contains XML data.
-
IsDocument
TheIS DOCUMENT
operator.Create a condition to check if this field contains XML data.
-
IsNotDocument
TheIS NOT DOCUMENT
operator.Create a condition to check if this field does not contain XML data.
-
IsNotDocument
TheIS NOT DOCUMENT
operator.Create a condition to check if this field does not contain XML data.
-
IsJson
TheIS JSON
operator.Create a condition to check if this field contains JSON data.
-
IsJson
TheIS JSON
operator.Create a condition to check if this field contains JSON data.
-
IsNotJson
TheIS NOT JSON
operator.Create a condition to check if this field does not contain JSON data.
-
IsNotJson
TheIS NOT JSON
operator.Create a condition to check if this field does not contain JSON data.
-
Excluded
TheEXCLUDED
function.Provide "EXCLUDED" qualification for a column for use in ON CONFLICT or ON DUPLICATE KEY UPDATE.
-
Excluded
TheEXCLUDED
function.Provide "EXCLUDED" qualification for a column for use in ON CONFLICT or ON DUPLICATE KEY UPDATE.
-
QualifiedRowid
TheROWID
operator.Get a
table.rowid
reference from this table.A rowid value describes the physical location of a row on the disk, which can be used as a replacement for a primary key in some situations - especially within a query, e.g. to self-join a table:
-- Emulating this MySQL statement... DELETE FROM x ORDER BY x.y LIMIT 1 -- ... in other databases DELETE FROM x WHERE x.rowid IN ( SELECT x.rowid FROM x ORDER BY x.a LIMIT 1 )
It is not recommended to use
rowid
values in client applications as actual row identifiers as the database system may move a row to a different physical location at any time, thus changing the rowid value. In general, use primary keys, instead. -
QualifiedRowid
TheROWID
operator.Get a
table.rowid
reference from this table.A rowid value describes the physical location of a row on the disk, which can be used as a replacement for a primary key in some situations - especially within a query, e.g. to self-join a table:
-- Emulating this MySQL statement... DELETE FROM x ORDER BY x.y LIMIT 1 -- ... in other databases DELETE FROM x WHERE x.rowid IN ( SELECT x.rowid FROM x ORDER BY x.a LIMIT 1 )
It is not recommended to use
rowid
values in client applications as actual row identifiers as the database system may move a row to a different physical location at any time, thus changing the rowid value. In general, use primary keys, instead. -
Abs
TheABS
function. -
Abs
TheABS
function. -
Acos
TheACOS
function. -
Acos
TheACOS
function. -
Acosh
TheACOSH
function. -
Acosh
TheACOSH
function. -
Acoth
TheACOTH
function. -
Acoth
TheACOTH
function. -
Add
TheADD
operator. -
Add
TheADD
operator. -
Asin
TheASIN
function. -
Asin
TheASIN
function. -
Asinh
TheASINH
function. -
Asinh
TheASINH
function. -
Atan
TheATAN
function. -
Atan
TheATAN
function. -
Atan2
TheATAN2
function. -
Atan2
TheATAN2
function. -
Atanh
TheATANH
function. -
Atanh
TheATANH
function. -
BitAnd
TheBIT AND
operator. -
BitAnd
TheBIT AND
operator. -
BitCount
TheBIT COUNT
function.Count the number of bits set in a number
-
BitCount
TheBIT COUNT
function.Count the number of bits set in a number
-
BitGet
TheBIT GET
function. -
BitGet
public static final <T extends Number> QOM.BitGet<T> BitGet(Field<T> value, Field<? extends Number> bit) TheBIT GET
function. -
BitNand
TheBIT NAND
operator. -
BitNand
TheBIT NAND
operator. -
BitNor
TheBIT NOR
operator. -
BitNor
TheBIT NOR
operator. -
BitNot
TheBIT NOT
operator. -
BitNot
TheBIT NOT
operator. -
BitOr
TheBIT OR
operator. -
BitOr
TheBIT OR
operator. -
BitSet
TheBIT SET
function. -
BitSet
public static final <T extends Number> QOM.BitSet<T> BitSet(Field<T> value, Field<? extends Number> bit, Field<T> newValue) TheBIT SET
function. -
BitXNor
TheBIT X NOR
operator. -
BitXNor
TheBIT X NOR
operator. -
BitXor
TheBIT XOR
operator. -
BitXor
TheBIT XOR
operator. -
Cbrt
TheCBRT
function. -
Cbrt
TheCBRT
function. -
Ceil
TheCEIL
function.Get the smallest integer value equal or greater to a value.
-
Ceil
TheCEIL
function.Get the smallest integer value equal or greater to a value.
-
Cos
TheCOS
function. -
Cos
TheCOS
function. -
Cosh
TheCOSH
function. -
Cosh
TheCOSH
function. -
Cot
TheCOT
function. -
Cot
TheCOT
function. -
Coth
TheCOTH
function. -
Coth
TheCOTH
function. -
Degrees
TheDEGREES
function.Turn a value in radians to degrees.
-
Degrees
TheDEGREES
function.Turn a value in radians to degrees.
-
Div
TheDIV
operator. -
Div
TheDIV
operator. -
Euler
TheE
function.The E literal (Euler number).
-
Exp
TheEXP
function. -
Exp
TheEXP
function. -
Floor
TheFLOOR
function.Get the biggest integer value equal or less than a value.
-
Floor
TheFLOOR
function.Get the biggest integer value equal or less than a value.
-
Ln
TheLN
function.Get the natural logarithm of a value.
-
Ln
TheLN
function.Get the natural logarithm of a value.
-
Log
TheLOG
function.Get the logarithm of a value for a base.
-
Log
TheLOG
function.Get the logarithm of a value for a base.
-
Log10
TheLOG10
function.Get the logarithm of a value for base 10.
-
Log10
TheLOG10
function.Get the logarithm of a value for base 10.
-
Mod
TheMOD
operator. -
Mod
public static final <T extends Number> QOM.Mod<T> Mod(Field<T> dividend, Field<? extends Number> divisor) TheMOD
operator. -
Mul
TheMUL
operator. -
Mul
TheMUL
operator. -
Pi
ThePI
function.The π literal.
-
Power
ThePOWER
operator. -
Power
ThePOWER
operator. -
Radians
TheRADIANS
function.Turn a value in degrees to radians.
-
Radians
TheRADIANS
function.Turn a value in degrees to radians.
-
Rand
TheRAND
function.Get a random numeric value.
-
Root
TheROOT
function. -
Root
TheROOT
function. -
Round
TheROUND
function.Round a numeric value to the nearest decimal precision.
-
Round
TheROUND
function.Round a numeric value to the nearest decimal precision.
-
Shl
TheSHL
operator.Left shift all bits in a number
-
Shl
public static final <T extends Number> QOM.Shl<T> Shl(Field<T> value, Field<? extends Number> count) TheSHL
operator.Left shift all bits in a number
-
Shr
TheSHR
operator.Right shift all bits in a number
-
Shr
public static final <T extends Number> QOM.Shr<T> Shr(Field<T> value, Field<? extends Number> count) TheSHR
operator.Right shift all bits in a number
-
Sign
TheSIGN
function.Get the sign of a number and return it as any of +1, 0, -1.
-
Sign
TheSIGN
function.Get the sign of a number and return it as any of +1, 0, -1.
-
Sin
TheSIN
function. -
Sin
TheSIN
function. -
Sinh
TheSINH
function. -
Sinh
TheSINH
function. -
Sqrt
TheSQRT
function. -
Sqrt
TheSQRT
function. -
Square
TheSQUARE
function. -
Square
TheSQUARE
function. -
Sub
TheSUB
operator. -
Sub
TheSUB
operator. -
Tan
TheTAN
function. -
Tan
TheTAN
function. -
Tanh
TheTANH
function. -
Tanh
TheTANH
function. -
Tau
TheTAU
function.The τ literal, or π, in a better world.
-
Trunc
TheTRUNC
function.Truncate a number to a given number of decimals.
-
Trunc
TheTRUNC
function.Truncate a number to a given number of decimals.
-
WidthBucket
TheWIDTH BUCKET
function.Divide a range into buckets of equal size.
-
WidthBucket
public static final <T extends Number> QOM.WidthBucket<T> WidthBucket(Field<T> field, Field<T> low, Field<T> high, Field<Integer> buckets) TheWIDTH BUCKET
function.Divide a range into buckets of equal size.
-
Ascii
TheASCII
function.The ASCII value of a character.
-
Ascii
TheASCII
function.The ASCII value of a character.
-
BitLength
TheBIT LENGTH
function.The length of a string in bits.
-
BitLength
TheBIT LENGTH
function.The length of a string in bits.
-
CharLength
TheCHAR LENGTH
function.The length of a string in characters.
-
CharLength
TheCHAR LENGTH
function.The length of a string in characters.
-
Chr
TheCHR
function. -
Chr
TheCHR
function. -
Contains
TheCONTAINS
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).contains(13)
If you're using
SQLDialect.POSTGRES
, then you can use this method also to express the "ARRAY contains" operator. For example:// Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2]
Note, this does not correspond to the Oracle Text
CONTAINS()
function. Refer toOracleDSL.contains(Field, String)
instead. -
Contains
TheCONTAINS
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).contains(13)
If you're using
SQLDialect.POSTGRES
, then you can use this method also to express the "ARRAY contains" operator. For example:// Use this expression val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 }) // ... to render this SQL ARRAY[1, 2, 3] @> ARRAY[1, 2]
Note, this does not correspond to the Oracle Text
CONTAINS()
function. Refer toOracleDSL.contains(Field, String)
instead. -
ContainsIgnoreCase
TheCONTAINS IGNORE CASE
operator.Convenience method for
Field.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'
inSQLDialect.POSTGRES
, or tolower(this) like lower(('%' || escape(value, '\') || '%') escape '\')
in all other dialects. -
ContainsIgnoreCase
public static final <T> QOM.ContainsIgnoreCase<T> ContainsIgnoreCase(Field<T> value, Field<T> content) TheCONTAINS IGNORE CASE
operator.Convenience method for
Field.likeIgnoreCase(String, char)
including proper adding of wildcards and escaping.This translates to
this ilike ('%' || escape(value, '\') || '%') escape '\'
inSQLDialect.POSTGRES
, or tolower(this) like lower(('%' || escape(value, '\') || '%') escape '\')
in all other dialects. -
Digits
TheDIGITS
function. -
Digits
TheDIGITS
function. -
EndsWith
TheENDS WITH
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWith(33)
-
EndsWith
TheENDS WITH
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like ('%' || escape(value, '\')) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWith(33)
-
EndsWithIgnoreCase
TheENDS WITH IGNORE CASE
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like ('%' || lower(escape(value, '\'))) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)
-
EndsWithIgnoreCase
public static final <T> QOM.EndsWithIgnoreCase<T> EndsWithIgnoreCase(Field<T> string, Field<T> suffix) TheENDS WITH IGNORE CASE
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like ('%' || lower(escape(value, '\'))) escape '\'
Note: This also works with numbers, for instance
val(1133).endsWithIgnoreCase(33)
-
Left
TheLEFT
function.Get the left outermost characters from a string.
-
Left
TheLEFT
function.Get the left outermost characters from a string.
-
Lower
TheLOWER
function.Turn a string into lower case.
-
Lower
TheLOWER
function.Turn a string into lower case.
-
Lpad
TheLPAD
function.Left-pad a string with a character (whitespace as default) for a number of times.
-
Lpad
public static final QOM.Lpad Lpad(Field<String> string, Field<? extends Number> length, Field<String> character) TheLPAD
function.Left-pad a string with a character (whitespace as default) for a number of times.
-
Ltrim
TheLTRIM
function.Trim characters (whitespace as default) from the left side of a string.
-
Ltrim
TheLTRIM
function.Trim characters (whitespace as default) from the left side of a string.
-
Md5
TheMD5
function.Calculate an MD5 hash from a string.
-
Md5
TheMD5
function.Calculate an MD5 hash from a string.
-
OctetLength
TheOCTET LENGTH
function.The length of a string in octets.
-
OctetLength
TheOCTET LENGTH
function.The length of a string in octets.
-
Overlay
TheOVERLAY
function.Place a string on top of another string, replacing the original contents.
-
Overlay
public static final QOM.Overlay Overlay(Field<String> in, Field<String> placing, Field<? extends Number> startIndex, Field<? extends Number> length) TheOVERLAY
function.Place a string on top of another string, replacing the original contents.
-
Position
ThePOSITION
function.Search the position (1-based) of a substring in another string.
-
Position
public static final QOM.Position Position(Field<String> in, Field<String> search, Field<? extends Number> startIndex) ThePOSITION
function.Search the position (1-based) of a substring in another string.
-
Repeat
TheREPEAT
function.Repeat a string a number of times.
-
Repeat
TheREPEAT
function.Repeat a string a number of times.
-
Replace
TheREPLACE
function.Replace all occurrences of a substring in another string.
-
Replace
public static final QOM.Replace Replace(Field<String> string, Field<String> search, Field<String> replace) TheREPLACE
function.Replace all occurrences of a substring in another string.
-
Reverse
TheREVERSE
function.Reverse a string.
-
Reverse
TheREVERSE
function.Reverse a string.
-
Right
TheRIGHT
function.Get the right outermost characters from a string.
-
Right
TheRIGHT
function.Get the right outermost characters from a string.
-
Rpad
TheRPAD
function.Right-pad a string with a character (whitespace as default) for a number of times.
-
Rpad
public static final QOM.Rpad Rpad(Field<String> string, Field<? extends Number> length, Field<String> character) TheRPAD
function.Right-pad a string with a character (whitespace as default) for a number of times.
-
Rtrim
TheRTRIM
function.Trim characters (whitespace as default) from the right side of a string.
-
Rtrim
TheRTRIM
function.Trim characters (whitespace as default) from the right side of a string.
-
Space
TheSPACE
function.Get a string of spaces of a given length.
-
Space
TheSPACE
function.Get a string of spaces of a given length.
-
SplitPart
TheSPLIT PART
function.Split a string into tokens, and retrieve the nth token.
-
SplitPart
public static final QOM.SplitPart SplitPart(Field<String> string, Field<String> delimiter, Field<? extends Number> n) TheSPLIT PART
function.Split a string into tokens, and retrieve the nth token.
-
StartsWith
TheSTARTS WITH
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWith(11)
-
StartsWith
TheSTARTS WITH
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
this like (escape(value, '\') || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWith(11)
-
StartsWithIgnoreCase
TheSTARTS WITH IGNORE CASE
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)
-
StartsWithIgnoreCase
public static final <T> QOM.StartsWithIgnoreCase<T> StartsWithIgnoreCase(Field<T> string, Field<T> prefix) TheSTARTS WITH IGNORE CASE
operator.Convenience method for
Field.like(String, char)
including proper adding of wildcards and escaping.SQL:
lower(this) like (lower(escape(value, '\')) || '%') escape '\'
Note: This also works with numbers, for instance
val(1133).startsWithIgnoreCase(11)
-
Substring
TheSUBSTRING
function.Get a substring of a string, from a given position.
-
Substring
public static final QOM.Substring Substring(Field<String> string, Field<? extends Number> startingPosition, Field<? extends Number> length) TheSUBSTRING
function.Get a substring of a string, from a given position.
-
SubstringIndex
TheSUBSTRING INDEX
function.Get a substring of a string, from the beginning until the nth occurrence of a substring.
-
SubstringIndex
public static final QOM.SubstringIndex SubstringIndex(Field<String> string, Field<String> delimiter, Field<? extends Number> n) TheSUBSTRING INDEX
function.Get a substring of a string, from the beginning until the nth occurrence of a substring.
-
ToChar
TheTO CHAR
function.Format an arbitrary value as a string.
-
ToChar
TheTO CHAR
function.Format an arbitrary value as a string.
-
ToDate
TheTO DATE
function.Parse a string-formatted date value to a date.
-
ToDate
TheTO DATE
function.Parse a string-formatted date value to a date.
-
ToHex
TheTO HEX
function.Format a number to its hex value.
-
ToHex
TheTO HEX
function.Format a number to its hex value.
-
ToTimestamp
TheTO TIMESTAMP
function.Parse a string-formatted timestamp value to a timestamp.
-
ToTimestamp
TheTO TIMESTAMP
function.Parse a string-formatted timestamp value to a timestamp.
-
Translate
TheTRANSLATE
function.Translate a set of characters to another set of characters in a string.
-
Translate
public static final QOM.Translate Translate(Field<String> string, Field<String> from, Field<String> to) TheTRANSLATE
function.Translate a set of characters to another set of characters in a string.
-
Trim
TheTRIM
function.Trim characters (whitespace as default) from both sides of a string.
-
Trim
TheTRIM
function.Trim characters (whitespace as default) from both sides of a string.
-
Upper
TheUPPER
function.Turn a string into upper case.
-
Upper
TheUPPER
function.Turn a string into upper case.
-
Uuid
TheUUID
function.Generate a random UUID.
-
BinaryBitLength
TheBINARY BIT LENGTH
function.The length of a binary string in bits.
-
BinaryBitLength
TheBINARY BIT LENGTH
function.The length of a binary string in bits.
-
BinaryConcat
TheBINARY CONCAT
function.The concatenation of binary strings.
-
BinaryConcat
TheBINARY CONCAT
function.The concatenation of binary strings.
-
BinaryLength
TheBINARY LENGTH
function.The length of a binary string in bytes.
-
BinaryLength
TheBINARY LENGTH
function.The length of a binary string in bytes.
-
BinaryLtrim
TheBINARY LTRIM
function.Trim bytes from the left side of a binary string.
-
BinaryLtrim
TheBINARY LTRIM
function.Trim bytes from the left side of a binary string.
-
BinaryMd5
TheBINARY MD5
function.Calculate an MD5 hash from a binary string.
-
BinaryMd5
TheBINARY MD5
function.Calculate an MD5 hash from a binary string.
-
BinaryOctetLength
TheBINARY OCTET LENGTH
function.The length of a binary string in octets.
-
BinaryOctetLength
TheBINARY OCTET LENGTH
function.The length of a binary string in octets.
-
BinaryOverlay
TheBINARY OVERLAY
function.Place a binary string on top of another binary string, replacing the original contents.
-
BinaryOverlay
public static final QOM.BinaryOverlay BinaryOverlay(Field<byte[]> in, Field<byte[]> placing, Field<? extends Number> startIndex, Field<? extends Number> length) TheBINARY OVERLAY
function.Place a binary string on top of another binary string, replacing the original contents.
-
BinaryPosition
TheBINARY POSITION
function.Search the position (1-based) of a substring in another string.
-
BinaryPosition
public static final QOM.BinaryPosition BinaryPosition(Field<byte[]> in, Field<byte[]> search, Field<? extends Number> startIndex) TheBINARY POSITION
function.Search the position (1-based) of a substring in another string.
-
BinaryRtrim
TheBINARY RTRIM
function.Trim bytes from the right side of a binary string.
-
BinaryRtrim
TheBINARY RTRIM
function.Trim bytes from the right side of a binary string.
-
BinarySubstring
TheBINARY SUBSTRING
function.Get a substring of a binary string, from a given position.
-
BinarySubstring
public static final QOM.BinarySubstring BinarySubstring(Field<byte[]> string, Field<? extends Number> startingPosition, Field<? extends Number> length) TheBINARY SUBSTRING
function.Get a substring of a binary string, from a given position.
-
BinaryTrim
TheBINARY TRIM
function.Trim characters from both sides of a string.
-
BinaryTrim
TheBINARY TRIM
function.Trim characters from both sides of a string.
-
DateAdd
TheDATE ADD
function.Add an interval to a date.
-
DateAdd
public static final <T> QOM.DateAdd<T> DateAdd(Field<T> date, Field<? extends Number> interval, DatePart datePart) TheDATE ADD
function.Add an interval to a date.
-
Cardinality
TheCARDINALITY
function.Calculate the cardinality of an array field.
-
Cardinality
TheCARDINALITY
function.Calculate the cardinality of an array field.
-
ArrayGet
TheARRAY GET
function.Get an array element at a given index (1 based).
-
ArrayGet
TheARRAY GET
function.Get an array element at a given index (1 based).
-
ArrayConcat
TheARRAY CONCAT
function.Concatenate two arrays.
-
ArrayConcat
TheARRAY CONCAT
function.Concatenate two arrays.
-
ArrayAppend
TheARRAY APPEND
function.Append an element to an array.
-
ArrayAppend
TheARRAY APPEND
function.Append an element to an array.
-
ArrayPrepend
TheARRAY PREPEND
function.Prepend an element to an array.
-
ArrayPrepend
TheARRAY PREPEND
function.Prepend an element to an array.
-
ArrayOverlap
TheARRAY OVERLAP
function.Check if 2 arrays overlap.
-
ArrayOverlap
TheARRAY OVERLAP
function.Check if 2 arrays overlap.
-
ArrayRemove
TheARRAY REMOVE
function.Remove an element from an array.
-
ArrayRemove
TheARRAY REMOVE
function.Remove an element from an array.
-
ArrayReplace
TheARRAY REPLACE
function.Replace an element in an array.
-
ArrayReplace
public static final <T> QOM.ArrayReplace<T> ArrayReplace(Field<T[]> arg1, Field<T> arg2, Field<T> arg3) TheARRAY REPLACE
function.Replace an element in an array.
-
Nvl
TheNVL
function.Return the first non-null argument.
-
Nvl
TheNVL
function.Return the first non-null argument.
-
Nullif
TheNULLIF
function. -
Nullif
TheNULLIF
function. -
TryCast
TheTRY CAST
function. -
TryCast
TheTRY CAST
function. -
CurrentCatalog
TheCURRENT CATALOG
function.The CURRENT_CATALOG of the current session
-
CurrentSchema
TheCURRENT SCHEMA
function.The CURRENT_SCHEMA of the current session
-
CurrentUser
TheCURRENT USER
function.The CURRENT_USER of the current session with the database
-
ConnectByIsCycle
TheCONNECT BY ISCYCLE
function.The CONNECT_BY_ISCYCLE pseudo column is used with the Oracle style CONNECT BY clause.
-
ConnectByIsLeaf
TheCONNECT BY ISLEAF
function.The CONNECT_BY_ISLEAF pseudo column is used with the Oracle style CONNECT BY clause.
-
ConnectByRoot
TheCONNECT BY ROOT
function.The CONNECT_BY_ROOT operator is used with the Oracle style CONNECT BY clause.
-
ConnectByRoot
TheCONNECT BY ROOT
function.The CONNECT_BY_ROOT operator is used with the Oracle style CONNECT BY clause.
-
Level
TheLEVEL
function.The LEVEL pseudo column is used with the Oracle style CONNECT BY clause.
-
Prior
ThePRIOR
function.The PRIOR operator is used with the Oracle style CONNECT BY clause.
-
Prior
ThePRIOR
function.The PRIOR operator is used with the Oracle style CONNECT BY clause.
-
SysConnectByPath
TheSYS CONNECT BY PATH
function.The SYS_CONNECT_BY_PATH function is used with the Oracle style CONNECT BY clause.
-
SysConnectByPath
TheSYS CONNECT BY PATH
function.The SYS_CONNECT_BY_PATH function is used with the Oracle style CONNECT BY clause.
-
Rownum
TheROWNUM
function.Depending on its usage, the Oracle-specific
ROWNUM
pseudo-field can be emulated usingLIMIT
orROW_NUMBER()
. -
PlusJoin
ThePLUS
operator.Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using
Settings.isTransformTableListsToAnsiJoin()
.Example:
TABLE1.COL.plus().eq(TABLE2.COL); TABLE1.COL.eq(TABLE2.COL.plus());
The above will generate
TABLE1.COL(+) = TABLE2.COL TABLE1.COL = TABLE2.COL(+)
-
PlusJoin
ThePLUS
operator.Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using
Settings.isTransformTableListsToAnsiJoin()
.Example:
TABLE1.COL.plus().eq(TABLE2.COL); TABLE1.COL.eq(TABLE2.COL.plus());
The above will generate
TABLE1.COL(+) = TABLE2.COL TABLE1.COL = TABLE2.COL(+)
-
XMLComment
TheXMLCOMMENT
function. -
XMLComment
TheXMLCOMMENT
function. -
XMLConcat
TheXMLCONCAT
function. -
XMLConcat
TheXMLCONCAT
function. -
XMLDocument
TheXMLDOCUMENT
function. -
XMLDocument
TheXMLDOCUMENT
function. -
XMLForest
TheXMLFOREST
function. -
XMLForest
TheXMLFOREST
function. -
XMLPi
TheXMLPI
function. -
XMLPi
TheXMLPI
function. -
XMLSerialize
TheXMLSERIALIZE
function. -
XMLSerialize
public static final <T> QOM.XMLSerialize<T> XMLSerialize(boolean content, Field<XML> value, DataType<T> type) TheXMLSERIALIZE
function. -
JSONArray
TheJSON ARRAY
function. -
JSONArray
public static final <T> QOM.JSONArray<T> JSONArray(DataType<T> type, Collection<? extends Field<?>> fields, QOM.JSONOnNull onNull, DataType<?> returning) TheJSON ARRAY
function. -
JSONObject
TheJSON OBJECT
function. -
JSONObject
public static final <T> QOM.JSONObject<T> JSONObject(DataType<T> type, Collection<? extends JSONEntry<?>> entries, QOM.JSONOnNull onNull, DataType<?> returning) TheJSON OBJECT
function. -
JSONGetElement
TheJSON GET ELEMENT
function.Access an array element from a JSON array expression.
-
JSONGetElement
TheJSON GET ELEMENT
function.Access an array element from a JSON array expression.
-
JSONBGetElement
TheJSONB GET ELEMENT
function.Access an array element from a JSONB array expression.
-
JSONBGetElement
TheJSONB GET ELEMENT
function.Access an array element from a JSONB array expression.
-
JSONGetElementAsText
TheJSON GET ELEMENT AS TEXT
function.Access an array element from a JSON array expression and return it as a string.
-
JSONGetElementAsText
public static final QOM.JSONGetElementAsText JSONGetElementAsText(Field<JSON> field, Field<Integer> index) TheJSON GET ELEMENT AS TEXT
function.Access an array element from a JSON array expression and return it as a string.
-
JSONBGetElementAsText
TheJSONB GET ELEMENT AS TEXT
function.Access an array element from a JSONB array expression and return it as a string.
-
JSONBGetElementAsText
public static final QOM.JSONBGetElementAsText JSONBGetElementAsText(Field<JSONB> field, Field<Integer> index) TheJSONB GET ELEMENT AS TEXT
function.Access an array element from a JSONB array expression and return it as a string.
-
JSONGetAttribute
TheJSON GET ATTRIBUTE
function.Access an object attribute value from a JSON object expression.
-
JSONGetAttribute
public static final QOM.JSONGetAttribute JSONGetAttribute(Field<JSON> field, Field<String> attribute) TheJSON GET ATTRIBUTE
function.Access an object attribute value from a JSON object expression.
-
JSONBGetAttribute
TheJSONB GET ATTRIBUTE
function.Access an object attribute value from a JSONB object expression.
-
JSONBGetAttribute
public static final QOM.JSONBGetAttribute JSONBGetAttribute(Field<JSONB> field, Field<String> attribute) TheJSONB GET ATTRIBUTE
function.Access an object attribute value from a JSONB object expression.
-
JSONGetAttributeAsText
TheJSON GET ATTRIBUTE AS TEXT
function.Access an object attribute value from a JSON object expression and return it as string.
-
JSONGetAttributeAsText
public static final QOM.JSONGetAttributeAsText JSONGetAttributeAsText(Field<JSON> field, Field<String> attribute) TheJSON GET ATTRIBUTE AS TEXT
function.Access an object attribute value from a JSON object expression and return it as string.
-
JSONBGetAttributeAsText
TheJSONB GET ATTRIBUTE AS TEXT
function.Access an object attribute value from a JSONB object expression and return it as string.
-
JSONBGetAttributeAsText
public static final QOM.JSONBGetAttributeAsText JSONBGetAttributeAsText(Field<JSONB> field, Field<String> attribute) TheJSONB GET ATTRIBUTE AS TEXT
function.Access an object attribute value from a JSONB object expression and return it as string.
-
JSONArrayLength
TheJSON ARRAY LENGTH
function.Calculate the length of a JSON array.
-
JSONArrayLength
TheJSON ARRAY LENGTH
function.Calculate the length of a JSON array.
-
JSONBArrayLength
TheJSONB ARRAY LENGTH
function.Calculate the length of a JSONB array.
-
JSONBArrayLength
TheJSONB ARRAY LENGTH
function.Calculate the length of a JSONB array.
-
JSONKeys
TheJSON KEYS
function.Retrieve all keys from a JSON object as an array of strings.
-
JSONKeys
TheJSON KEYS
function.Retrieve all keys from a JSON object as an array of strings.
-
JSONBKeys
TheJSONB KEYS
function.Retrieve all keys from a JSONB object as an array of strings.
-
JSONBKeys
TheJSONB KEYS
function.Retrieve all keys from a JSONB object as an array of strings.
-
JSONSet
TheJSON SET
function.Add or replace a JSON value to a JSON field at a given path.
-
JSONSet
TheJSON SET
function.Add or replace a JSON value to a JSON field at a given path.
-
JSONBSet
TheJSONB SET
function.Add or replace a JSONB value to a JSONB field at a given path.
-
JSONBSet
TheJSONB SET
function.Add or replace a JSONB value to a JSONB field at a given path.
-
JSONInsert
TheJSON INSERT
function.Add (but not replace) a JSON value to a JSON field at a given path.
-
JSONInsert
public static final QOM.JSONInsert JSONInsert(Field<JSON> field, Field<String> path, Field<?> value) TheJSON INSERT
function.Add (but not replace) a JSON value to a JSON field at a given path.
-
JSONBInsert
TheJSONB INSERT
function.Add (but not replace) a JSON value to a JSON field at a given path.
-
JSONBInsert
public static final QOM.JSONBInsert JSONBInsert(Field<JSONB> field, Field<String> path, Field<?> value) TheJSONB INSERT
function.Add (but not replace) a JSON value to a JSON field at a given path.
-
JSONReplace
TheJSON REPLACE
function.Replace (but not add) a JSON value to a JSON field at a given path.
-
JSONReplace
public static final QOM.JSONReplace JSONReplace(Field<JSON> field, Field<String> path, Field<?> value) TheJSON REPLACE
function.Replace (but not add) a JSON value to a JSON field at a given path.
-
JSONBReplace
TheJSONB REPLACE
function.Replace (but not add) a JSONB value to a JSONB field at a given path.
-
JSONBReplace
public static final QOM.JSONBReplace JSONBReplace(Field<JSONB> field, Field<String> path, Field<?> value) TheJSONB REPLACE
function.Replace (but not add) a JSONB value to a JSONB field at a given path.
-
JSONRemove
TheJSON REMOVE
function.Remove a JSON value from a JSON field at a given path.
-
JSONRemove
TheJSON REMOVE
function.Remove a JSON value from a JSON field at a given path.
-
JSONBRemove
TheJSONB REMOVE
function.Remove a JSONB value from a JSONB field at a given path.
-
JSONBRemove
TheJSONB REMOVE
function.Remove a JSONB value from a JSONB field at a given path.
-
Deleting
TheDELETING
function. -
Inserting
TheINSERTING
function. -
Updating
TheUPDATING
function. -
ConditionAsField
TheFIELD
function.Wrap a condition in a boolean field.
-
ConditionAsField
TheFIELD
function.Wrap a condition in a boolean field.
-
FieldCondition
TheCONDITION
function.Create a condition from a boolean field.
Databases that support boolean data types can use boolean expressions as predicates or as columns interchangeably. This extends to any type of field, including functions. A Postgres example:
select 1 where texteq('a', 'a');
-
FieldCondition
TheCONDITION
function.Create a condition from a boolean field.
Databases that support boolean data types can use boolean expressions as predicates or as columns interchangeably. This extends to any type of field, including functions. A Postgres example:
select 1 where texteq('a', 'a');
-
AnyValue
TheANY VALUE
function.Get any arbitrary value from the group.
-
AnyValue
TheANY VALUE
function.Get any arbitrary value from the group.
-
Avg
TheAVG
function. -
Avg
TheAVG
function. -
BitAndAgg
TheBIT AND AGG
function.Calculate the bitwise
AND
aggregate value. -
BitAndAgg
TheBIT AND AGG
function.Calculate the bitwise
AND
aggregate value. -
BitOrAgg
TheBIT OR AGG
function.Calculate the bitwise
OR
aggregate value. -
BitOrAgg
TheBIT OR AGG
function.Calculate the bitwise
OR
aggregate value. -
BitXorAgg
TheBIT XOR AGG
function.Calculate the bitwise
XOR
aggregate value. -
BitXorAgg
TheBIT XOR AGG
function.Calculate the bitwise
XOR
aggregate value. -
BitNandAgg
TheBIT NAND AGG
function.Calculate the bitwise
NAND
aggregate value. -
BitNandAgg
TheBIT NAND AGG
function.Calculate the bitwise
NAND
aggregate value. -
BitNorAgg
TheBIT NOR AGG
function.Calculate the bitwise
NOR
aggregate value. -
BitNorAgg
TheBIT NOR AGG
function.Calculate the bitwise
NOR
aggregate value. -
BitXNorAgg
TheBIT X NOR AGG
function.Calculate the bitwise
XNOR
aggregate value. -
BitXNorAgg
TheBIT X NOR AGG
function.Calculate the bitwise
XNOR
aggregate value. -
BoolAnd
TheBOOL AND
function. -
BoolAnd
TheBOOL AND
function. -
BoolOr
TheBOOL OR
function. -
BoolOr
TheBOOL OR
function. -
Corr
TheCORR
function.Calculate the correlation coefficient. This standard SQL function may be supported natively, or emulated using
DSL.covarPop(Field, Field)
andDSL.stddevPop(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
Corr
TheCORR
function.Calculate the correlation coefficient. This standard SQL function may be supported natively, or emulated using
DSL.covarPop(Field, Field)
andDSL.stddevPop(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
Count
TheCOUNT
function. -
Count
TheCOUNT
function. -
CovarSamp
TheCOVAR SAMP
function.Calculate the sample covariance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
CovarSamp
TheCOVAR SAMP
function.Calculate the sample covariance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
CovarPop
TheCOVAR POP
function.Calculate the population covariance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
CovarPop
TheCOVAR POP
function.Calculate the population covariance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
Max
TheMAX
function. -
Max
TheMAX
function. -
Median
TheMEDIAN
function. -
Median
TheMEDIAN
function. -
Min
TheMIN
function. -
Min
TheMIN
function. -
Product
ThePRODUCT
function.Get the sum over a numeric field: product(distinct field).
Few dialects currently support multiplicative aggregation natively. jOOQ emulates this using
exp(sum(log(arg)))
for strictly positive numbers, and does some additional handling for zero and negative numbers.Note that this implementation may introduce rounding errors, even for integer multiplication.
More information here: https://blog.jooq.org/how-to-write-a-multiplication-aggregate-function-in-sql.
-
Product
ThePRODUCT
function.Get the sum over a numeric field: product(distinct field).
Few dialects currently support multiplicative aggregation natively. jOOQ emulates this using
exp(sum(log(arg)))
for strictly positive numbers, and does some additional handling for zero and negative numbers.Note that this implementation may introduce rounding errors, even for integer multiplication.
More information here: https://blog.jooq.org/how-to-write-a-multiplication-aggregate-function-in-sql.
-
RegrAvgX
TheREGR AVGX
function.Calculate the average of the independent values (x). This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrAvgX
TheREGR AVGX
function.Calculate the average of the independent values (x). This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrAvgY
TheREGR AVGY
function.Calculate the average of the dependent values (y). This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrAvgY
TheREGR AVGY
function.Calculate the average of the dependent values (y). This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrCount
TheREGR COUNT
function.Calculate the number of non-
NULL
pairs. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrCount
TheREGR COUNT
function.Calculate the number of non-
NULL
pairs. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrIntercept
TheREGR INTERCEPT
function.Calculate the y intercept of the regression line. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrIntercept
public static final QOM.RegrIntercept RegrIntercept(Field<? extends Number> y, Field<? extends Number> x) TheREGR INTERCEPT
function.Calculate the y intercept of the regression line. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrR2
TheREGR R2
function.Calculate the coefficient of determination. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrR2
TheREGR R2
function.Calculate the coefficient of determination. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSlope
TheREGR SLOPE
function.Calculate the slope of the regression line. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSlope
TheREGR SLOPE
function.Calculate the slope of the regression line. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSxx
TheREGR SXX
function.Calculate the
REGR_SXX
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSxx
TheREGR SXX
function.Calculate the
REGR_SXX
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSxy
TheREGR SXY
function.Calculate the
REGR_SXY
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSxy
TheREGR SXY
function.Calculate the
REGR_SXY
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSyy
TheREGR SYY
function.Calculate the
REGR_SYY
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
RegrSyy
TheREGR SYY
function.Calculate the
REGR_SYY
auxiliary function. This standard SQL function may be supported natively, or emulated usingDSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
StddevPop
TheSTDDEV POP
function.Calculate the population standard deviation. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
StddevPop
TheSTDDEV POP
function.Calculate the population standard deviation. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
StddevSamp
TheSTDDEV SAMP
function.Calculate the sample standard deviation. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
StddevSamp
TheSTDDEV SAMP
function.Calculate the sample standard deviation. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
Sum
TheSUM
function. -
Sum
TheSUM
function. -
VarPop
TheVAR POP
function.Calculate the population variance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
VarPop
TheVAR POP
function.Calculate the population variance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
VarSamp
TheVAR SAMP
function.Calculate the sample variance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
VarSamp
TheVAR SAMP
function.Calculate the sample variance. This standard SQL function may be supported natively, or emulated using
DSL.sum(Field)
andDSL.count(Field)
. If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic. -
Goto
TheGOTO
function. -
Goto
TheGOTO
function. -
Execute
TheEXECUTE
function.Execute a statement dynamically from within procedural code.
Many dialects support some way of running procedural and SQL statements dynamically from within procedural code. For example, in Oracle, this syntax is required to run DDL statements from PL/SQL:
BEGIN EXECUTE IMMEDIATE 'CREATE TABLE x (i INT)'; END;
-
Execute
TheEXECUTE
function.Execute a statement dynamically from within procedural code.
Many dialects support some way of running procedural and SQL statements dynamically from within procedural code. For example, in Oracle, this syntax is required to run DDL statements from PL/SQL:
BEGIN EXECUTE IMMEDIATE 'CREATE TABLE x (i INT)'; END;
-
Return
TheRETURN_
function. -
Return
TheRETURN_
function. -
Signal
TheSIGNAL SQL STATE
function. -
Signal
TheSIGNAL SQL STATE
function. -
StArea
TheST AREA
function.Calculate the area from a spatial type.
-
StArea
TheST AREA
function.Calculate the area from a spatial type.
-
StAsBinary
TheST ASBINARY
function.Create a WKB representation from a spatial type.
-
StAsBinary
TheST ASBINARY
function.Create a WKB representation from a spatial type.
-
StAsText
TheST ASTEXT
function.Create a text representation from a spatial type.
-
StAsText
TheST ASTEXT
function.Create a text representation from a spatial type.
-
StCentroid
TheST CENTROID
function.Get the geometric center of a spatial value.
-
StCentroid
TheST CENTROID
function.Get the geometric center of a spatial value.
-
StContains
TheST CONTAINS
function.Check if a spatial value contains another.
-
StContains
@Pro public static final <T extends Spatial> QOM.StContains<T> StContains(Field<T> arg1, Field<T> arg2) TheST CONTAINS
function.Check if a spatial value contains another.
-
StCrosses
TheST CROSSES
function.Check if a geometry crosses another.
-
StCrosses
TheST CROSSES
function.Check if a geometry crosses another.
-
StDifference
TheST DIFFERENCE
function.Get the difference of two spatial values.
-
StDifference
@Pro public static final <T extends Spatial> QOM.StDifference<T> StDifference(Field<T> arg1, Field<T> arg2) TheST DIFFERENCE
function.Get the difference of two spatial values.
-
StDisjoint
TheST DISJOINT
function.Check if a spatial value is disjoint from another.
-
StDisjoint
@Pro public static final <T extends Spatial> QOM.StDisjoint<T> StDisjoint(Field<T> arg1, Field<T> arg2) TheST DISJOINT
function.Check if a spatial value is disjoint from another.
-
StDistance
TheST DISTANCE
function.Get the distance between two spatial values.
-
StDistance
@Pro public static final <T extends Spatial> QOM.StDistance<T> StDistance(Field<T> arg1, Field<T> arg2) TheST DISTANCE
function.Get the distance between two spatial values.
-
StEndPoint
TheST ENDPOINT
function.Get the end point of a spatial value.
-
StEndPoint
TheST ENDPOINT
function.Get the end point of a spatial value.
-
StEquals
TheST EQUALS
function.Check if a spatial value is equal to another.
-
StEquals
TheST EQUALS
function.Check if a spatial value is equal to another.
-
StExteriorRing
TheST EXTERIORRING
function.Get the exterior ring of a spatial value.
-
StExteriorRing
TheST EXTERIORRING
function.Get the exterior ring of a spatial value.
-
StGeometryN
TheST GEOMETRYN
function.Get the N-th geometry from a collection of spatial values.
-
StGeometryN
@Pro public static final <T extends Spatial> QOM.StGeometryN<T> StGeometryN(Field<T> value, Field<? extends Number> position) TheST GEOMETRYN
function.Get the N-th geometry from a collection of spatial values.
-
StGeometryType
TheST GEOMETRYTYPE
function.Get the geometry type of a spatial value.
-
StGeometryType
TheST GEOMETRYTYPE
function.Get the geometry type of a spatial value.
-
StGeomFromText
TheST GEOMFROMTEXT
function.Create a geometry from a text representation.
-
StGeomFromText
@Pro public static final QOM.StGeomFromText StGeomFromText(Field<String> text, Field<? extends Number> srid) TheST GEOMFROMTEXT
function.Create a geometry from a text representation.
-
StGeomFromWKB
TheST GEOMFROMWKB
function.Create a geometry from a binary representation.
-
StGeomFromWKB
@Pro public static final QOM.StGeomFromWKB StGeomFromWKB(Field<byte[]> wkb, Field<? extends Number> srid) TheST GEOMFROMWKB
function.Create a geometry from a binary representation.
-
StInteriorRingN
TheST INTERIORRINGN
function.Get the N-th interior ring of a spatial value.
-
StInteriorRingN
@Pro public static final QOM.StInteriorRingN StInteriorRingN(Field<Geometry> value, Field<? extends Number> position) TheST INTERIORRINGN
function.Get the N-th interior ring of a spatial value.
-
StIntersection
TheST INTERSECTION
function.Get the intersection of two spatial values.
-
StIntersection
@Pro public static final <T extends Spatial> QOM.StIntersection<T> StIntersection(Field<T> arg1, Field<T> arg2) TheST INTERSECTION
function.Get the intersection of two spatial values.
-
StIntersects
TheST INTERSECTS
function.Check whether two spatial values intersect.
-
StIntersects
@Pro public static final <T extends Spatial> QOM.StIntersects<T> StIntersects(Field<T> arg1, Field<T> arg2) TheST INTERSECTS
function.Check whether two spatial values intersect.
-
StIsClosed
TheST ISCLOSED
function.Check whether a spatial value is closed.
-
StIsClosed
TheST ISCLOSED
function.Check whether a spatial value is closed.
-
StIsEmpty
TheST ISEMPTY
function.Check whether a spatial value is empty.
-
StIsEmpty
TheST ISEMPTY
function.Check whether a spatial value is empty.
-
StLength
TheST LENGTH
function.Get the length of a spatial value.
-
StLength
TheST LENGTH
function.Get the length of a spatial value.
-
StNumGeometries
TheST NUMGEOMETRIES
function.Get the number of geometries in a collection of spatial values.
-
StNumGeometries
TheST NUMGEOMETRIES
function.Get the number of geometries in a collection of spatial values.
-
StNumInteriorRings
TheST NUMINTERIORRING
function.Get the number of interior rings of a spatial value.
-
StNumInteriorRings
TheST NUMINTERIORRING
function.Get the number of interior rings of a spatial value.
-
StNumPoints
TheST NUMPOINTS
function.Get the number of points in a spatial value.
-
StNumPoints
TheST NUMPOINTS
function.Get the number of points in a spatial value.
-
StOverlaps
TheST OVERLAPS
function.Check whether two spatial values overlap.
-
StOverlaps
@Pro public static final <T extends Spatial> QOM.StOverlaps<T> StOverlaps(Field<T> arg1, Field<T> arg2) TheST OVERLAPS
function.Check whether two spatial values overlap.
-
StPointN
TheST POINTN
function.Get the Nth point of a spatial value.
-
StPointN
@Pro public static final <T extends Spatial> QOM.StPointN<T> StPointN(Field<T> value, Field<? extends Number> position) TheST POINTN
function.Get the Nth point of a spatial value.
-
StSrid
TheST SRID
function.Get the SRID of a spatial value.
-
StSrid
TheST SRID
function.Get the SRID of a spatial value.
-
StStartPoint
TheST STARTPOINT
function.Get the start point of a spatial value.
-
StStartPoint
TheST STARTPOINT
function.Get the start point of a spatial value.
-
StTouches
TheST TOUCHES
function.Check whether two spatial values touch.
-
StTouches
@Pro public static final <T extends Spatial> QOM.StTouches<T> StTouches(Field<T> arg1, Field<T> arg2) TheST TOUCHES
function.Check whether two spatial values touch.
-
StUnion
TheST UNION
function.Get the union of two spatial values.
-
StUnion
TheST UNION
function.Get the union of two spatial values.
-
StWithin
TheST WITHIN
function.Check if a spatial value is contained within another.
-
StWithin
TheST WITHIN
function.Check if a spatial value is contained within another.
-
StX
TheST X
function.Extract the X coordinate from the argument geometry.
-
StX
TheST X
function.Extract the X coordinate from the argument geometry.
-
StY
TheST Y
function.Extract the Y coordinate from the argument geometry.
-
StY
TheST Y
function.Extract the Y coordinate from the argument geometry.
-
StZ
TheST Z
function.Extract the Z coordinate from the argument geometry.
-
StZ
TheST Z
function.Extract the Z coordinate from the argument geometry.
-
unmodifiable
Turn an array into an unmodifiableQOM.UnmodifiableList
. -
unmodifiable
@Internal public static final <Q extends QueryPart> QOM.UnmodifiableList<Q> unmodifiable(List<Q> list) Turn aList
into an unmodifiableQOM.UnmodifiableList
. -
unmodifiable
@Internal public static final <Q extends QueryPart> QOM.UnmodifiableList<Q> unmodifiable(Collection<Q> collection) Turn aCollection
into an unmodifiableQOM.UnmodifiableList
. -
unmodifiable
@Internal public static final <K extends QueryPart,V extends QueryPart> QOM.UnmodifiableMap<K,V> unmodifiable(Map<K, V> map) Turn aMap
into an unmodifiableQOM.UnmodifiableMap
. -
tuple
@Internal public static final <Q1 extends QueryPart,Q2 extends QueryPart> QOM.Tuple2<Q1,Q2> tuple(Q1 q1, Q2 q2)
-