|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||
abs([field])
acos([field])
Operator.AND
Operator.AND
CONNECT BY clause to the query
CONNECT BY NOCYCLE clause to the query
Factory create = new Factory();
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.execute();
USING
clause
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query.
USING
clause
If this is not supported by your RDBMS, then jOOQ will try to simulate
this behaviour using the information provided in this query.
OrderProvider.addLimit(int, int) with offset = 0
1 in SQL!
newRecord();
setRecord(record);
ON DUPLICATE KEY UPDATE clause of this
INSERT statement, where this is supported.
ON DUPLICATE KEY UPDATE clause of this
INSERT statement, where this is supported.
ON DUPLICATE KEY UPDATE clause of
this INSERT statement, where this is supported.
AES_DECRYPT() function
AES_DECRYPT() function
AES_ENCRYPT() function
AES_ENCRYPT() function
GROUP BY context.QueryPart that can create an aliased QueryPart of itselfOperator.AND
operator.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND operator
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator and proceed to the next step.
Operator.AND operator.
Operator.AND operator.
Operator.AND operator.
Operator.AND operator
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Operator.AND operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
...
- andExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with an EXISTS clause using the
Operator.AND operator.
- andExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator
- andExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator.
- andExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.AND operator
- andFollowing(int) -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andNot(Condition) -
Method in interface org.jooq.Condition
- Combine this condition with a negated other one using the
Operator.AND operator.
- andNot(Condition) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator
- andNot(Condition) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator and proceed to the next step.
- andNot(Condition) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator.
- andNot(Condition) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator
- andNotExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with a NOT EXIST clause using the
Operator.AND operator.
- andNotExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator
- andNotExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator and proceed to the next step.
- andNotExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator.
- andNotExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.AND operator
- andPreceding(int) -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andUnboundedFollowing() -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- andUnboundedPreceding() -
Method in interface org.jooq.WindowRowsAndStep
- Add a
...
- ANSIDATE -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- ArrayRecord<E> - Interface in org.jooq
- A "record" that encapsulates an Oracle-style ARRAY (or VARRAY), additionally
providing some convenience methods
- ArrayRecordImpl<T> - Class in org.jooq.impl
- A common base class for Oracle ARRAY types
This type is for JOOQ INTERNAL USE only.
- ArrayRecordImpl(String, DataType<T>, Configuration) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Create an empty array record
- ArrayRecordImpl(String, DataType<T>) -
Constructor for class org.jooq.impl.ArrayRecordImpl
- Create an empty array record
- as(String) -
Method in interface org.jooq.AliasProvider
- Get an aliased QueryPart.
- as(String) -
Method in interface org.jooq.Field
- Create an alias for this field
- as(String) -
Method in class org.jooq.impl.CustomField
-
- as(String) -
Method in class org.jooq.impl.TableImpl
- Subclasses may override this method to provide custom aliasing
implementations
Get an aliased QueryPart.
- asArrayDataType(Class<A>) -
Method in interface org.jooq.DataType
- Retrieve the data type for an Oracle-style ARRAY of this data type
- asArrayDataType(Class<A>) -
Method in class org.jooq.impl.AbstractDataType
-
- asc() -
Method in interface org.jooq.Field
- Create an ascending sort field from this field
- ascii() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- ascii(String) -
Static method in class org.jooq.impl.Factory
- Get the ascii(field) function
- ascii(Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the ascii(field) function
This renders the ascii function:
ascii([field])
- ASEDataType<T> - Class in org.jooq.util.ase
- Supported data types for the
SQLDialect.ASE dialect - ASEFactory - Class in org.jooq.util.ase
- A
SQLDialect.ASE specific factory - ASEFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.ase.ASEFactory
- Create a factory with connection and a schema mapping configured
- ASEFactory(Connection) -
Constructor for class org.jooq.util.ase.ASEFactory
- Create a factory with connection
- asEnumDataType(Class<E>) -
Method in interface org.jooq.DataType
- Retrieve the data type for a given enum data type
- asEnumDataType(Class<E>) -
Method in class org.jooq.impl.AbstractDataType
-
- asField() -
Method in interface org.jooq.FieldLike
- The underlying field representation of this object
This method is useful for things like
SELECT y.*, (SELECT a FROM x) FROM y
- asField(String) -
Method in interface org.jooq.FieldLike
- The underlying field representation of this object
This method is useful for things like
SELECT y.*, (SELECT a FROM x) [alias] FROM y
- asField() -
Method in class org.jooq.impl.AbstractRoutine
-
- asField(String) -
Method in class org.jooq.impl.AbstractRoutine
-
- asin() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- asin(Number) -
Static method in class org.jooq.impl.Factory
- Get the arc sine(field) function
- asin(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the arc sine(field) function
This renders the asin function where available:
asin([field])
- asMasterDataType(Class<M>) -
Method in interface org.jooq.DataType
- Retrieve the data type for a given master data type
- asMasterDataType(Class<M>) -
Method in class org.jooq.impl.AbstractDataType
-
- asTable() -
Method in interface org.jooq.TableLike
- The underlying table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...
- asTable(String) -
Method in interface org.jooq.TableLike
- The underlying aliased table representation of this object
This method is useful for things like
SELECT * FROM (SELECT * FROM x WHERE x.a = '1') [alias] WHERE ...
- atan() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan(Number) -
Static method in class org.jooq.impl.Factory
- Get the arc tangent(field) function
- atan(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the arc tangent(field) function
This renders the atan function where available:
atan([field])
- atan2(Number) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan2(Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- atan2(Number, Number) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Number, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Field<? extends Number>, Number) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
- atan2(Field<? extends Number>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the atan2(field, y) function
This renders the atan2 or atn2 function where available:
atan2([x], [y]) or
atn2([x], [y])
- attach(Configuration) -
Method in interface org.jooq.Attachable
- Attach this object to a new
Configuration
- attach(Attachable...) -
Method in interface org.jooq.FactoryOperations
- Attach this
Factory to some attachables
- attach(Collection<Attachable>) -
Method in interface org.jooq.FactoryOperations
- Attach this
Factory to some attachables
- attach(Configuration) -
Method in class org.jooq.impl.AbstractRoutine
-
- attach(Configuration) -
Method in class org.jooq.impl.CustomCondition
-
- attach(Configuration) -
Method in class org.jooq.impl.CustomField
- Subclasses may further override this method
By default, nothing is done on an attachment event.
- attach(Configuration) -
Method in class org.jooq.impl.CustomTable
- Subclasses may further override this method
By default, nothing is done on an attachment event.
- attach(Attachable...) -
Method in class org.jooq.impl.Factory
- Attach this
Factory to some attachables
- attach(Collection<Attachable>) -
Method in class org.jooq.impl.Factory
- Attach this
Factory to some attachables
- Attachable - Interface in org.jooq
- An object in jOOQ that can have an underlying
Configuration attached
or detached. - AttachableInternal - Interface in org.jooq
- Base functionality declaration for all
Attachables
This interface is for JOOQ INTERNAL USE only. - avg() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- avg(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the average over a numeric field: avg(field)
- avgDistinct(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the average over a numeric field: avg(distinct field)
- avgOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
Batch's DSL API.this between minValue and maxValue
this between minValue and maxValue
Types.BIGINT type
Types.BIGINT type
Types.BINARY type
QueryPart.
QueryPart's.
QueryPart's.
QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
BindContext for the context of this factory
This will return an initialised bind context as such:
Context.declareFields() == falseContext.declareTables() == falseQueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only.
QueryPart's and their contained
values to a PreparedStatement's bind variables.BindContext for the context of this factory
This will return an initialised bind context as such:
Context.declareFields() == falseContext.declareTables() == falseTypes.BIT type
BIT_COUNT(field) function, counting the number of
bits that are set in this number.
BIT_COUNT(field) function, counting the number of
bits that are set in this number.
Types.BLOB type
Types.BOOLEAN type
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
CASE x WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
DataType has to be
"guessed" from the jOOQ-configured data types.
ceil([field]) or
ceiling([field])
... or simulates it elsewhere using round:
round([field] + 0.499999999999999)
Types.CHAR type
Types.CLOB type
PreparedStatement and
ResultSet
If you fetch all records from the underlying ResultSet, jOOQ
Cursor implementations will close themselves for you.
COALESCE(value1, value2, ... , value n)
function
COALESCE(field1, field2, ... , field n)
function
Returns the dialect's equivalent to COALESCE:
Oracle COALESCE
COMPRESS() function
COMPRESS() function
fields[0] || fields[1] || ...
- Condition - Interface in org.jooq
- A condition to be used in a query's where part
- condition(String) -
Static method in class org.jooq.impl.Factory
- Create a new condition holding plain SQL.
- condition(String, Object...) -
Static method in class org.jooq.impl.Factory
- Create a new condition holding plain SQL.
- ConditionProvider - Interface in org.jooq
- A common interface for all objects holding conditions (e.g. queries)
- Configuration - Interface in org.jooq
- The Configuration holds data about sql dialects and connections
- ConfigurationProvider - Interface in org.jooq
- Implement this interface and supply it to the
ConfigurationRegistry. - ConfigurationRegistry - Class in org.jooq
- A public static registry that can provide factories (
Configuration's)
to Attachable's upon deserialisation. - ConfigurationRegistry() -
Constructor for class org.jooq.ConfigurationRegistry
-
- connectBy(Condition) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY clause to the query
- connectBy(String) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectBy(String, Object...) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectByIsCycle() -
Static method in class org.jooq.util.oracle.OracleFactory
- Retrieve the Oracle-specific
CONNECT_BY_ISCYCLE pseudo-field
(to be used along with CONNECT BY clauses)
- connectByIsLeaf() -
Static method in class org.jooq.util.oracle.OracleFactory
- Retrieve the Oracle-specific
CONNECT_BY_ISLEAF pseudo-field
(to be used along with CONNECT BY clauses)
- connectByNoCycle(Condition) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
- connectByNoCycle(String) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- connectByNoCycle(String, Object...) -
Method in interface org.jooq.SelectConnectByStep
- Add an Oracle-specific
CONNECT BY NOCYCLE clause to the
query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- Constants - Class in org.jooq
- Some publicly available constants used in jOOQ
- containsAny(String, char...) -
Static method in class org.jooq.tools.StringUtils
- Checks if the String contains any character in the given
set of characters.
- Context<C extends Context<C>> - Interface in org.jooq
- A context type that is used for rendering SQL or for binding
This interface is for JOOQ INTERNAL USE only.
- convert(Object) -
Method in interface org.jooq.DataType
- Convert an arbitrary object into
<T>
- convert(Object) -
Method in class org.jooq.impl.AbstractDataType
-
- Convert - Class in org.jooq.tools
- Utility methods for type conversions
- convert(Object, Class<? extends T>) -
Static method in class org.jooq.tools.Convert
- Convert an object to a type.
- convert(List<?>, Class<? extends T>) -
Static method in class org.jooq.tools.Convert
- Convert a list of objects to a list of
T, using
Convert.convert(Object, Class)
- convertArray(Object[], Class<?>) -
Static method in class org.jooq.tools.Convert
- Convert an array into another one by these rules
If
toClass is not an array class, then make it an array
class first
If toClass is an array class, then create an instance
from it, and convert all elements in the from array one by
one, using Convert.convert(Object, Class)
- copy() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- copy() -
Method in interface org.jooq.UpdatableRecord
- Duplicate this record (in memory) and reset all fields from the primary
key or main unique key, such that a subsequent call to
UpdatableRecord.store()
will result in an INSERT statement.
- cos() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cos(Number) -
Static method in class org.jooq.impl.Factory
- Get the cosine(field) function
- cos(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the cosine(field) function
This renders the cos function where available:
cos([field])
- cosh() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cosh(Number) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cosine function: cosh(field)
- cosh(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cosine function: cosh(field)
This renders the cosh function where available:
cosh([field]) ... or simulates it elsewhere using
exp: (exp([field] * 2) + 1) / (exp([field] * 2))
- cot() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- cot(Number) -
Static method in class org.jooq.impl.Factory
- Get the cotangent(field) function
- cot(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the cotangent(field) function
This renders the cot function where available:
cot([field]) ... or simulates it elsewhere using
sin and cos: cos([field]) / sin([field])
- coth() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- coth(Number) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cotangent function: coth(field)
- coth(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic cotangent function: coth(field)
This is not supported by any RDBMS, but simulated using exp exp:
(exp([field] * 2) + 1) / (exp([field] * 2) - 1)
- count() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- count() -
Static method in class org.jooq.impl.Factory
- Get the count(*) function
- count(Field<?>) -
Static method in class org.jooq.impl.Factory
- Get the count(field) function
- countDistinct() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- countDistinct(Field<?>) -
Static method in class org.jooq.impl.Factory
- Get the count(distinct field) function
- countMatches(String, String) -
Static method in class org.jooq.tools.StringUtils
-
Counts how many times the substring appears in the larger String.
- countOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- createArray() -
Method in interface org.jooq.ArrayRecord
- Create an
Array from this ArrayRecord
This method is for INTERNAL use only.
- createArray() -
Method in class org.jooq.impl.ArrayRecordImpl
-
- createArray(Connection, ArrayRecord<?>) -
Static method in class org.jooq.util.oracle.OracleUtils
- Create an Oracle
ARRAY
- createField(String, DataType<T>, UDT<R>) -
Static method in class org.jooq.impl.UDTImpl
- Subclasses may call this method to create
UDTField objects that
are linked to this table.
- createForeignKey(UniqueKey<U>, Table<R>, TableField<R, ?>...) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for foreign keys
- createIdentity(Table<R>, TableField<R, T>) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for identities
- createParameter(String, DataType<T>) -
Static method in class org.jooq.impl.AbstractRoutine
- Subclasses may call this method to create
UDTField objects that
are linked to this table.
- createUniqueKey(Table<R>, TableField<R, ?>...) -
Static method in class org.jooq.impl.AbstractKeys
- Factory method for unique keys
- crossJoin(TableLike<?>) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(TableLike)
If this syntax is unavailable, it is simulated with a regular
INNER JOIN.
- crossJoin(String) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String)
If this syntax is unavailable, it is simulated with a regular
INNER JOIN.
- crossJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
CROSS JOIN a table to the last table
added to the FROM clause using
Table.crossJoin(String, Object...)
- crossJoin(TableLike<?>) -
Method in interface org.jooq.Table
CROSS JOIN a table to this table.
- crossJoin(String) -
Method in interface org.jooq.Table
CROSS JOIN a table to this table.
- crossJoin(String, Object...) -
Method in interface org.jooq.Table
CROSS JOIN a table to this table.
- CSVParser - Class in org.jooq.tools.csv
- A very simple CSV parser released under a commercial-friendly license.
- CSVParser() -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser using a comma for the separator.
- CSVParser(char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser with supplied separator.
- CSVParser(char, char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVParser with supplied separator and quote char.
- CSVParser(char, char, char) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVParser(char, char, char, boolean) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVParser(char, char, char, boolean, boolean) -
Constructor for class org.jooq.tools.csv.CSVParser
- Constructs CSVReader with supplied separator and quote char.
- CSVReader - Class in org.jooq.tools.csv
- A very simple CSV reader released under a commercial-friendly license.
- CSVReader(Reader) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader using a comma for the separator.
- CSVReader(Reader, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator.
- CSVReader(Reader, char, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator, quote char and quote
handling behavior.
- CSVReader(Reader, char, char, char) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, int) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- CSVReader(Reader, char, char, char, int, boolean, boolean) -
Constructor for class org.jooq.tools.csv.CSVReader
- Constructs CSVReader with supplied separator and quote char.
- cube(Field<?>...) -
Static method in class org.jooq.impl.Factory
- Create a CUBE(field1, field2, .., fieldn) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE, ROLLUP, and GROUPING SETS
clauses in grouping contexts: http://msdn.microsoft.com/en-US/library/bb522495.aspx
- cumeDist() -
Static method in class org.jooq.impl.Factory
- The
cume_dist() over ([analytic clause]) function.
- currentDate() -
Static method in class org.jooq.impl.Factory
- Get the current_date() function
This translates into any dialect
- currentTime() -
Static method in class org.jooq.impl.Factory
- Get the current_time() function
This translates into any dialect
- currentTimestamp() -
Static method in class org.jooq.impl.Factory
- Get the current_timestamp() function
This translates into any dialect
- currentUser() -
Static method in class org.jooq.impl.Factory
- Get the current_user() function
This translates into any dialect
- currval(Sequence<T>) -
Method in interface org.jooq.FactoryOperations
- Convenience method to fetch the CURRVAL for a sequence directly from this
Factory's underlying JDBC Connection
- currval(Sequence<T>) -
Method in class org.jooq.impl.Factory
- Convenience method to fetch the CURRVAL for a sequence directly from this
Factory's underlying JDBC Connection
- currval() -
Method in class org.jooq.impl.SequenceImpl
-
- currval() -
Method in interface org.jooq.Sequence
- Get the current value of this sequence
- Cursor<R extends Record> - Interface in org.jooq
- Cursors allow for lazy, sequential access to an underlying JDBC
ResultSet. - CustomCondition - Class in org.jooq.impl
- A base class for custom
Condition implementations in client code. - CustomCondition() -
Constructor for class org.jooq.impl.CustomCondition
-
- CustomField<T> - Class in org.jooq.impl
- A base class for custom
Field implementations in client code. - CustomField(String, DataType<T>) -
Constructor for class org.jooq.impl.CustomField
-
- CustomRecord<R extends TableRecord<R>> - Class in org.jooq.impl
- A base class for custom
TableRecord implementations in client code. - CustomRecord(Table<R>) -
Constructor for class org.jooq.impl.CustomRecord
-
- CustomTable<R extends TableRecord<R>> - Class in org.jooq.impl
- A base class for custom
Table implementations in client code. - CustomTable(String) -
Constructor for class org.jooq.impl.CustomTable
-
- CustomTable(String, Schema) -
Constructor for class org.jooq.impl.CustomTable
-
DataAccessException is a generic RuntimeException
indicating that something went wrong while executing a SQL statement from
jOOQ.Types.DATE type
SQLDialect.DB2 dialectSQLDialect.DB2 specific factoryTypes.DECIMAL type
Types.DECIMAL type
Field in the SELECT clause of the query).
Context.declareFields()
QueryPart is able to declare fields in a
SELECT clause.
QueryPart is able to declare tables in a
FROM clause or JOIN clause.
Table in the FROM or JOIN clause of the
query).
Context.declareTables()
Case statement.
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
DECODE(expression, search, result[, search , result]... [, default])
function
Returns the dialect's equivalent to DECODE:
Oracle DECODE
Other dialects:
CASE WHEN [this = search] THEN [result],
[WHEN more...
- decode(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DECODE() function
Don't mix this up with the various Factory.decode() methods!
- decode(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DECODE() function
Don't mix this up with the various Factory.decode() methods!
- DEFAULT_ESCAPE_CHARACTER -
Static variable in class org.jooq.tools.csv.CSVParser
- The default escape character to use if none is supplied to the
constructor.
- DEFAULT_IGNORE_LEADING_WHITESPACE -
Static variable in class org.jooq.tools.csv.CSVParser
- The default leading whitespace behavior to use if none is supplied to the
constructor
- DEFAULT_QUOTE_CHARACTER -
Static variable in class org.jooq.tools.csv.CSVParser
- The default quote character to use if none is supplied to the
constructor.
- DEFAULT_SEPARATOR -
Static variable in class org.jooq.tools.csv.CSVParser
- The default separator to use if none is supplied to the constructor.
- DEFAULT_SKIP_LINES -
Static variable in class org.jooq.tools.csv.CSVReader
- The default line to start reading.
- DEFAULT_STRICT_QUOTES -
Static variable in class org.jooq.tools.csv.CSVParser
- The default strict quote behavior to use if none is supplied to the
constructor
- defaultIfEmpty(String, String) -
Static method in class org.jooq.tools.StringUtils
- Returns either the passed in String, or if the String is
empty or
null, the value of defaultStr.
- defaultString(String) -
Static method in class org.jooq.tools.StringUtils
-
Returns either the passed in String, or if the String is
null, an empty String ("").
- defaultString(String, String) -
Static method in class org.jooq.tools.StringUtils
- Returns either the passed in String, or if the String is
null, the value of defaultStr.
- deg() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- deg(Number) -
Static method in class org.jooq.impl.Factory
- Calculate degrees from radians from this field
- deg(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Calculate degrees from radians from this field
This renders the degrees function where available:
degrees([field]) ... or simulates it elsewhere:
[field] * 180 / PI
- Delete<R extends Record> - Interface in org.jooq
- A
Query that can delete data in the database. - delete(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL delete statement.
- delete(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new DSL delete statement.
- delete() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- delete() -
Method in interface org.jooq.UpdatableRecord
- Deletes this record from the database, based on the value of the primary
key or main unique key.
- DeleteConditionStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete's DSL API. - DeleteFinalStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete's DSL API. - DeleteQuery<R extends Record> - Interface in org.jooq
- A query used for deletion of data
- deleteQuery(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
DeleteQuery
- deleteQuery(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
DeleteQuery
- deleteUsing(TableField<R, ?>...) -
Method in class org.jooq.impl.TableRecordImpl
-
- deleteUsing(TableField<R, ?>...) -
Method in interface org.jooq.TableRecord
- Deletes this record from the database, based on the value of the provided
keys.
- deleteWhere(Condition) -
Method in interface org.jooq.MergeMatchedDeleteStep
- Add an additional
DELETE WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause.
- DeleteWhereStep<R extends Record> - Interface in org.jooq
- This type is used for the
Delete's DSL API. - denseRank() -
Static method in class org.jooq.impl.Factory
- The
dense_rank() over ([analytic clause]) function.
- DerbyDataType<T> - Class in org.jooq.util.derby
- Supported data types for the
SQLDialect.DERBY dialect - DerbyFactory - Class in org.jooq.util.derby
- A
SQLDialect.DERBY specific factory - DerbyFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.derby.DerbyFactory
- Create a factory with connection and a schema mapping configured
- DerbyFactory(Connection) -
Constructor for class org.jooq.util.derby.DerbyFactory
- Create a factory with connection
- desc() -
Method in interface org.jooq.Field
- Create a descending sort field from this field
- desDecrypt(String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT() function
- desDecrypt(Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT() function
- desDecrypt(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT() function
- desDecrypt(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_DECRYPT() function
- desEncrypt(String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT() function
- desEncrypt(Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT() function
- desEncrypt(String, String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT() function
- desEncrypt(Field<String>, Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
DES_ENCRYPT() function
- DetachedException - Exception in org.jooq.exception
- An operation was invoked on a detached object (
Query,
QueryPart, or UpdatableRecord). - DetachedException(String) -
Constructor for exception org.jooq.exception.DetachedException
- Constructor for DetachedException.
- div(Number) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
- div(Field<? extends Number>) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
- DOUBLE -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.DOUBLE type
- DOUBLE -
Static variable in class org.jooq.util.db2.DB2DataType
-
- DOUBLE -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- DOUBLE -
Static variable in class org.jooq.util.h2.H2DataType
-
- DOUBLE -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- DOUBLE -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- DOUBLE -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- DOUBLE -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- DOUBLE_PRECISION -
Static variable in class org.jooq.util.ase.ASEDataType
-
- DOUBLE_PRECISION -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- DOUBLEPRECISION -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UByte
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UInteger
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.ULong
-
- doubleValue() -
Method in class org.jooq.tools.unsigned.UShort
-
E literal (Euler number)
This will be any of the following:
The underlying RDBMS' E literal or E() function
Math.E
ENCODE() function
ENCODE() function
this = value
If value == null, then this will return a condition
equivalent to Field.isNull() for convenience.
this = field
this = (SelectequalAll(Select<?>) -
Method in interface org.jooq.Field
this = all (SelectequalAll(T...) -
Method in interface org.jooq.Field
this = all (array)
This is natively supported by SQLDialect.POSTGRES.
- equalAll(Field<T[]>) -
Method in interface org.jooq.Field
this = all (array)
This is natively supported by SQLDialect.POSTGRES.
- equalAny(Select<?>) -
Method in interface org.jooq.Field
this = any (SelectequalAny(T...) -
Method in interface org.jooq.Field
this = any (array)
This is natively supported by SQLDialect.POSTGRES.
- equalAny(Field<T[]>) -
Method in interface org.jooq.Field
this = any (array)
This is natively supported by SQLDialect.POSTGRES.
- equals(Object) -
Method in interface org.jooq.Field
- Watch out!
- equals(Object) -
Method in class org.jooq.impl.AbstractDataType
-
- equals(Object) -
Method in class org.jooq.tools.unsigned.UByte
-
- equals(Object) -
Method in class org.jooq.tools.unsigned.UInteger
-
- equals(Object) -
Method in class org.jooq.tools.unsigned.ULong
-
- equals(Object) -
Method in class org.jooq.tools.unsigned.UShort
-
- equalSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.equalAny(Select) instead
- error(Object) -
Method in class org.jooq.tools.JooqLogger
-
- error(Object, Object) -
Method in class org.jooq.tools.JooqLogger
-
- error(Object, Throwable) -
Method in class org.jooq.tools.JooqLogger
-
- error(Object, Object, Throwable) -
Method in class org.jooq.tools.JooqLogger
-
- errors() -
Method in interface org.jooq.Loader
- A list of errors that might have happened during the load.
- escape(String) -
Static method in class org.jooq.tools.json.JSONObject
- Escape quotes, \, /, \r, \n, \b, \f, \t and other control characters
(U+0000 through U+001F).
- escape(String) -
Static method in class org.jooq.tools.json.JSONValue
- Escape quotes, \, /, \r, \n, \b, \f, \t and other control characters
(U+0000 through U+001F).
- except(Select<R>) -
Method in interface org.jooq.Select
- Combine with other selects
- exception() -
Method in interface org.jooq.LoaderError
- The underlying
DataAccessException that caused the error
- execute() -
Method in interface org.jooq.Batch
- Execute the batch operation.
- execute(String) -
Method in interface org.jooq.FactoryOperations
- Execute a query holding plain SQL.
- execute(String, Object...) -
Method in interface org.jooq.FactoryOperations
- Execute a new query holding plain SQL.
- execute(Configuration) -
Method in class org.jooq.impl.AbstractRoutine
-
- execute() -
Method in class org.jooq.impl.AbstractRoutine
-
- execute(String) -
Method in class org.jooq.impl.Factory
- Execute a query holding plain SQL.
- execute(String, Object...) -
Method in class org.jooq.impl.Factory
- Execute a new query holding plain SQL.
- execute() -
Method in interface org.jooq.LoaderLoadStep
- Execute the load.
- execute() -
Method in interface org.jooq.Query
- Execute the query, if it has been created with a properly configured
factory
- execute(Configuration) -
Method in interface org.jooq.Routine
- Execute the stored object using a
Configuration object
- execute() -
Method in interface org.jooq.Routine
- Execute the stored object on an underlying connection
- executeDelete(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Delete records from a table
DELETE FROM [table]
- executeDelete(Table<R>, Condition) -
Method in interface org.jooq.FactoryOperations
- Delete records from a table
DELETE FROM [table] WHERE [condition]
- executeDelete(Table<R>) -
Method in class org.jooq.impl.Factory
- Delete records from a table
DELETE FROM [table]
- executeDelete(Table<R>, Condition) -
Method in class org.jooq.impl.Factory
- Delete records from a table
DELETE FROM [table] WHERE [condition]
- executeDeleteOne(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Delete one record in a table
DELETE FROM [table]
- executeDeleteOne(Table<R>, Condition) -
Method in interface org.jooq.FactoryOperations
- Delete one record in a table
DELETE FROM [table] WHERE [condition]
- executeDeleteOne(Table<R>) -
Method in class org.jooq.impl.Factory
- Delete one record in a table
DELETE FROM [table]
- executeDeleteOne(Table<R>, Condition) -
Method in class org.jooq.impl.Factory
- Delete one record in a table
DELETE FROM [table] WHERE [condition]
- executeInsert(Table<R>, R) -
Method in interface org.jooq.FactoryOperations
- Insert one record
INSERT INTO [table] ...
- executeInsert(Table<R>, R) -
Method in class org.jooq.impl.Factory
- Insert one record
INSERT INTO [table] ...
- executeUpdate(Table<R>, R) -
Method in interface org.jooq.FactoryOperations
- Update a table
UPDATE [table] SET [modified values in record]
- executeUpdate(Table<R>, R, Condition) -
Method in interface org.jooq.FactoryOperations
- Update a table
UPDATE [table] SET [modified values in record] WHERE [condition]
- executeUpdate(Table<R>, R) -
Method in class org.jooq.impl.Factory
- Update a table
UPDATE [table] SET [modified values in record]
- executeUpdate(Table<R>, R, Condition) -
Method in class org.jooq.impl.Factory
- Update a table
UPDATE [table] SET [modified values in record] WHERE [condition]
- executeUpdateOne(Table<R>, R) -
Method in interface org.jooq.FactoryOperations
- Update one record in a table
UPDATE [table] SET [modified values in record]
- executeUpdateOne(Table<R>, R, Condition) -
Method in interface org.jooq.FactoryOperations
- Update one record in a table
UPDATE [table] SET [modified values in record] WHERE [condition]
- executeUpdateOne(Table<R>, R) -
Method in class org.jooq.impl.Factory
- Update one record in a table
UPDATE [table] SET [modified values in record]
- executeUpdateOne(Table<R>, R, Condition) -
Method in class org.jooq.impl.Factory
- Update one record in a table
UPDATE [table] SET [modified values in record] WHERE [condition]
- exists(Select<?>) -
Static method in class org.jooq.impl.Factory
- Create a not exists condition.
- exp() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- exp(Number) -
Static method in class org.jooq.impl.Factory
- Get the exp(field) function, taking this field as the power of e
- exp(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the exp(field) function, taking this field as the power of e
This renders the same on all dialects:
exp([field])
- exportXML() -
Method in interface org.jooq.Result
- Get this result as XML
- extract(DatePart) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- extract(Date, DatePart) -
Static method in class org.jooq.impl.Factory
- Get the extract(field, datePart) function
This translates into any dialect
- extract(Field<? extends Date>, DatePart) -
Static method in class org.jooq.impl.Factory
- Get the extract(field, datePart) function
This translates into any dialect
FactoryCondition that will always evaluate to false
ResultSet and transform it to a jOOQ
Result.
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
ResultSet and transform it to a jOOQ
Result.
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
InsertReturningStep
This currently only works well for DB2, HSQLDB, MySQL, and Postgres
Query.execute() and then
ResultQuery.getResult()
SELECT * FROM [table] LIMIT 1
SELECT * FROM [table] LIMIT 1
query.fetchArray()[recordIndex][fieldIndex]
Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet.
Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet.
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
String sql = "sp_help 'my_table'";
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Map with one of the result's
columns as key and the corresponding records as value.
Map with one of the result's
columns as key and another one of the result's columns as value
An exception is thrown, if the key turns out to be non-unique in the
result set.
Cursor, after the last
Record was fetched.
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
InsertReturningStep
query.fetchOneArray()[fieldIndex]
Cursor, after the last
Record was fetched.
QueryPart) that holds a list of
Fields.first_value(field) over ([analytic clause]) function.
Types.FLOAT type
floor([this])
... or simulates it elsewhere using round:
round([this] - 0.499999999999999)
ForeignKey is an object referencing a UniqueKey.FOR SHARE clause to the end of the query.
FOR SHARE clause to the end of the query.
FOR UPDATE clause to the end of the query.
FOR UPDATE clause to the end of the query.
FROM clause to the query
FROM clause to the query
FROM clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
FROM clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
FULL OUTER JOIN a table to the last
table added to the FROM clause using
Table.fullOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
FULL OUTER JOIN a tableto the last
table added to the FROM clause using
Table.fullOuterJoin(String, Object...)
FULL OUTER JOIN a table to this table.
FULL OUTER JOIN a table to this table.
FULL OUTER JOIN a table to this table.
function() can be used to access native functions that are
not yet or insufficiently supported by jOOQ
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
function() can be used to access native functions that are
not yet or insufficiently supported by jOOQ
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Attachables
This method is for JOOQ INTERNAL USE only.
Attachables
This method is for JOOQ INTERNAL USE only.
Attachables
This method is for JOOQ INTERNAL USE only.
QueryPart
This method is exposed publicly in Query.getBindValues()
Factory's underlying
SQLDialect and a given Java type.
SQLDialect
QueryPart
should no longer be referenced, as query parts become more
and more Configuration - independent
IDENTITY column.
KEY
KEY
IDENTITY information, if available.
Key
List
Query, provided its name.
QueryPart
This method is exposed publicly in Query.getParam(String)
Map of named parameters.
QueryPart
This method is exposed publicly in Query.getParams()
Query that is being constructed.
Query that is being constructed.
Record
Record
Record
FOREIGN KEY's of this table
ForeignKeys, referencing this
UniqueKey
FOREIGN KEY's of a specific table, referencing
a this table.
FOREIGN KEY's of this table, referencing a
specific table.
InsertQuery.setReturning() methods.
InsertQuery.setReturning() methods.
null if no such sequence exists
Factory.
QueryPart
This method is exposed publicly in Query.getSQL()
Types value
IDENTITY's owner table
Key's owner table
null if no such table exists
null if no such UDT exists
ArrayRecord
field.
ArrayRecord
field.
this >= value
this >= field
this >= (SelectgreaterOrEqualAll(Select<?>) -
Method in interface org.jooq.Field
this >= all (SelectgreaterOrEqualAll(T...) -
Method in interface org.jooq.Field
this >= all (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterOrEqualAll(Field<T[]>) -
Method in interface org.jooq.Field
this >= all (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterOrEqualAny(Select<?>) -
Method in interface org.jooq.Field
this >= any (SelectgreaterOrEqualAny(T...) -
Method in interface org.jooq.Field
this >= any (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterOrEqualAny(Field<T[]>) -
Method in interface org.jooq.Field
this >= any (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterOrEqualSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.greaterOrEqualAny(Select) instead
- greaterThan(T) -
Method in interface org.jooq.Field
this > value
- greaterThan(Field<T>) -
Method in interface org.jooq.Field
this > field
- greaterThan(Select<?>) -
Method in interface org.jooq.Field
this > (SelectgreaterThanAll(Select<?>) -
Method in interface org.jooq.Field
this > all (SelectgreaterThanAll(T...) -
Method in interface org.jooq.Field
this > all (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterThanAll(Field<T[]>) -
Method in interface org.jooq.Field
this > all (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterThanAny(Select<?>) -
Method in interface org.jooq.Field
this > any (SelectgreaterThanAny(T...) -
Method in interface org.jooq.Field
this > any (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterThanAny(Field<T[]>) -
Method in interface org.jooq.Field
this > any (array)
This is natively supported by SQLDialect.POSTGRES.
- greaterThanSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.greaterThanAny(Select) instead
- greatest(T...) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- greatest(Field<?>...) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- greatest(T, T...) -
Static method in class org.jooq.impl.Factory
- Find the greatest among all values
This function has no equivalent in Adaptive Server, Derby, SQL Server and
Sybase SQL Anywhere.
- greatest(Field<T>, Field<?>...) -
Static method in class org.jooq.impl.Factory
- Find the greatest among all values
This function has no equivalent in Adaptive Server, Derby, SQL Server and
Sybase SQL Anywhere.
- groupBy(Field<?>...) -
Method in interface org.jooq.SelectGroupByStep
- Add a
GROUP BY clause to the query
- groupBy(Collection<? extends Field<?>>) -
Method in interface org.jooq.SelectGroupByStep
- Add a
GROUP BY clause to the query
- grouping(Field<?>) -
Static method in class org.jooq.impl.Factory
- Create a GROUPING(field) aggregation field to be used along with
CUBE, ROLLUP, and GROUPING SETS
groupings
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
- groupingId(Field<?>...) -
Static method in class org.jooq.impl.Factory
- Create a GROUPING_ID(field1, field2, .., fieldn) aggregation field to be
used along with
CUBE, ROLLUP, and
GROUPING SETS groupings
This has been observed to work with the following databases:
Oracle
SQL Server
- groupingSets(Field<?>...) -
Static method in class org.jooq.impl.Factory
- Create a GROUPING SETS(field1, field2, .., fieldn) grouping field where
each grouping set only consists of a single field.
- groupingSets(Field<?>[]...) -
Static method in class org.jooq.impl.Factory
- Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE, ROLLUP, and GROUPING SETS
clauses in grouping contexts: http://msdn.microsoft.com/en-US/library/bb522495.aspx
- groupingSets(Collection<Field<?>>...) -
Static method in class org.jooq.impl.Factory
- Create a GROUPING SETS((field1a, field1b), (field2a), .., (fieldna,
fieldnb)) grouping field
This has been observed to work with the following databases:
DB2
Oracle
SQL Server
Sybase SQL Anywhere
Please check the SQL Server documentation for a very nice explanation of
CUBE, ROLLUP, and GROUPING SETS
clauses in grouping contexts: http://msdn.microsoft.com/en-US/library/bb522495.aspx
SQLDialect.H2 dialectSQLDialect.H2 specific factoryCursor, after the last
Record was fetched.
HAVING clause to the query
HAVING clause to the query
HAVING clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
HAVING clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
Factory create = new Factory();
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.execute();
SQLDialect.HSQLDB dialectSQLDialect.HSQLDB specific factoryIdentity is an object representing an IDENTITY
column as understood by the SQL:2003 standard.IGNORE NULLS clause to the window function.
this in (values...)
- in(T...) -
Method in interface org.jooq.Field
- Create a condition to check this field against several values
SQL:
this in (values...)
- in(Field<?>...) -
Method in interface org.jooq.Field
- Create a condition to check this field against several values
SQL:
this in (values...)
- in(Select<?>) -
Method in interface org.jooq.Field
- Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
- in(T...) -
Method in interface org.jooq.PivotInStep
- Specify the acceptable values for pivoting
- in(Field<?>...) -
Method in interface org.jooq.PivotInStep
- Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE.
- in(Collection<? extends Field<T>>) -
Method in interface org.jooq.PivotInStep
- Specify the acceptable values for pivoting
This clause is generally only supported by
SQLDialect.ORACLE.
- info(Object) -
Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object) -
Method in class org.jooq.tools.JooqLogger
-
- info(Object, Throwable) -
Method in class org.jooq.tools.JooqLogger
-
- info(Object, Object, Throwable) -
Method in class org.jooq.tools.JooqLogger
-
- IngresDataType<T> - Class in org.jooq.util.ingres
- Supported data types for the
SQLDialect.INGRES dialect - INGRESDATE -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- IngresFactory - Class in org.jooq.util.ingres
- A
SQLDialect.INGRES specific factory - IngresFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.ingres.IngresFactory
- Create a factory with connection and a schema mapping configured
- IngresFactory(Connection) -
Constructor for class org.jooq.util.ingres.IngresFactory
- Create a factory with connection
- INITIAL_READ_SIZE -
Static variable in class org.jooq.tools.csv.CSVParser
-
- inline() -
Method in interface org.jooq.RenderContext
- Whether bind variables should be inlined, rather than rendered as
'?'
- inline(boolean) -
Method in interface org.jooq.RenderContext
- Set the new context value for
RenderContext.inline()
- Insert<R extends Record> - Interface in org.jooq
- A
Query that can insert data in the database. - InsertFinalStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - insertInto(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) -
Method in interface org.jooq.FactoryOperations
- Deprecated. - 2.0.3 - Use any of these methods instead:
- insertInto(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new DSL insert statement.
- insertInto(Table<R>, Field<?>...) -
Method in class org.jooq.impl.Factory
- Create a new DSL insert statement.
- insertInto(Table<R>, Collection<? extends Field<?>>) -
Method in class org.jooq.impl.Factory
- Create a new DSL insert statement.
- insertInto(Table<R>, Select<?>) -
Method in class org.jooq.impl.Factory
- Deprecated.
- InsertOnDuplicateSetMoreStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertOnDuplicateSetStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertOnDuplicateStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - insertQuery(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
InsertQuery
- insertQuery(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
InsertQuery
- InsertQuery<R extends Record> - Interface in org.jooq
- A query for data insertion
- InsertResultStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertReturningStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertSetMoreStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's alternative DSL API. - InsertSetStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's alternative DSL API. - InsertValuesStep<R extends Record> - Interface in org.jooq
- This type is used for the
Insert's DSL API. - INT -
Static variable in class org.jooq.util.ase.ASEDataType
-
- INT -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- INT -
Static variable in class org.jooq.util.h2.H2DataType
-
- INT -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INT -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INT -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- INT -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- INT -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INT2 -
Static variable in class org.jooq.util.h2.H2DataType
-
- INT2 -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT2 -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INT4 -
Static variable in class org.jooq.util.h2.H2DataType
-
- INT4 -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT8 -
Static variable in class org.jooq.util.h2.H2DataType
-
- INT8 -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INT8 -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.INTEGER type
- INTEGER -
Static variable in class org.jooq.util.ase.ASEDataType
-
- INTEGER -
Static variable in class org.jooq.util.db2.DB2DataType
-
- INTEGER -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- INTEGER -
Static variable in class org.jooq.util.h2.H2DataType
-
- INTEGER -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- INTEGER -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- INTEGER -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- INTEGER -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- INTEGER -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- INTEGER -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- INTEGER1 -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER2 -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER4 -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGER8 -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- INTEGERUNSIGNED -
Static variable in class org.jooq.impl.SQLDataType
- The unsigned
Types.INTEGER type
- INTEGERUNSIGNED -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- internalAPI(Class<I>) -
Method in interface org.jooq.Adapter
- Adapt to an internal type assuming its functionality
This is for JOOQ INTERNAL USE only.
- intersect(Select<R>) -
Method in interface org.jooq.Select
- Combine with other selects
- into(Class<? extends E>) -
Method in interface org.jooq.Record
- Map resulting records onto a custom type.
- into(Table<R>) -
Method in interface org.jooq.Record
- Map resulting records onto a custom record type.
- into(Class<? extends E>) -
Method in interface org.jooq.Result
- Map resulting records onto a custom type.
- into(Table<Z>) -
Method in interface org.jooq.Result
- Map resulting records onto a custom record.
- into(H) -
Method in interface org.jooq.Result
- Map results into a custom handler callback
- intoArray() -
Method in interface org.jooq.Record
- Convert this record into an array.
- intoArray() -
Method in interface org.jooq.Result
- Convert this result into an array of arrays
The resulting array has the same number of first-dimension elements as this result has records.
- INTUNSIGNED -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- intValue() -
Method in class org.jooq.tools.unsigned.UByte
-
- intValue() -
Method in class org.jooq.tools.unsigned.UInteger
-
- intValue() -
Method in class org.jooq.tools.unsigned.ULong
-
- intValue() -
Method in class org.jooq.tools.unsigned.UShort
-
- InvalidResultException - Exception in org.jooq.exception
- An unexpected result was encountered after executing a
Query. - InvalidResultException(String) -
Constructor for exception org.jooq.exception.InvalidResultException
- Constructor for InvalidResultException.
- isAllWhiteSpace(CharSequence) -
Method in class org.jooq.tools.csv.CSVParser
- precondition: sb.length() > 0
- isBinary() -
Method in interface org.jooq.DataType
- Whether this data type is any binary type.
- isBinary() -
Method in class org.jooq.impl.AbstractDataType
-
- isBlank(String) -
Static method in class org.jooq.tools.StringUtils
-
Checks if a String is whitespace, empty ("") or null.
- isClosed() -
Method in interface org.jooq.Cursor
- Check whether this
Cursor has been explicitly or
"conveniently" closed.
- isDebugEnabled() -
Method in class org.jooq.tools.JooqLogger
-
- isEmpty() -
Method in interface org.jooq.Result
- Whether there are any records contained in this
Result
- isEmpty(String) -
Static method in class org.jooq.tools.StringUtils
-
Checks if a String is empty ("") or null.
- isFalse() -
Method in interface org.jooq.Field
- Create a condition to check this field against known string literals for
false
SQL:
lcase(this) in ("0", "n", "no", "false", "off", "disabled")
- isInfoEnabled() -
Method in class org.jooq.tools.JooqLogger
-
- isNextCharacterEscapable(String, boolean, int) -
Method in class org.jooq.tools.csv.CSVParser
- precondition: the current character is an escape
- isNotNull() -
Method in interface org.jooq.Field
- Create a condition to check this field against
null.
- isNull() -
Method in interface org.jooq.Field
- Create a condition to check this field against
null.
- isNullLiteral() -
Method in interface org.jooq.Field
- Whether this field represents a
null literal.
- isNullLiteral() -
Method in class org.jooq.impl.CustomField
- Subclasses may further override this method
Whether this field represents a null literal.
- isNumeric() -
Method in interface org.jooq.DataType
- Whether this data type is any numeric data type.
- isNumeric() -
Method in class org.jooq.impl.AbstractDataType
-
- isOverloaded() -
Method in class org.jooq.impl.AbstractRoutine
-
- isPending() -
Method in class org.jooq.tools.csv.CSVParser
-
- isString() -
Method in interface org.jooq.DataType
- Whether this data type is any character data type.
- isString() -
Method in class org.jooq.impl.AbstractDataType
-
- isTemporal() -
Method in interface org.jooq.DataType
- Whether this data type is any date or time type.
- isTemporal() -
Method in class org.jooq.impl.AbstractDataType
-
- isTraceEnabled() -
Method in class org.jooq.tools.JooqLogger
-
- isTrue() -
Method in interface org.jooq.Field
- Create a condition to check this field against known string literals for
true
SQL:
lcase(this) in ("1", "y", "yes", "true", "on", "enabled")
- iterator() -
Method in class org.jooq.impl.ArrayRecordImpl
-
INNER JOIN a table to the last table
added to the FROM clause using Table.join(TableLike)
INNER JOIN a table to the last table
added to the FROM clause using Table.join(String)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
INNER JOIN a table to the last table
added to the FROM clause using
Table.join(String, Object...)
INNER JOIN a table to this table.
INNER JOIN a table to this table.
INNER JOIN a table to this table.
Key is an object representing a UNIQUE KEY, a
PRIMARY KEY, or a FOREIGN KEY.lag(field) over ([analytic clause]) function.
lag(field, offset) over ([analytic clause]) function.
lag(field, offset, defaultValue) over ([analytic clause])
function.
lag(field, offset, defaultValue) over ([analytic clause])
function.
last_value(field) over ([analytic clause]) function.
lead(field) over ([analytic clause]) function.
lead(field, offset) over ([analytic clause]) function.
lead(field, offset, defaultValue) over ([analytic clause])
function.
lead(field, offset, defaultValue) over ([analytic clause])
function.
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(TableLike)
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
LEFT OUTER JOIN a table to the last
table added to the FROM clause using
Table.leftOuterJoin(String, Object...)
LEFT OUTER JOIN a table to this table.
LEFT OUTER JOIN a table to this table.
LEFT OUTER JOIN a table to this table.
VARCHAR type.
VARCHAR type.
this <= value
this <= field
this <= (SelectlessOrEqualAll(Select<?>) -
Method in interface org.jooq.Field
this <= all (SelectlessOrEqualAll(T...) -
Method in interface org.jooq.Field
this <= all (array)
This is natively supported by SQLDialect.POSTGRES.
- lessOrEqualAll(Field<T[]>) -
Method in interface org.jooq.Field
this <= all (array)
This is natively supported by SQLDialect.POSTGRES.
- lessOrEqualAny(Select<?>) -
Method in interface org.jooq.Field
this <= any (SelectlessOrEqualAny(T...) -
Method in interface org.jooq.Field
this <= any (array)
This is natively supported by SQLDialect.POSTGRES.
- lessOrEqualAny(Field<T[]>) -
Method in interface org.jooq.Field
this <= any (array)
This is natively supported by SQLDialect.POSTGRES.
- lessOrEqualSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.lessOrEqualAny(Select) instead
- lessThan(T) -
Method in interface org.jooq.Field
this < value
- lessThan(Field<T>) -
Method in interface org.jooq.Field
this < field
- lessThan(Select<?>) -
Method in interface org.jooq.Field
this < (SelectlessThanAll(Select<?>) -
Method in interface org.jooq.Field
this < all (SelectlessThanAll(T...) -
Method in interface org.jooq.Field
this < all (array)
This is natively supported by SQLDialect.POSTGRES.
- lessThanAll(Field<T[]>) -
Method in interface org.jooq.Field
this < all (array)
This is natively supported by SQLDialect.POSTGRES.
- lessThanAny(Select<?>) -
Method in interface org.jooq.Field
this < any (SelectlessThanAny(T...) -
Method in interface org.jooq.Field
this < any (array)
This is natively supported by SQLDialect.POSTGRES.
- lessThanAny(Field<T[]>) -
Method in interface org.jooq.Field
this < any (array)
This is natively supported by SQLDialect.POSTGRES.
- lessThanSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.lessThanAny(Select) instead
- level() -
Static method in class org.jooq.util.oracle.OracleFactory
- Retrieve the Oracle-specific
LEVEL pseudo-field (to be used
along with CONNECT BY clauses)
- like(Field<T>) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this like value
- like(Field<T>, char) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this like value escape 'e'
- like(T) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this like value
- like(T, char) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this like value escape 'e'
- limit(int) -
Method in interface org.jooq.SelectLimitStep
- Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, this is simulated with a ROW_NUMBER() window function
and nested SELECT statements.
- limit(int, int) -
Method in interface org.jooq.SelectLimitStep
- Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, or if your RDBMS does not natively support offsets, this is
simulated with a ROW_NUMBER() window function and nested
SELECT statements.
- limit(int) -
Method in interface org.jooq.SimpleSelectLimitStep
- Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, this is simulated with a ROW_NUMBER() window function
and nested SELECT statements.
- limit(int, int) -
Method in interface org.jooq.SimpleSelectLimitStep
- Add a
LIMIT clause to the query
If there is no LIMIT or TOP clause in your
RDBMS, or if your RDBMS does not natively support offsets, this is
simulated with a ROW_NUMBER() window function and nested
SELECT statements.
- literal(T) -
Static method in class org.jooq.impl.Factory
- Get a typed
Field for a literal.
- literal(Object, Class<T>) -
Static method in class org.jooq.impl.Factory
- Get a typed
Field for a literal.
- literal(Object, DataType<T>) -
Static method in class org.jooq.impl.Factory
- Get a typed
Field for a literal.
- literal(String) -
Method in interface org.jooq.RenderContext
- Append some (quoted) literal to the context's contained
StringBuilder
- ln() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- ln(Number) -
Static method in class org.jooq.impl.Factory
- Get the ln(field) function, taking the natural logarithm of this field
- ln(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the ln(field) function, taking the natural logarithm of this field
This renders the ln or log function where available:
ln([field]) or
log([field])
- loadCSV(File) -
Method in interface org.jooq.LoaderSourceStep
- Load CSV data
- loadCSV(String) -
Method in interface org.jooq.LoaderSourceStep
- Load CSV data
- loadCSV(InputStream) -
Method in interface org.jooq.LoaderSourceStep
- Load CSV data
- loadCSV(Reader) -
Method in interface org.jooq.LoaderSourceStep
- Load CSV data
- Loader<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderCSVOptionsStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderCSVStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderError - Interface in org.jooq
- An error that occurred during loading.
- LoaderLoadStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderOptionsStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderSourceStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - LoaderXMLStep<R extends TableRecord<R>> - Interface in org.jooq
- The
Loader API is used for configuring data loads. - loadInto(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
Loader object to load data from a CSV or XML
source
- loadInto(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
Loader object to load data from a CSV or XML
source
- loadXML(File) -
Method in interface org.jooq.LoaderSourceStep
- Load XML data
- loadXML(String) -
Method in interface org.jooq.LoaderSourceStep
- Load XML data
- loadXML(InputStream) -
Method in interface org.jooq.LoaderSourceStep
- Load XML data
- loadXML(Reader) -
Method in interface org.jooq.LoaderSourceStep
- Load XML data
- loadXML(InputSource) -
Method in interface org.jooq.LoaderSourceStep
- Load XML data
- LockProvider - Interface in org.jooq
- A query part (mostly a
Select statement) providing the possibility of
locking tables, rows using a FOR UPDATE clause - log(int) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- log(Number, int) -
Static method in class org.jooq.impl.Factory
- Get the log(field, base) function
- log(Field<? extends Number>, int) -
Static method in class org.jooq.impl.Factory
- Get the log(field, base) function
This renders the log function where available:
log([field]) ... or simulates it elsewhere (in
most RDBMS) using the natural logarithm:
ln([field]) / ln([base])
- LONG -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- LONGBINARY -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- LONGBLOB -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGBLOB -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- LONGBYTE -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- LONGNVARCHAR -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.LONGNVARCHAR type
- LONGNVARCHAR -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- LONGNVARCHAR -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- LONGRAW -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- LONGSYSNAME -
Static variable in class org.jooq.util.ase.ASEDataType
-
- LONGTEXT -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGTEXT -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- longValue() -
Method in class org.jooq.tools.unsigned.UByte
-
- longValue() -
Method in class org.jooq.tools.unsigned.UInteger
-
- longValue() -
Method in class org.jooq.tools.unsigned.ULong
-
- longValue() -
Method in class org.jooq.tools.unsigned.UShort
-
- LONGVARBINARY -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.LONGVARBINARY type
- LONGVARBINARY -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGVARBINARY -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- LONGVARBINARY -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- LONGVARBIT -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.LONGVARCHAR type
- LONGVARCHAR -
Static variable in class org.jooq.util.ase.ASEDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.db2.DB2DataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- LONGVARCHAR -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- LONGVARCHARFORBITDATA -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- lower() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- lower(String) -
Static method in class org.jooq.impl.Factory
- Get the lower(field) function
- lower(Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the lower(field) function
This renders the lower function in all dialects:
lower([field])
- lpad(Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- lpad(int) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- lpad(Field<? extends Number>, Field<String>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- lpad(int, char) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- lpad(Field<String>, int) -
Static method in class org.jooq.impl.Factory
- Get the lpad(field, length) function
- lpad(Field<String>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the lpad(field, length) function
This renders the lpad function where available:
lpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat(repeat(' ', [length] - length([field])), [field])
- lpad(Field<String>, int, char) -
Static method in class org.jooq.impl.Factory
- Get the lpad(field, length, character) function
- lpad(Field<String>, int, String) -
Static method in class org.jooq.impl.Factory
- Get the lpad(field, length, character) function
- lpad(Field<String>, Field<? extends Number>, Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the lpad(field, length, character) function
This renders the lpad function where available:
lpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat(repeat([character], [length] - length([field])), [field])
- ltrim() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- ltrim(String) -
Static method in class org.jooq.impl.Factory
- Get the ltrim(field) function
- ltrim(Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the ltrim(field) function
This renders the ltrim function in all dialects:
ltrim([field])
ResultQuery.fetchInto(Class)
Cursor.fetchInto(Class)
Result.into(Class)
Record.into(Class)
... or when copying data into a Record with any of these methods
FactoryOperations.newRecord(org.jooq.Table, Object)
Record.from(Object)
unsigned byte can
have, 28-1.
unsigned int can
have, 232-1.
unsigned long can
have, 264-1.
unsigned short can
have, 216-1.
signed long can
have, 263.
MD5() function
MD5() function
Query that can merge data in the database.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.Merge's DSL API.unsigned byte can
have, 0.
unsigned int can
have, 0.
unsigned long can
have, 0.
unsigned short can
have, 0.
[this] % [value]
... or the modulo function elsewhere:
mod([this], [value])
[this] % [value]
... or the modulo function elsewhere:
mod([this], [value])
SQLDialect.MYSQL dialectSQLDialect.MYSQL specific factory :1, :2, :custom_name
or as JDBC bind variables ?
- namedParams(boolean) -
Method in interface org.jooq.RenderContext
- Set the new context value for
RenderContext.namedParams()
- NamedQueryPart - Interface in org.jooq
- A common interface for query parts that have a name.
- NamedTypeProviderQueryPart<T> - Interface in org.jooq
- Any object providing a type.
- NATIONALCHARACTERLARGEOBJECT -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NATIVECHARACTER -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NATURAL -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- naturalJoin(TableLike<?>) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(TableLike)
Natural joins are supported by most RDBMS.
- naturalJoin(String) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String)
Natural joins are supported by most RDBMS.
- naturalJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL JOIN a table to the last table
added to the FROM clause using
Table.naturalJoin(String, Object...)
- naturalJoin(TableLike<?>) -
Method in interface org.jooq.Table
NATURAL JOIN a table to this table.
- naturalJoin(String) -
Method in interface org.jooq.Table
NATURAL JOIN a table to this table.
- naturalJoin(String, Object...) -
Method in interface org.jooq.Table
NATURAL JOIN a table to this table.
- naturalLeftOuterJoin(TableLike<?>) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(TableLike)
Natural joins are supported by most RDBMS.
- naturalLeftOuterJoin(String) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String)
Natural joins are supported by most RDBMS.
- naturalLeftOuterJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL LEFT OUTER JOIN a table to the
last table added to the FROM clause using
Table.naturalLeftOuterJoin(String, Object...)
- naturalLeftOuterJoin(TableLike<?>) -
Method in interface org.jooq.Table
NATURAL LEFT OUTER JOIN a table to this table.
- naturalLeftOuterJoin(String) -
Method in interface org.jooq.Table
NATURAL LEFT OUTER JOIN a table to this table.
- naturalLeftOuterJoin(String, Object...) -
Method in interface org.jooq.Table
NATURAL LEFT OUTER JOIN a table to this table.
- NATURALN -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- naturalRightOuterJoin(TableLike<?>) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(TableLike)
Natural joins are supported by most RDBMS.
- naturalRightOuterJoin(String) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String)
Natural joins are supported by most RDBMS.
- naturalRightOuterJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
- Convenience method to
NATURAL RIGHT OUTER JOIN a table to
the last table added to the FROM clause using
Table.naturalRightOuterJoin(String, Object...)
- naturalRightOuterJoin(TableLike<?>) -
Method in interface org.jooq.Table
NATURAL RIGHT OUTER JOIN a table to this table.
- naturalRightOuterJoin(String) -
Method in interface org.jooq.Table
NATURAL RIGHT OUTER JOIN a table to this table.
- naturalRightOuterJoin(String, Object...) -
Method in interface org.jooq.Table
NATURAL RIGHT OUTER JOIN a table to this table.
- NCHAR -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.NCHAR type
- NCHAR -
Static variable in class org.jooq.util.ase.ASEDataType
-
- NCHAR -
Static variable in class org.jooq.util.h2.H2DataType
-
- NCHAR -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCHAR -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- NCHAR -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NCHAR -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NCHAR -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NCHARLARGEOBJECT -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCLOB -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.NCLOB type
- NCLOB -
Static variable in class org.jooq.util.h2.H2DataType
-
- NCLOB -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NCLOB -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- neg() -
Method in interface org.jooq.Field
- Negate this field to get its negative value.
- newRecord(UDT<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new attached
UDTRecord.
- newRecord(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
Record that can be inserted into the corresponding
table.
- newRecord(Table<R>, Object) -
Method in interface org.jooq.FactoryOperations
- Create a new pre-filled
Record that can be inserted into the
corresponding table.
- newRecord(UDT<R>) -
Method in class org.jooq.impl.Factory
- Create a new attached
UDTRecord.
- newRecord(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
Record that can be inserted into the corresponding
table.
- newRecord(Table<R>, Object) -
Method in class org.jooq.impl.Factory
- Create a new pre-filled
Record that can be inserted into the
corresponding table.
- newRecord() -
Method in interface org.jooq.InsertQuery
- Adds a new Record to the insert statement for multi-record inserts
Calling this method will cause subsequent calls to
StoreQuery.addValue(Field, Object) (and similar) to fill the next record.
- newRecord() -
Method in interface org.jooq.InsertSetMoreStep
- Add an additional record to the
INSERT statement
- next(R) -
Method in interface org.jooq.RecordHandler
- A callback method indicating that the next record has been fetched.
- nextAlias() -
Method in interface org.jooq.RenderContext
- Return a new alias that is unique for the scope of one query.
- nextIndex() -
Method in interface org.jooq.Context
- Get the next bind index.
- nextval(Sequence<T>) -
Method in interface org.jooq.FactoryOperations
- Convenience method to fetch the NEXTVAL for a sequence directly from this
Factory's underlying JDBC Connection
- nextval(Sequence<T>) -
Method in class org.jooq.impl.Factory
- Convenience method to fetch the NEXTVAL for a sequence directly from this
Factory's underlying JDBC Connection
- nextval() -
Method in class org.jooq.impl.SequenceImpl
-
- nextval() -
Method in interface org.jooq.Sequence
- Increment the sequence and get the next value
- NO_MAPPING -
Static variable in class org.jooq.SchemaMapping
- The default, unmodifiable mapping that just takes generated schemata
- normalise(String) -
Static method in class org.jooq.impl.FieldTypeHelper
-
- not() -
Method in interface org.jooq.Condition
- Invert this condition
- notBetween(T, T) -
Method in interface org.jooq.Field
- Create a condition to check this field against some bounds
SQL:
this not between minValue and maxValue
- notBetween(Field<T>, Field<T>) -
Method in interface org.jooq.Field
- Create a condition to check this field against some bounds
SQL:
this not between minValue and maxValue
- notEqual(T) -
Method in interface org.jooq.Field
this !
- notEqual(Field<T>) -
Method in interface org.jooq.Field
this !
- notEqual(Select<?>) -
Method in interface org.jooq.Field
this !
- notEqualAll(Select<?>) -
Method in interface org.jooq.Field
this !
- notEqualAll(T...) -
Method in interface org.jooq.Field
this !
- notEqualAll(Field<T[]>) -
Method in interface org.jooq.Field
this !
- notEqualAny(Select<?>) -
Method in interface org.jooq.Field
this !
- notEqualAny(T...) -
Method in interface org.jooq.Field
this !
- notEqualAny(Field<T[]>) -
Method in interface org.jooq.Field
this !
- notEqualSome(Select<?>) -
Method in interface org.jooq.Field
- Deprecated. - 2.0.2 - Use
Field.notEqualAny(Select) instead
- notExists(Select<?>) -
Static method in class org.jooq.impl.Factory
- Create a not exists condition.
- notIn(Collection<T>) -
Method in interface org.jooq.Field
- Create a condition to check this field against several values
Note that if any of the passed values is
NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(T...) -
Method in interface org.jooq.Field
- Create a condition to check this field against several values
Note that if any of the passed values is
NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(Field<?>...) -
Method in interface org.jooq.Field
- Create a condition to check this field against several values
Note that if any of the passed values is
NULL, then the
condition will be NULL (or false, depending on
the dialect) as well.
- notIn(Select<?>) -
Method in interface org.jooq.Field
- Create a condition to check this field against a subquery
Note that the subquery must return exactly one field.
- notLike(Field<T>) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this not like value
- notLike(Field<T>, char) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this not like value escape 'e'
- notLike(T) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this not like value
- notLike(T, char) -
Method in interface org.jooq.Field
- Create a condition to pattern-check this field against a value
SQL:
this not like value escape 'e'
- noWait() -
Method in interface org.jooq.SelectForUpdateWaitStep
- Add a
WAIT clause to the FOR UPDATE clause at
the end of the query.
- noWait() -
Method in interface org.jooq.SimpleSelectForUpdateWaitStep
- Add a
WAIT clause to the FOR UPDATE clause at
the end of the query.
- NTEXT -
Static variable in class org.jooq.util.h2.H2DataType
-
- NTEXT -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NTEXT -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- ntile(int) -
Static method in class org.jooq.impl.Factory
- The
ntile([number]) over ([analytic clause]) function.
- NULL -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NULL_CHARACTER -
Static variable in class org.jooq.tools.csv.CSVParser
- This is the "null" character - if a value is set to this then it is
ignored.
- nullif(T) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nullif(Field<T>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nullif(T, T) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NULLIF(value, other) function
- nullif(T, Field<T>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NULLIF(value, other) function
- nullif(Field<T>, T) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NULLIF(value, other) function
- nullif(Field<T>, Field<T>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NULLIF(value, other) function
Returns the dialect's equivalent to NULLIF:
Oracle NULLIF
- nullsFirst() -
Method in interface org.jooq.SortField
- Add a
NULLS FIRST clause to this sort field
- nullsLast() -
Method in interface org.jooq.SortField
- Add a
NULLS LAST clause to this sort field
- NUMBER -
Static variable in class org.jooq.util.h2.H2DataType
-
- NUMBER -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- NUMERIC -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.NUMERIC type
- NUMERIC -
Static variable in class org.jooq.util.ase.ASEDataType
-
- NUMERIC -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- NUMERIC -
Static variable in class org.jooq.util.h2.H2DataType
-
- NUMERIC -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- NUMERIC -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NUMERIC -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- NUMERIC -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- NUMERIC -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NUMERIC -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NUMERIC -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NVARCHAR -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.NVARCHAR type
- NVARCHAR -
Static variable in class org.jooq.util.ase.ASEDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.h2.H2DataType
-
- NVARCHAR -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- NVARCHAR2 -
Static variable in class org.jooq.util.h2.H2DataType
-
- NVARCHAR2 -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- nvl(T) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nvl(Field<T>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nvl(T, T) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL(value, defaultValue) function
- nvl(T, Field<T>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL(value, defaultValue) function
- nvl(Field<T>, T) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL(value, defaultValue) function
- nvl(Field<T>, Field<T>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL(value, defaultValue) function
Returns the dialect's equivalent to NVL:
DB2 nvl2(Z, Z) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nvl2(Field<Z>, Field<Z>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- nvl2(Field<?>, Z, Z) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Z, Field<Z>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Field<Z>, Z) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<?>, Field<Z>, Field<Z>) -
Static method in class org.jooq.impl.Factory
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
Returns the dialect's equivalent to NVL2:
Oracle NVL2
Other dialects:
CASE WHEN [value] IS NULL THEN [valueIfNull] ELSE [valueIfNotNull] END
OF clause to the FOR UPDATE clause at
the end of the query.
OF clause to the FOR UPDATE clause at
the end of the query.
OF clause to the FOR UPDATE clause at
the end of the query.
OF clause to the FOR UPDATE clause at
the end of the query.
OF clause to the FOR UPDATE clause at
the end of the query.
OF clause to the FOR UPDATE clause at
the end of the query.
OFFSET clause to the query
If there is no LIMIT ..
- offset(int) -
Method in interface org.jooq.SimpleSelectOffsetStep
- Add an
OFFSET clause to the query
If there is no LIMIT ..
- OID -
Static variable in class org.jooq.util.h2.H2DataType
-
- OID -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- OIDVECTOR -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- on(Condition...) -
Method in interface org.jooq.MergeOnStep
- Provide join conditions and proceed to the next step
- on(String) -
Method in interface org.jooq.MergeOnStep
- Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) -
Method in interface org.jooq.MergeOnStep
- Provide join conditions and proceed to the next step
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(Field<T>) -
Method in interface org.jooq.PivotForStep
- Add a list of fields to the
PIVOT clause.
- on(Condition...) -
Method in interface org.jooq.SelectOnStep
- Add an
ON clause to the previous JOIN
- on(String) -
Method in interface org.jooq.SelectOnStep
- Add an
ON clause to the previous JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) -
Method in interface org.jooq.SelectOnStep
- Add an
ON clause to the previous JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(Condition...) -
Method in interface org.jooq.TableOnStep
- Add an
ON clause to the JOIN
- on(String) -
Method in interface org.jooq.TableOnStep
- Add an
ON clause to the JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- on(String, Object...) -
Method in interface org.jooq.TableOnStep
- Add an
ON clause to the JOIN
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- onDuplicateKeyError() -
Method in interface org.jooq.LoaderOptionsStep
- Instruct the
Loader to cause an error in loading if there
are any duplicate records.
- onDuplicateKeyIgnore() -
Method in interface org.jooq.LoaderOptionsStep
- Instruct the
Loader to skip duplicate records if the main
unique key's value is already in the database.
- onDuplicateKeyUpdate() -
Method in interface org.jooq.InsertOnDuplicateStep
- Add an
ON DUPLICATE KEY UPDATE clause to this insert query.
- onDuplicateKeyUpdate(boolean) -
Method in interface org.jooq.InsertQuery
- Whether a
ON DUPLICATE KEY UPDATE clause should be added to
this INSERT statement.
- onDuplicateKeyUpdate() -
Method in interface org.jooq.LoaderOptionsStep
- Instruct the
Loader to update duplicate records if the main
unique key's value is already in the database.
- one() -
Static method in class org.jooq.impl.Factory
- A
1 literal.
- onErrorAbort() -
Method in interface org.jooq.LoaderOptionsStep
- Instruct the
Loader to abort loading after the first error
that might occur when inserting a record.
- onErrorIgnore() -
Method in interface org.jooq.LoaderOptionsStep
- Instruct the
Loader to ignore any errors that might occur
when inserting a record.
- onKey() -
Method in interface org.jooq.SelectOnStep
- Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
- onKey(TableField<?, ?>...) -
Method in interface org.jooq.SelectOnStep
- Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
- onKey(ForeignKey<?, ?>) -
Method in interface org.jooq.SelectOnStep
- Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey() -
Method in interface org.jooq.TableOnStep
- Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey(TableField<?, ?>...) -
Method in interface org.jooq.TableOnStep
- Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- onKey(ForeignKey<?, ?>) -
Method in interface org.jooq.TableOnStep
- Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
- Operator - Enum in org.jooq
- An operator used for combining conditions
- or(Condition) -
Method in interface org.jooq.Condition
- Combine this condition with another one using the
Operator.OR
operator.
- or(String) -
Method in interface org.jooq.Condition
- Combine this condition with another one using the
Operator.OR
operator.
- or(String, Object...) -
Method in interface org.jooq.Condition
- Combine this condition with another one using the
Operator.OR
operator.
- or(Condition) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
- or(String) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, Object...) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(Condition) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(String, Object...) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
- or(Condition) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(String, Object...) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator.
- or(Condition) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
- or(String) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- or(String, Object...) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with another one using the
Operator.OR operator
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- OracleDataType<T> - Class in org.jooq.util.oracle
- Supported data types for the
SQLDialect.ORACLE dialect - OracleFactory - Class in org.jooq.util.oracle
- A
SQLDialect.ORACLE specific factory - OracleFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.oracle.OracleFactory
- Create a factory with connection and a schema mapping configured
- OracleFactory(Connection) -
Constructor for class org.jooq.util.oracle.OracleFactory
- Create a factory with connection
- OracleUtils - Class in org.jooq.util.oracle
- Utility methods for use with
SQLDialect.ORACLE
This class has a hidden dependency on the Oracle JDBC driver. - orderBy(Field<?>...) -
Method in interface org.jooq.SelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(SortField<?>...) -
Method in interface org.jooq.SelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(Collection<SortField<?>>) -
Method in interface org.jooq.SelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(int...) -
Method in interface org.jooq.SelectOrderByStep
- Add an
ORDER BY clause to the query
Indexes start at 1 in SQL!
- orderBy(Field<?>...) -
Method in interface org.jooq.SimpleSelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(SortField<?>...) -
Method in interface org.jooq.SimpleSelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(Collection<SortField<?>>) -
Method in interface org.jooq.SimpleSelectOrderByStep
- Add an
ORDER BY clause to the query
- orderBy(int...) -
Method in interface org.jooq.SimpleSelectOrderByStep
- Add an
ORDER BY clause to the query
Indexes start at 1 in SQL!
- orderBy(Field<?>...) -
Method in interface org.jooq.WindowOrderByStep
- Add an
ORDER BY clause to the window function.
- orderBy(SortField<?>...) -
Method in interface org.jooq.WindowOrderByStep
- Add an
ORDER BY clause to the window function.
- orderBy(Collection<SortField<?>>) -
Method in interface org.jooq.WindowOrderByStep
- Add an
ORDER BY clause to the window function.
- OrderProvider - Interface in org.jooq
- A query that can be ordered and limited
- orExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with an EXISTS clause using the
Operator.OR operator.
- orExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator
- orExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator.
- orExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with an EXISTS clause using
the
Operator.OR operator
- org.jooq - package org.jooq
-
- org.jooq.exception - package org.jooq.exception
-
- org.jooq.impl - package org.jooq.impl
-
- org.jooq.tools - package org.jooq.tools
-
- org.jooq.tools.csv - package org.jooq.tools.csv
-
- org.jooq.tools.json - package org.jooq.tools.json
-
- org.jooq.tools.unsigned - package org.jooq.tools.unsigned
-
- org.jooq.util.ase - package org.jooq.util.ase
-
- org.jooq.util.db2 - package org.jooq.util.db2
-
- org.jooq.util.derby - package org.jooq.util.derby
-
- org.jooq.util.h2 - package org.jooq.util.h2
-
- org.jooq.util.hsqldb - package org.jooq.util.hsqldb
-
- org.jooq.util.ingres - package org.jooq.util.ingres
-
- org.jooq.util.mysql - package org.jooq.util.mysql
-
- org.jooq.util.oracle - package org.jooq.util.oracle
-
- org.jooq.util.postgres - package org.jooq.util.postgres
-
- org.jooq.util.sqlite - package org.jooq.util.sqlite
-
- org.jooq.util.sqlserver - package org.jooq.util.sqlserver
-
- org.jooq.util.sybase - package org.jooq.util.sybase
-
- ORGAPACHEDERBYCATALOGINDEXDESCRIPTOR -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- ORGAPACHEDERBYCATALOGTYPEDESCRIPTOR -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- orNot(Condition) -
Method in interface org.jooq.Condition
- Combine this condition with a negated other one using the
Operator.OR operator.
- orNot(Condition) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator
- orNot(Condition) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator and proceed to the next step.
- orNot(Condition) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator.
- orNot(Condition) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator
- orNotExists(Select<?>) -
Method in interface org.jooq.Condition
- Combine this condition with a NOT EXIST clause using the
Operator.OR operator.
- orNotExists(Select<?>) -
Method in interface org.jooq.DeleteConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator
- orNotExists(Select<?>) -
Method in interface org.jooq.MergeOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) -
Method in interface org.jooq.SelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) -
Method in interface org.jooq.SelectHavingConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) -
Method in interface org.jooq.SelectOnConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) -
Method in interface org.jooq.SimpleSelectConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator and proceed to the next step.
- orNotExists(Select<?>) -
Method in interface org.jooq.TableOnConditionStep
- Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator.
- orNotExists(Select<?>) -
Method in interface org.jooq.UpdateConditionStep
- Combine the currently assembled conditions with a NOT EXISTS clause using
the
Operator.OR operator
- OTHER -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.OTHER type
- OTHER -
Static variable in class org.jooq.util.h2.H2DataType
-
- OTHER -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- otherwise(T) -
Method in interface org.jooq.CaseConditionStep
- Add an else clause to the already constructed case statement
- otherwise(Field<T>) -
Method in interface org.jooq.CaseConditionStep
- Add an else clause to the already constructed case statement
- otherwise(T) -
Method in interface org.jooq.CaseWhenStep
- Add an else clause to the already constructed case statement
- otherwise(Field<T>) -
Method in interface org.jooq.CaseWhenStep
- Add an else clause to the already constructed case statement
- over() -
Method in interface org.jooq.AggregateFunction
- Turn this aggregate function into a window function, for example
MAX(ID) OVER (PARTITION BY 1)
Window functions are supported in DB2, Postgres, Oracle, SQL Server and
Sybase.
- over() -
Method in interface org.jooq.WindowOverStep
- Add an
OVER clause
SQLDialect.ORACLE dialectSQLDialect.ORACLE dialect.Object /
SQLDataType.OTHER) and no initial value.
PARTITION BY clause to the window functions.
PARTITION BY 1 clause to the window functions, where
such a clause is required by the syntax of an RDBMS.
PASSWORD() function
PASSWORD() function
RenderContext.nextAlias()
precent_rank() over ([analytic clause]) function.
PI literal.
TABLE reference from this table, pivoting it
into another form
This has been observed to work with
SQLDialect.ORACLE
SQLDialect.SQLSERVER (not yet officially supported)
Other dialects by using some means of simulation (not yet officially
supported)
TABLE reference from this table, pivoting it
into another form
For more details, see Table.pivot(Field...)
PIVOT clause DSL API, pivoting
Table objects to new tables.PIVOT clause DSL API, pivoting
Table objects to new tables.position([search] in [in]) or
locate([in], [search]) or
locate([search], [in]) or
instr([in], [search]) or
charindex([search], [in])
SQLDialect.POSTGRES dialectSQLDialect.POSTGRES specific factorypower([field], [exponent]) ... or simulates it
elsewhere using ln and exp:
exp(ln([field]) * [exponent])
PRIOR unary operator before a field
(to be used along with CONNECT BY clauses)
Configuration to jOOQ, given a deserialised
Configuration.
ConfigurationProvider's
This method is used by jOOQ retrieve a client-provided
Configuration.
degrees([field]) ... or simulates it elsewhere:
[field] * PI / 180
rank_over() over ([analytic clause]) function.
Types.REAL type
SelectQueryRecordHandler is a handler that can receive Record
objects, when fetching data from the database.renderContext().render(part)
renderContext().render(part)
RenderContext for the context of this factory
This will return an initialised render context as such:
Context.declareFields() == falseContext.declareTables() == falseRenderContext.inline() == falseRenderContext.namedParams() == falseQueryPart's to SQL.repeat([field], [count]) or
replicate([field], [count]) ... or simulates it elsewhere
using rpad and length, which may be simulated as well, depending on the
RDBMS:
rpad([field], length([field]) * [count], [field])
replace([field], [search]) or
str_replace([field], [search]) ... or simulates it elsewhere
using the three-argument replace function:
replace([field], [search], '')
replace([field], [search]) or
str_replace([field], [search])
RESPECT NULLS clause to the window function.
ResultSet type
This is not a SQL or JDBC standard.
SelectQueryINSERT statement to return all fields in
R.
INSERT statement to return a list of fields in
R.
INSERT statement to return a list of fields in
R.
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(TableLike)
This is only possible where the underlying RDBMS supports it
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
RIGHT OUTER JOIN a table to the last
table added to the FROM clause using
Table.rightOuterJoin(String, Object...)
RIGHT OUTER JOIN a table to this table.
RIGHT OUTER JOIN a table to this table.
RIGHT OUTER JOIN a table to this table.
round([field]) or
round([field], 0)
... or simulates it elsewhere using floor and ceil
round([field], [decimals])
... or simulates it elsewhere using floor and ceil
ROWID pseudo-field
_rowid_ pseudo-field.
0 that caused the error
ROWNUM pseudo-field
row_number() over ([analytic clause]) function.
ROWS BETWEEN CURRENT ROW ...
- rowsBetweenFollowing(int) -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS BETWEEN [number] FOLLOWING ...
- rowsBetweenPreceding(int) -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS BETWEEN [number] PRECEDING ...
- rowsBetweenUnboundedFollowing() -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS BETWEEN UNBOUNDED FOLLOWING ...
- rowsBetweenUnboundedPreceding() -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS BETWEEN UNBOUNDED PRECEDING ...
- rowsCurrentRow() -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS CURRENT ROW frame clause to the window function.
- rowsFollowing(int) -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS [number] FOLLOWING frame clause to the window
function.
- rowsPreceding(int) -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS [number] PRECEDING frame clause to the window
function.
- rowsUnboundedFollowing() -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS UNBOUNDED FOLLOWING frame clause to the window
function.
- rowsUnboundedPreceding() -
Method in interface org.jooq.WindowRowsStep
- Add a
ROWS UNBOUNDED PRECEDING frame clause to the window
function.
- rpad(Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- rpad(int) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- rpad(Field<? extends Number>, Field<String>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- rpad(int, char) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- rpad(Field<String>, int) -
Static method in class org.jooq.impl.Factory
- Get the rpad(field, length) function
- rpad(Field<String>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the rpad(field, length) function
This renders the rpad function where available:
rpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat([field], repeat(' ', [length] - length([field])))
- rpad(Field<String>, int, char) -
Static method in class org.jooq.impl.Factory
- Get the rpad(field, length, character) function
- rpad(Field<String>, int, String) -
Static method in class org.jooq.impl.Factory
- Get the rpad(field, length, character) function
- rpad(Field<String>, Field<? extends Number>, Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the rpad(field, length, character) function
This renders the rpad function where available:
rpad([field], [length]) ... or simulates it
elsewhere using concat, repeat, and length, which may be simulated as
well, depending on the RDBMS:
concat([field], repeat([character], [length] - length([field])))
- rtrim() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- rtrim(String) -
Static method in class org.jooq.impl.Factory
- Get the rtrim(field) function
- rtrim(Field<String>) -
Static method in class org.jooq.impl.Factory
- Get the rtrim(field) function
This renders the rtrim function in all dialects:
rtrim([field])
Schema.SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT ..
- select(Select<?>) -
Method in interface org.jooq.InsertValuesStep
- Use a
SELECT statement as the source of values for the
INSERT statement
This variant of the INSERT ..
- Select<R extends Record> - Interface in org.jooq
- A
Query that can provide a Result after execution - select(Field<?>...) -
Method in interface org.jooq.SelectSelectStep
- Add additional fields to the
SELECT clause of this query
- select(Collection<? extends Field<?>>) -
Method in interface org.jooq.SelectSelectStep
- Add additional fields to the
SELECT clause of this query
- SelectConditionStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectConnectByConditionStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectConnectByStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - selectCount() -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement for
COUNT(*)
Example:
Factory create = new Factory();
create.selectCount()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- selectCount() -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement for
COUNT(*)
Example:
Factory create = new Factory();
create.selectCount()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- selectDistinct(Field<?>...) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement.
- selectDistinct(Collection<? extends Field<?>>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement.
- selectDistinct(Field<?>...) -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement.
- selectDistinct(Collection<? extends Field<?>>) -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement.
- SelectFinalStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectForUpdateOfStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectForUpdateStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectForUpdateWaitStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - selectFrom(Table<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
- selectFrom(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement
Example:
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
- SelectFromStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectGroupByStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectHavingConditionStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectHavingStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectJoinStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectLimitStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectOffsetStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectOnConditionStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - selectOne() -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement for constant
1 literal
Example:
Factory create = new Factory();
create.selectOne()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- selectOne() -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement for constant
1 literal
Example:
Factory create = new Factory();
create.selectOne()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- SelectOnStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectOrderByStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - selectQuery() -
Method in interface org.jooq.FactoryOperations
- Create a new
SelectQuery
- selectQuery(TableLike<R>) -
Method in interface org.jooq.FactoryOperations
- Create a new
SelectQuery
- selectQuery() -
Method in class org.jooq.impl.Factory
- Create a new
SelectQuery
- selectQuery(TableLike<R>) -
Method in class org.jooq.impl.Factory
- Create a new
SelectQuery
- SelectQuery - Interface in org.jooq
- A query for data selection
- SelectSelectStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectStartWithStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - SelectWhereStep - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting generic
Record types. - selectZero() -
Method in interface org.jooq.FactoryOperations
- Create a new DSL select statement for constant
0 literal
Example:
Factory create = new Factory();
create.selectZero()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- selectZero() -
Method in class org.jooq.impl.Factory
- Create a new DSL select statement for constant
0 literal
Example:
Factory create = new Factory();
create.selectZero()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
- separator(char) -
Method in interface org.jooq.LoaderCSVOptionsStep
- Specify the separator character.
- Sequence<T extends Number> - Interface in org.jooq
- A type representing sequences in databases that support this.
- SequenceImpl<T extends Number> - Class in org.jooq.impl
- A common base class for sequences
This type is for JOOQ INTERNAL USE only.
- SequenceImpl(String, Schema, DataType<T>) -
Constructor for class org.jooq.impl.SequenceImpl
-
- SERIAL -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SERIAL4 -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SERIAL8 -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- set(Array) -
Method in interface org.jooq.ArrayRecord
- Set the contained array
- set(E...) -
Method in interface org.jooq.ArrayRecord
- Set the contained array
- set(T...) -
Method in class org.jooq.impl.ArrayRecordImpl
-
- set(Array) -
Method in class org.jooq.impl.ArrayRecordImpl
-
- set(Field<T>, T) -
Method in interface org.jooq.InsertOnDuplicateSetStep
- Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
- set(Field<T>, Field<T>) -
Method in interface org.jooq.InsertOnDuplicateSetStep
- Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
- set(Map<? extends Field<?>, ?>) -
Method in interface org.jooq.InsertOnDuplicateSetStep
- Set multiple values for
UPDATE in the INSERT
statement's ON DUPLICATE KEY UPDATE clause
Please assure that key/value pairs have matching <T>
types.
- set(Field<T>, T) -
Method in interface org.jooq.InsertSetStep
- Set a value for a field in the
UPDATE statement
- set(Field<T>, Field<T>) -
Method in interface org.jooq.InsertSetStep
- Set a value for a field in the
UPDATE statement
- set(Map<? extends Field<?>, ?>) -
Method in interface org.jooq.InsertSetStep
- Set a value for a field in the
UPDATE statement
Please assure that key/value pairs have matching <T>
types.
- set(Field<T>, T) -
Method in interface org.jooq.MergeMatchedSetStep
- Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause
- set(Field<T>, Field<T>) -
Method in interface org.jooq.MergeMatchedSetStep
- Set values for
UPDATE in the MERGE statement's
WHEN MATCHED clause
- set(Map<? extends Field<?>, ?>) -
Method in interface org.jooq.MergeMatchedSetStep
- Set multiple values for
UPDATE in the MERGE
statement's WHEN MATCHED clause.
- set(Field<T>, T) -
Method in interface org.jooq.MergeNotMatchedSetStep
- Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause
- set(Field<T>, Field<T>) -
Method in interface org.jooq.MergeNotMatchedSetStep
- Set values for
INSERT in the MERGE statement's
WHEN NOT MATCHED clause
- set(Map<? extends Field<?>, ?>) -
Method in interface org.jooq.MergeNotMatchedSetStep
- Set multiple values for
INSERT in the MERGE
statement's WHEN NOT MATCHED clause.
- set(Field<T>, T) -
Method in interface org.jooq.UpdateSetStep
- Set a value for a field in the
UPDATE statement
- set(Field<T>, Field<T>) -
Method in interface org.jooq.UpdateSetStep
- Set a value for a field in the
UPDATE statement
- set(Map<? extends Field<?>, ?>) -
Method in interface org.jooq.UpdateSetStep
- Set a value for a field in the
UPDATE statement
Please assure that key/value pairs have matching <T>
types.
- SET -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- setConnectByStartWith(Condition) -
Method in interface org.jooq.SelectQuery
- Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause
- setConverted(Object) -
Method in interface org.jooq.Param
- Sets a converted value, using this
Param's underlying
DataType, obtained from NamedTypeProviderQueryPart.getDataType()
- setDefaultSchema(String) -
Method in class org.jooq.SchemaMapping
- Synonym for
SchemaMapping.use(String).
- setDistinct(boolean) -
Method in interface org.jooq.SelectQuery
- Add "distinct" keyword to the select clause
- setField(Parameter<?>, Field<?>) -
Method in class org.jooq.impl.AbstractRoutine
-
- setForShare(boolean) -
Method in interface org.jooq.LockProvider
- Sets the "FOR SHARE" flag onto the query
This has been observed to be supported by any of these dialects:
MySQL's InnoDB locking reads
Postgres FOR UPDATE / FOR SHARE
If your dialect does not support this clause, jOOQ will still render it,
if you apply it to your query.
- setForUpdate(boolean) -
Method in interface org.jooq.LockProvider
- Sets the "FOR UPDATE" flag onto the query
This has been observed to be supported by any of these dialects:
setForUpdateNoWait() -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateOf(Field<?>...) -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Collection<? extends Field<?>>) -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the fields that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateOf(Table<?>...) -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the tables that should be locked by the
FOR UPDATE clause, instead of the full row.
- setForUpdateSkipLocked() -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setForUpdateWait(int) -
Method in interface org.jooq.LockProvider
- Some RDBMS allow for specifying the locking mode for the applied
FOR UPDATE clause.
- setList(List<? extends E>) -
Method in interface org.jooq.ArrayRecord
- Set the contained array as a
List
- setList(List<? extends T>) -
Method in class org.jooq.impl.ArrayRecordImpl
-
- setNumber(Parameter<? extends Number>, Number) -
Method in class org.jooq.impl.AbstractRoutine
-
- setNumber(Parameter<? extends Number>, Field<? extends Number>) -
Method in class org.jooq.impl.AbstractRoutine
-
- setOverloaded(boolean) -
Method in class org.jooq.impl.AbstractRoutine
-
- setProvider(ConfigurationProvider) -
Static method in class org.jooq.ConfigurationRegistry
- Register a client
ConfigurationProvider to provide jOOQ with
Configuration's upon deserialisation.
- setRecord(R) -
Method in interface org.jooq.StoreQuery
- Add values to the store statement
- setReturning() -
Method in interface org.jooq.InsertQuery
- Configure the
INSERT statement to return all fields in
R.
- setReturning(Identity<R, ? extends Number>) -
Method in interface org.jooq.InsertQuery
- Configure the
INSERT statement to return the generated
identity value.
- setReturning(Field<?>...) -
Method in interface org.jooq.InsertQuery
- Configure the
INSERT statement to return a list of fields in
R.
- setReturning(Collection<? extends Field<?>>) -
Method in interface org.jooq.InsertQuery
- Configure the
INSERT statement to return a list of fields in
R.
- setReturnParameter(Parameter<T>) -
Method in class org.jooq.impl.AbstractRoutine
-
- setSchemaMapping(Map<String, String>) -
Method in class org.jooq.SchemaMapping
- Initialise SchemaMapping.
- setValue(Parameter<?>, Object) -
Method in class org.jooq.impl.AbstractRoutine
-
- setValue(T) -
Method in interface org.jooq.Param
- Set the parameter's underlying value.
- setValue(Field<T>, T) -
Method in interface org.jooq.Record
- Set a value into this record.
- sha1(String) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
SHA1() function
- sha1(Field<String>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
SHA1() function
- sha2(String, int) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
SHA2() function
- sha2(Field<String>, Field<Integer>) -
Static method in class org.jooq.util.mysql.MySQLFactory
- Get the MySQL-specific
SHA2() function
- shl(T, T) -
Static method in class org.jooq.impl.Factory
- The bitwise left shift operator.
- shl(T, Field<T>) -
Static method in class org.jooq.impl.Factory
- The bitwise left shift operator.
- shl(Field<T>, T) -
Static method in class org.jooq.impl.Factory
- The bitwise left shift operator.
- shl(Field<T>, Field<T>) -
Static method in class org.jooq.impl.Factory
- The bitwise left shift operator.
- shr(T, T) -
Static method in class org.jooq.impl.Factory
- The bitwise right shift operator.
- shr(T, Field<T>) -
Static method in class org.jooq.impl.Factory
- The bitwise right shift operator.
- shr(Field<T>, T) -
Static method in class org.jooq.impl.Factory
- The bitwise right shift operator.
- shr(Field<T>, Field<T>) -
Static method in class org.jooq.impl.Factory
- The bitwise right shift operator.
- sign() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- sign(Number) -
Static method in class org.jooq.impl.Factory
- Get the sign of a numeric field: sign(field)
- sign(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sign of a numeric field: sign(field)
This renders the sign function where available:
sign([field])
... or simulates it elsewhere (without bind variables on values -1, 0, 1):
CASE WHEN [this] > 0 THEN 1
WHEN [this] < 0 THEN -1
ELSE 0
END
- SIGNED -
Static variable in class org.jooq.util.h2.H2DataType
-
- SIGNTYPE -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- SimpleSelectConditionStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectFinalStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectForUpdateOfStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectForUpdateStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectForUpdateWaitStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectLimitStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectOffsetStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectOrderByStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - SimpleSelectQuery<R extends Record> - Interface in org.jooq
- A simple select query that provides Records from a single table, with no
joins allowed.
- SimpleSelectWhereStep<R extends Record> - Interface in org.jooq
- This type is used for the
Select's DSL API when selecting specific
Record types. - sin() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- sin(Number) -
Static method in class org.jooq.impl.Factory
- Get the sine(field) function
- sin(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sine(field) function
This renders the sin function where available:
sin([field])
- sinh() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- sinh(Number) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic sine function: sinh(field)
- sinh(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the hyperbolic sine function: sinh(field)
This renders the sinh function where available:
sinh([field]) ... or simulates it elsewhere using
exp: (exp([field] * 2) - 1) / (exp([field] * 2))
- size() -
Method in interface org.jooq.ArrayRecord
- Get the size of the contained array
- size() -
Method in class org.jooq.impl.ArrayRecordImpl
-
- size() -
Method in interface org.jooq.Store
- Get the size of this
Store.
- skipLocked() -
Method in interface org.jooq.SelectForUpdateWaitStep
- Add a
WAIT clause to the FOR UPDATE clause at
the end of the query.
- skipLocked() -
Method in interface org.jooq.SimpleSelectForUpdateWaitStep
- Add a
WAIT clause to the FOR UPDATE clause at
the end of the query.
- SMALLDATETIME -
Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLDATETIME -
Static variable in class org.jooq.util.h2.H2DataType
-
- SMALLDATETIME -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLDATETIME -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- SMALLINT -
Static variable in class org.jooq.impl.SQLDataType
- The
Types.SMALLINT type
- SMALLINT -
Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLINT -
Static variable in class org.jooq.util.db2.DB2DataType
-
- SMALLINT -
Static variable in class org.jooq.util.derby.DerbyDataType
-
- SMALLINT -
Static variable in class org.jooq.util.h2.H2DataType
-
- SMALLINT -
Static variable in class org.jooq.util.hsqldb.HSQLDBDataType
-
- SMALLINT -
Static variable in class org.jooq.util.ingres.IngresDataType
-
- SMALLINT -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- SMALLINT -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- SMALLINT -
Static variable in class org.jooq.util.postgres.PostgresDataType
-
- SMALLINT -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- SMALLINT -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLINT -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- SMALLINTUNSIGNED -
Static variable in class org.jooq.impl.SQLDataType
- The unsigned
Types.SMALLINT type
- SMALLINTUNSIGNED -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- SMALLMONEY -
Static variable in class org.jooq.util.ase.ASEDataType
-
- SMALLMONEY -
Static variable in class org.jooq.util.sqlserver.SQLServerDataType
-
- SMALLMONEY -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- sort(Map<T, Z>) -
Method in interface org.jooq.Field
- Create a sort field of the form (in pseudo code)
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
WHEN [sortMap.key(1)] THEN sortMap.value(1)
...
- sortAsc(Collection<T>) -
Method in interface org.jooq.Field
- Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
...
- sortAsc(T...) -
Method in interface org.jooq.Field
- Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
...
- sortDesc(Collection<T>) -
Method in interface org.jooq.Field
- Create a sort field of the form
CASE [this] WHEN [sortList.get(0)] THEN 0
WHEN [sortList.get(1)] THEN 1
...
- sortDesc(T...) -
Method in interface org.jooq.Field
- Create a sort field of the form
CASE [this] WHEN [sortList[0]] THEN 0
WHEN [sortList[1]] THEN 1
...
- SortField<T> - Interface in org.jooq
- A wrapper for a
Field and a SortField - SortOrder - Enum in org.jooq
- The sorting order used in OrderByFieldLists
- splitDebug(String) -
Method in class org.jooq.tools.StopWatch
- Split the time and debug log a message, if trace logging is enabled
- splitInfo(String) -
Method in class org.jooq.tools.StopWatch
- Split the time and info log a message, if trace logging is enabled
- splitTrace(String) -
Method in class org.jooq.tools.StopWatch
- Split the time and trace log a message, if trace logging is enabled
- sql(String) -
Method in interface org.jooq.RenderContext
- Append some SQL to the context's contained
StringBuilder
- sql(char) -
Method in interface org.jooq.RenderContext
- Append some SQL to the context's contained
StringBuilder
- sql(int) -
Method in interface org.jooq.RenderContext
- Append some SQL to the context's contained
StringBuilder
- sql(QueryPart) -
Method in interface org.jooq.RenderContext
- Recurse rendering
- SQLDataType<T> - Class in org.jooq.impl
- The SQL standard data types, as described in
Types. - SQLDialect - Enum in org.jooq
- This enumeration lists all supported dialects.
- SQLDialectNotSupportedException - Exception in org.jooq.exception
- An exception thrown if an SQL construct is used, which is not supported by
the dialect set in
Configuration.getDialect() - SQLDialectNotSupportedException(String) -
Constructor for exception org.jooq.exception.SQLDialectNotSupportedException
-
- SQLDialectNotSupportedException(String, boolean) -
Constructor for exception org.jooq.exception.SQLDialectNotSupportedException
-
- SQLiteDataType<T> - Class in org.jooq.util.sqlite
- Supported data types for the
SQLDialect.SQLITE dialect - SQLiteFactory - Class in org.jooq.util.sqlite
- A
SQLDialect.SQLITE specific factory - SQLiteFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.sqlite.SQLiteFactory
- Create a factory with connection and a schema mapping configured
- SQLiteFactory(Connection) -
Constructor for class org.jooq.util.sqlite.SQLiteFactory
- Create a factory with connection
- SQLServerDataType<T> - Class in org.jooq.util.sqlserver
- Supported data types for the
SQLDialect.SQLSERVER dialect - SQLServerFactory - Class in org.jooq.util.sqlserver
- A
SQLDialect.SQLSERVER specific factory - SQLServerFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.sqlserver.SQLServerFactory
- Create a factory with connection and a schema mapping configured
- SQLServerFactory(Connection) -
Constructor for class org.jooq.util.sqlserver.SQLServerFactory
- Create a factory with connection
- sqrt() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- sqrt(Number) -
Static method in class org.jooq.impl.Factory
- Get the sqrt(field) function
- sqrt(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sqrt(field) function
This renders the sqrt function where available:
sqrt([field]) ... or simulates it elsewhere using
power (which in turn may also be simulated using ln and exp functions):
power([field], 0.5)
- startWith(Condition) -
Method in interface org.jooq.SelectStartWithStep
- Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause
- startWith(String) -
Method in interface org.jooq.SelectStartWithStep
- Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- startWith(String, Object...) -
Method in interface org.jooq.SelectStartWithStep
- Add an Oracle-specific
START WITH clause to the query's
CONNECT BY clause
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
- statement() -
Method in interface org.jooq.BindContext
- Retrieve the context's underlying
PreparedStatement
- stddevPop() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- stddevPop(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the population standard deviation of a numeric field: stddev_pop(field)
This is known to be supported in any of these RDBMS:
DB2
H2
HSQLDB
Ingres
MySQL
Oracle
Postgres
SQL Server (stdev)
Sybase ASE
Sybase SQL Anywhere
- stddevPopOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- stddevSamp() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- stddevSamp(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sample standard deviation of a numeric field: stddev_samp(field)
This is known to be supported in any of these RDBMS:
DB2
H2
HSQLDB
Ingres
MySQL
Oracle
Postgres
SQL Server (stdev)
Sybase ASE
Sybase SQL Anywhere
- stddevSampOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- StopWatch - Class in org.jooq.tools
- A time measuring device
- StopWatch() -
Constructor for class org.jooq.tools.StopWatch
- Initialise the stop watch
- store() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- Store<E> - Interface in org.jooq
- A common base type for
Record and ArrayRecord providing
common, index-based functionality for storage objects
Store implements Attachable, as some stores need a
reference to an open JDBC connection to perform some actions on their
elements. - store() -
Method in interface org.jooq.UpdatableRecord
- Store this record back to the database.
- stored() -
Method in interface org.jooq.Loader
- The number of inserted or updated rows
- StoreQuery<R extends Record> - Interface in org.jooq
- A query storing objects to the database.
- storeUsing(TableField<R, ?>...) -
Method in class org.jooq.impl.TableRecordImpl
-
- storeUsing(TableField<R, ?>...) -
Method in interface org.jooq.TableRecord
- Store this record back to the database.
- StringUtils - Class in org.jooq.tools
-
Operations on
String that are null safe. - sub(Number) -
Method in interface org.jooq.Field
- An arithmetic expression subtracting value from this.
- sub(Field<? extends Number>) -
Method in interface org.jooq.Field
- An arithmetic expression subtracting value from this
- subquery() -
Method in interface org.jooq.Context
- Whether the current context is rendering a sub-query (nested query)
- subquery(boolean) -
Method in interface org.jooq.Context
- Set the new context value for
Context.subquery()
- substring(int) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- substring(Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- substring(int, int) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- substring(Field<? extends Number>, Field<? extends Number>) -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- substring(Field<String>, int) -
Static method in class org.jooq.impl.Factory
- Get the substring(field, startingPosition) function
- substring(Field<String>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the substring(field, startingPosition) function
This renders the substr or substring function:
substr([field], [startingPosition]) or
substring([field], [startingPosition])
- substring(Field<String>, int, int) -
Static method in class org.jooq.impl.Factory
- Get the substring(field, startingPosition, length) function
- substring(Field<String>, Field<? extends Number>, Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the substring(field, startingPosition, length) function
This renders the substr or substring function:
substr([field], [startingPosition], [length]) or
substring([field], [startingPosition], [length])
- sum() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- sum(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sum over a numeric field: sum(field)
- sumDistinct(Field<? extends Number>) -
Static method in class org.jooq.impl.Factory
- Get the sum over a numeric field: sum(distinct field)
- sumOver() -
Method in interface org.jooq.Field
- This method is part of the pre-2.0 API.
- Support - Annotation Type in org.jooq
- A formal declaration of whether any API element is supported by a given
SQLDialect
The annotation is mainly used in three modes:
The annotation is absent on a method. - SybaseDataType<T> - Class in org.jooq.util.sybase
- Supported data types for the
SQLDialect.SYBASE dialect - SybaseFactory - Class in org.jooq.util.sybase
- A
SQLDialect.SYBASE specific factory - SybaseFactory(Connection, SchemaMapping) -
Constructor for class org.jooq.util.sybase.SybaseFactory
- Create a factory with connection and a schema mapping configured
- SybaseFactory(Connection) -
Constructor for class org.jooq.util.sybase.SybaseFactory
- Create a factory with connection
- sysConnectByPath(Field<?>, String) -
Static method in class org.jooq.util.oracle.OracleFactory
- Retrieve the Oracle-specific
SYS_CONNECT_BY_PATH(field, separator) function (to be used
along with CONNECT BY clauses).
- sysContext(String, String) -
Static method in class org.jooq.util.oracle.OracleFactory
- The Oracle-specific
SYS_CONTEXT function
- sysContext(String, String, int) -
Static method in class org.jooq.util.oracle.OracleFactory
- The Oracle-specific
SYS_CONTEXT function
- SYSNAME -
Static variable in class org.jooq.util.ase.ASEDataType
-
TableLike.asTable().
Factory.unnest(List)
Factory.unnest(Object[])
Factory.unnest(ArrayRecord)
Factory.unnest(Field)
JOIN
clause, where the join criteria is added using an ON clause
(with a Condition.JOIN clause,
where there must be a join criteria added using an ON clause
(with a Condition), or using a USING clause (with a list
of Field)tan([field])
tanh([field]) ... or simulates it elsewhere using
exp:
(exp([field] * 2) - 1) / (exp([field] * 2) + 1)
Types.TIME type
Types.TIMESTAMP type
Types.TINYINT type
Types.TINYINT type
BigInteger.
QueryPart to a SQL string contained in
context.sql().
QueryPart to a SQL string contained in
context.sql().
QueryPart to a SQL string contained in
context.sql().
trim([field]) ... or simulates it elsewhere using
rtrim and ltrim: ltrim(rtrim([field]))
Condition that will always evaluate to true
Query that can truncate a table in the database.2 literal.
unsigned byte typeunsigned byte
unsigned byte by masking it with 0xFF
i.e.
unsigned byte
unsigned byte
unsigned byte by masking it with 0xFF
i.e.
unsigned byte
unsigned int
unsigned int by masking it with
0xFFFFFFFF i.e.
unsigned int
unsigned int typeunsigned int
unsigned int by masking it with
0xFFFFFFFF i.e.
unsigned int
unsigned long typeunsigned long
unsigned long by masking it with
0xFFFFFFFFFFFFFFFF i.e.
unsigned long
unsigned long
unsigned long by masking it with
0xFFFFFFFFFFFFFFFF i.e.
unsigned long
UNCOMPRESS() function
UNCOMPRESS() function
UNCOMPRESSED_LENGTH() function
UNCOMPRESSED_LENGTH() function
UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY.TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries.
TABLE function for H2, or the
UNNEST function in HSQLDB and Postgres
For Oracle, use Factory.table(ArrayRecord) instead, as Oracle knows only
typed arrays
In all other dialects, unnesting of arrays is simulated using several
UNION ALL connected subqueries.
TABLE function for
Oracle.
Query that can update data in the database.Update's DSL API.Update's DSL API.UpdateQuery
UpdateQuery
Update's DSL API.Update's DSL API.Update's DSL API.upper([field])
unsigned short
unsigned short by masking it with
0xFFFF i.e.
unsigned short
unsigned short typeunsigned short
unsigned short by masking it with
0xFFFF i.e.
unsigned short
USING clause to the MERGE statement
USING(column [, column...])
- using(Collection<? extends Field<?>>) -
Method in interface org.jooq.SelectOnStep
- Join the previous table with the
USING(column [, column...])
- using(Field<?>...) -
Method in interface org.jooq.TableOnStep
- Join the table with the
USING(column [, column...])
- using(Collection<? extends Field<?>>) -
Method in interface org.jooq.TableOnStep
- Join the table with the
USING(column [, column...])
- usingDual() -
Method in interface org.jooq.MergeUsingStep
- Add a dummy
USING clause to the MERGE statement
This results in USING(SELECT 1 FROM DUAL) for most RDBMS, or
in USING(SELECT 1) AS [dummy_table(dummy_field)] in SQL
Server, where derived tables need to be aliased.
- UUID -
Static variable in class org.jooq.util.h2.H2DataType
-
DataType from the provided Java
type <T>.
value as type in a
PreparedStatement.
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
CASE value WHEN 1 THEN 'one'
WHEN 2 THEN 'two'
ELSE 'three'
END
Factory.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword.
Factory.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword.
Factory.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword.
Factory.val(Object) to be used in Scala and Groovy, where
val is a reserved keyword.
unsigned byte
unsigned byte by masking it with 0xFF
i.e.
unsigned int
unsigned int by masking it with
0xFFFFFFFF i.e.
unsigned long
unsigned long by masking it with
0xFFFFFFFFFFFFFFFF i.e.
unsigned short
unsigned short by masking it with
0xFFFF i.e.
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
VALUES for INSERT in the MERGE
statement's WHEN NOT MATCHED THEN INSERT clause.
Types.VARBINARY type
Types.VARCHAR type
WAIT clause to the FOR UPDATE clause at
the end of the query.
WAIT clause to the FOR UPDATE clause at
the end of the query.
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
CASE WHEN x < 1 THEN 'one'
WHEN x >= 2 THEN 'two'
ELSE 'three'
END
Instances of Case are created through the
WHEN MATCHED THEN UPDATE clause to the
MERGE statement
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement.
WHEN NOT MATCHED THEN INSERT clause to the
MERGE statement
WHEN MATCHED THEN UPDATE clause to the
MERGE statement
WHERE clause to the preceding
WHEN MATCHED THEN UPDATE clause.
WHERE clause to the preceding
WHEN NOT MATCHED THEN INSERT clause.
WHERE clause to the query
WHERE clause to the query
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
WHERE clause to the query
WHERE clause to the query
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
WHERE clause to the query
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity.
WHERE EXISTS clause to the query
WHERE EXISTS clause to the query
WHERE NOT EXISTS clause to the query
WHERE NOT EXISTS clause to the query
0 literal.
|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||