|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
Operator.AND
Operator.AND
Factory create = new Factory();
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.execute();
USING clause
USING clause
OrderProvider.addLimit(int, int) with offset = 0
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.
QueryPart that can create an aliased QueryPart of itselfOperator.AND
operator.
Operator.AND
operator.
Operator.AND
operator.
Operator.AND operator
Operator.AND operator
Operator.AND operator
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
...
- 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.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.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.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
-
- 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
- Don't allow any further overrides
- as(String) -
Method in class org.jooq.impl.TableImpl
-
- 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
- ascending() -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.asc() instead
- ascii() -
Method in interface org.jooq.Field
- Get the ascii(field) function
- 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.StoredFunctionImpl
-
- asField(String) -
Method in class org.jooq.impl.StoredFunctionImpl
-
- asin() -
Method in interface org.jooq.Field
- Get the arc sine(field) function
- 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
-
- asNumberDataType(Class<N>) -
Method in interface org.jooq.DataType
- Retrieve the precise numeric data type for a given NUMBER type
- asNumberDataType(Class<N>) -
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
- Get the arc tangent(field) function
- atan2(Number) -
Method in interface org.jooq.Field
- Get the arc tangent 2(field, y) function
- atan2(Field<? extends Number>) -
Method in interface org.jooq.Field
- Get the arc tangent 2(field, y) function
- attach(Configuration) -
Method in interface org.jooq.Attachable
- Attach this record to a new
Configuration
- 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
- Get the average over a numeric field: avg(field)
- avgOver() -
Method in interface org.jooq.Field
- The
avg(field) over ([analytic clause]) function.
this between minValue and maxValue
this between minValue and maxValue
QueryPartInternal.bindReference(Configuration, PreparedStatement)
instead
QueryPartInternal.bindReference(Configuration, PreparedStatement, int)
instead
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.
ResultSet
COALESCE(expr1, expr2, ... , exprn)
function
COALESCE(expr1, expr2, ... , exprn)
function
Returns the dialect's equivalent to COALESCE:
Oracle COALESCE
this || fields[0] || fields[1] || ...
- concat(String...) -
Method in interface org.jooq.Field
- Get the concat(value[, value, ...]) function
This creates
this || fields[0] || fields[1] || ...
- concat(Field<?>...) -
Method in class org.jooq.impl.CustomField
- Don't allow any further overrides
- concatenate(Field<String>, Field<String>...) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.concat(Field...) instead
- concatenate(String, String...) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.concat(String...) instead
- Condition - Interface in org.jooq
- A condition to be used in a query's where part
- 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
-
- constant(T) -
Method in class org.jooq.impl.Factory
- Get a constant value
jOOQ tries to derive the RDBMS
DataType from the provided Java
type <T>.
- constant(Object, Class<? extends T>) -
Method in class org.jooq.impl.Factory
- Get a constant value with an associated type, taken from a field
- constant(Object, Field<T>) -
Method in class org.jooq.impl.Factory
- Get a constant value with an associated type, taken from a field
- constant(Object, DataType<T>) -
Method in class org.jooq.impl.Factory
- Get a constant value with an associated type
This will try to bind
value as type in a
PreparedStatement.
- constant(Object...) -
Method in class org.jooq.impl.Factory
- Deprecated. - This method causes issues when overloading. Use
Factory.constants(Object...) instead
- constants(Object...) -
Method in class org.jooq.impl.Factory
- Get a list of constant values and fields
- convert(Object) -
Method in interface org.jooq.DataType
- Convert an arbitrary object into
<T>
- convert(Object) -
Method in class org.jooq.impl.AbstractDataType
-
- cos() -
Method in interface org.jooq.Field
- Get the cosine(field) function
- cosh() -
Method in interface org.jooq.Field
- Get the hyperbolic cosine function: cosh(field)
- cot() -
Method in interface org.jooq.Field
- Get the cotangent(field) function
- coth() -
Method in interface org.jooq.Field
- Get the hyperbolic cotangent function: coth(field)
- count() -
Method in interface org.jooq.Field
- Get the count(field) function
- count() -
Method in class org.jooq.impl.Factory
- Get the count(*) function
- countDistinct() -
Method in interface org.jooq.Field
- Get the count(distinct field) function
- countMatches(String, String) -
Static method in class org.jooq.impl.StringUtils
-
Counts how many times the substring appears in the larger String.
- countOver() -
Method in interface org.jooq.Field
- The
count(field) over ([analytic clause]) function.
- countOver() -
Method in class org.jooq.impl.Factory
- The
count(*) over ([analytic clause]) function.
- 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
- 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
- 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
CROSS JOIN a table and proceed to the next step
- crossJoin(String) -
Method in interface org.jooq.SelectJoinStep
CROSS JOIN a table and proceed to the next step
- crossJoin(String, Object...) -
Method in interface org.jooq.SelectJoinStep
CROSS JOIN a table and proceed to the next step
- currentDate() -
Method in class org.jooq.impl.Factory
- Get the current_date() function
This translates into any dialect
- currentTime() -
Method in class org.jooq.impl.Factory
- Get the current_time() function
This translates into any dialect
- currentTimestamp() -
Method in class org.jooq.impl.Factory
- Get the current_timestamp() function
This translates into any dialect
- currentUser() -
Method in class org.jooq.impl.Factory
- Get the current_user() function
This translates into any dialect
- currval(Sequence) -
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(Configuration) -
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(Configuration, String, DataType<T>) -
Constructor for class org.jooq.impl.CustomField
-
SQLDialect.DB2 dialectSQLDialect.DB2 specific factoryDECODE(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() -
Method in class org.jooq.impl.Factory
- Initialise a
Case statement.
- decode(T, T, Z) -
Method in class org.jooq.impl.Factory
- Gets the Oracle-style
DECODE(expression, search, result[, search , result]... [, default])
function
- decode(T, T, Z, Object...) -
Method in class org.jooq.impl.Factory
- Gets the Oracle-style
DECODE(expression, search, result[, search , result]... [, default])
function
- decode(Field<T>, Field<T>, Field<Z>) -
Method in class org.jooq.impl.Factory
- Gets the Oracle-style
DECODE(expression, search, result[, search , result]... [, default])
function
- decode(Field<T>, Field<T>, Field<Z>, Field<?>...) -
Method in class org.jooq.impl.Factory
- Gets the Oracle-style
DECODE(expression, search, result[, search , result]... [, default])
function
- defaultString(String) -
Static method in class org.jooq.impl.StringUtils
-
Returns either the passed in String, or if the String is
null, an empty String ("").
- deg() -
Method in interface org.jooq.Field
- Calculate degrees from radians from this field
- Delete - Interface in org.jooq
- A
Query that can delete data in the database. - 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.
- DeleteConditionStep - Interface in org.jooq
- This type is used for the
Delete's DSL API. - DeleteFinalStep - 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 class org.jooq.impl.Factory
- Create a new
DeleteQuery
- DeleteWhereStep - Interface in org.jooq
- This type is used for the
Delete's DSL API. - denseRankOver() -
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
- descending() -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.desc() instead
- DetachedException - Exception in org.jooq.exception
- An operation was invoked on a detached object (
Query,
QueryPart, or UpdatableRecord). - DetachedException() -
Constructor for exception org.jooq.exception.DetachedException
-
- DetachedException(String, Throwable) -
Constructor for exception org.jooq.exception.DetachedException
-
- DetachedException(String) -
Constructor for exception org.jooq.exception.DetachedException
-
- DetachedException(Throwable) -
Constructor for exception org.jooq.exception.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
- divide(Number) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.div(Number) instead
- divide(Field<? extends Number>) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.div(Field) instead
- 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.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
-
this = value
this = field
this = (SelectequalAll(Select<?>) -
Method in interface org.jooq.Field
this = all (SelectequalAny(Select<?>) -
Method in interface org.jooq.Field
this = any (Selectequals(Object) -
Method in interface org.jooq.Field
- Watch out!
- equalSome(Select<?>) -
Method in interface org.jooq.Field
this = some (Selecterror(Object) -
Method in class org.jooq.impl.JooqLogger
-
- error(Object, Object) -
Method in class org.jooq.impl.JooqLogger
-
- error(Object, Throwable) -
Method in class org.jooq.impl.JooqLogger
-
- error(Object, Object, Throwable) -
Method in class org.jooq.impl.JooqLogger
-
- except(Select<R>) -
Method in interface org.jooq.Select
- Combine with other selects
- execute() -
Method in class org.jooq.impl.StoredFunctionImpl
-
- execute() -
Method in class org.jooq.impl.StoredProcedureImpl
-
- execute() -
Method in interface org.jooq.Query
- Execute the query, if it has been created with a properly configured
factory
- execute(Connection) -
Method in interface org.jooq.StoredObject
- Execute the stored object on a connection
- execute() -
Method in interface org.jooq.StoredObject
- Execute the stored object on an underlying connection
- execute() -
Method in class org.jooq.util.postgres.PostgresSingleUDTOutParameterProcedure
-
- 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 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 class org.jooq.impl.Factory
- Insert one record
INSERT INTO [table] ...
- 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 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<?>) -
Method in class org.jooq.impl.Factory
- Create a not exists condition.
- exp() -
Method in interface org.jooq.Field
- Get the exp(field) function
- extract(DatePart) -
Method in interface org.jooq.Field
- Get the extract(field, datePart) function
This translates into any dialect
FalseCondition anymore,
as of 1.5.7
Condition that will always evaluate to false
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
Query.execute() and then
Select.getResult()
SELECT * FROM [table] LIMIT 1
Cursor holds a reference to the executed
PreparedStatement and the associated ResultSet.
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.
SELECT * FROM [table]
SELECT * FROM [table] WHERE [condition]
QueryPart) that holds a list of
Fields.first_value(field) over ([analytic clause]) function.
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.
FULL OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
FULL OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
FULL OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
AttachableInternal
internal API, soon. Do not reference directly.
Factory's underlying
SQLDialect and a given Java type.
SQLDialect
IDENTITY column.
KEY
IDENTITY information, if available.
IDENTITY information, if available.
Key
List
UpdatableTable.getMainKey() instead
Updatable.getMainUniqueKey() instead
Query that is being constructed.
Query that is being constructed.
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.
Types value
IDENTITY's owner table
Key's owner table
ArrayRecord
field.
ArrayRecord
field.
this >= value
this >= field
this >= (SelectgreaterOrEqualAll(Select<?>) -
Method in interface org.jooq.Field
this >= all (SelectgreaterOrEqualAny(Select<?>) -
Method in interface org.jooq.Field
this >= any (SelectgreaterOrEqualSome(Select<?>) -
Method in interface org.jooq.Field
this >= some (SelectgreaterThan(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 (SelectgreaterThanAny(Select<?>) -
Method in interface org.jooq.Field
this > any (SelectgreaterThanSome(Select<?>) -
Method in interface org.jooq.Field
this > some (Selectgreatest(T...) -
Method in interface org.jooq.Field
- Find the greatest among all values
- greatest(Field<?>...) -
Method in interface org.jooq.Field
- Find the greatest among all values
- groupBy(Field<?>...) -
Method in interface org.jooq.SelectGroupByStep
- Add grouping to the query and proceed to the next step
- groupBy(Collection<? extends Field<?>>) -
Method in interface org.jooq.SelectGroupByStep
- Add grouping to the query and proceed to the next step
SQLDialect.H2 dialectSQLDialect.H2 specific factory
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
this in (values...)
- in(Field<?>...) -
Method in interface org.jooq.Field
this in (values...)
- in(Select<?>) -
Method in interface org.jooq.Field
this in (select...)
- info(Object) -
Method in class org.jooq.impl.JooqLogger
-
- info(Object, Object) -
Method in class org.jooq.impl.JooqLogger
-
- info(Object, Throwable) -
Method in class org.jooq.impl.JooqLogger
-
- info(Object, Object, Throwable) -
Method in class org.jooq.impl.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
- Insert - Interface in org.jooq
- A
Query that can insert data in the database. - InsertFinalStep - Interface in org.jooq
- This type is used for the
Insert's DSL API. - 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
- Create a new DSL insert statement.
- InsertOnDuplicateSetMoreStep - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertOnDuplicateSetStep - Interface in org.jooq
- This type is used for the
Insert's DSL API. - InsertOnDuplicateStep - Interface in org.jooq
- This type is used for the
Insert's DSL API. - insertQuery(Table<R>) -
Method in class org.jooq.impl.Factory
- Create a new
InsertQuery
- insertQuery(Table<R>, Select<?>) -
Method in class org.jooq.impl.Factory
- Deprecated. - 1.5.9 - Use the DSL syntax instead:
Factory.insertInto(Table, Select)
- InsertQuery<R extends TableRecord<R>> - Interface in org.jooq
- A query for data insertion
- InsertSelectQuery<R extends TableRecord<R>> - Interface in org.jooq
- Deprecated. - 1.5.9 - Use
Factory.insertInto(Table, Select) and do
not reference this type directly anymore. - InsertSetMoreStep - Interface in org.jooq
- This type is used for the
Insert's alternative DSL API. - InsertSetStep - Interface in org.jooq
- This type is used for the
Insert's alternative DSL API. - InsertValuesStep - Interface in org.jooq
- This type is used for the
Insert's DSL API. - 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
-
- 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.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
-
- internalAPI(Class<T>) -
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
- isBlank(String) -
Static method in class org.jooq.impl.StringUtils
-
Checks if a String is whitespace, empty ("") or null.
- isDebugEnabled() -
Method in class org.jooq.impl.JooqLogger
-
- isEmpty(String) -
Static method in class org.jooq.impl.StringUtils
-
Checks if a String is empty ("") or null.
- isEmpty() -
Method in interface org.jooq.Result
- Whether there are any records contained in this
Result
- isInfoEnabled() -
Method in class org.jooq.impl.JooqLogger
-
- isNotNull() -
Method in interface org.jooq.Field
this is not null
- isNull() -
Method in interface org.jooq.Field
this is 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.
- isNullLiteral() -
Method in class org.jooq.impl.TableFieldImpl
-
- isNullLiteral() -
Method in class org.jooq.impl.UDTFieldImpl
-
- isTraceEnabled() -
Method in class org.jooq.impl.JooqLogger
-
- iterator() -
Method in class org.jooq.impl.ArrayRecordImpl
-
INNER JOIN a table and proceed to the next step
INNER JOIN a table and proceed to the next step
INNER JOIN a table and proceed to the next step
Key is an object representing a UNIQUE KEY, a
PRIMARY KEY, or a FOREIGN KEY.Identity
This executes SELECT max([id.field]) FROM [id.table]
This is NOT supported by SQLDialect.ORACLE
last_value(field) over ([analytic clause]) function.
SelectJoinStep.leftOuterJoin(TableLike) instead
SelectJoinStep.leftOuterJoin(String) instead
SelectJoinStep.leftOuterJoin(String, Object...) instead
LEFT OUTER JOIN a table and proceed to the next step
LEFT OUTER JOIN a table and proceed to the next step
LEFT OUTER JOIN a table and proceed to the next step
this <= value
this <= field
this <= (SelectlessOrEqualToAll(Select<?>) -
Method in interface org.jooq.Field
this <= all (SelectlessOrEqualToAny(Select<?>) -
Method in interface org.jooq.Field
this <= any (SelectlessOrEqualToSome(Select<?>) -
Method in interface org.jooq.Field
this <= some (SelectlessThan(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 (SelectlessThanAny(Select<?>) -
Method in interface org.jooq.Field
this < any (SelectlessThanSome(Select<?>) -
Method in interface org.jooq.Field
this < some (Selectlike(T) -
Method in interface org.jooq.Field
this like value
- limit(int) -
Method in interface org.jooq.SelectLimitStep
- Limit the results of this select
This is the same as calling
SelectLimitStep.limit(int, int) with offset = 0
- limit(int, int) -
Method in interface org.jooq.SelectLimitStep
- Limit the results of this select
- limit(int) -
Method in interface org.jooq.SimpleSelectLimitStep
- Limit the results of this select
This is the same as calling
SimpleSelectLimitStep.limit(int, int) with offset = 0
- limit(int, int) -
Method in interface org.jooq.SimpleSelectLimitStep
- Limit the results of this select
- ln() -
Method in interface org.jooq.Field
- Get the ln(field) function
- 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
- Get the log(field, base) function
- 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.util.ingres.IngresDataType
-
- LONGNVARCHAR -
Static variable in class org.jooq.util.sybase.SybaseDataType
-
- LONGRAW -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- LONGTEXT -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGTEXT -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- 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.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
- Get the lower(field) function
- lpad(Field<? extends Number>) -
Method in interface org.jooq.Field
- Get the rpad(field, length) function
- lpad(int) -
Method in interface org.jooq.Field
- Get the rpad(field, length) function
- lpad(Field<? extends Number>, Field<String>) -
Method in interface org.jooq.Field
- Get the rpad(field, length, c) function
- lpad(int, char) -
Method in interface org.jooq.Field
- Get the rpad(field, length, c) function
- ltrim() -
Method in interface org.jooq.Field
- Get the ltrim(field) function
max(field) over ([analytic clause]) 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.min(field) over ([analytic clause]) function.
Field.mul(Number)
Field.mul(Field) instead
SQLDialect.MYSQL dialectSQLDialect.MYSQL specific factoryNATURAL JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL LEFT OUTER JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL LEFT OUTER JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL LEFT OUTER JOIN a table and proceed to the next step
Natural joins are supported by most RDBMS.
NATURAL RIGHT OUTER JOIN a table and proceed to the next
step
Natural joins are supported by most RDBMS.
NATURAL RIGHT OUTER JOIN a table and proceed to the next
step
Natural joins are supported by most RDBMS.
NATURAL RIGHT OUTER JOIN a table and proceed to the next
step
Natural joins are supported by most RDBMS.
Record that can be inserted into the corresponding
table.
StoreQuery.addValue(Field, Object) (and similar) to fill the next record.
INSERT statement
Factory's underlying JDBC Connection
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 !
- notEqualAny(Select<?>) -
Method in interface org.jooq.Field
this !
- notEqualSome(Select<?>) -
Method in interface org.jooq.Field
this !
- notExists(Select<?>) -
Method in class org.jooq.impl.Factory
- Create a not exists condition.
- notIn(Collection<T>) -
Method in interface org.jooq.Field
this not in (values...)
- notIn(T...) -
Method in interface org.jooq.Field
this not in (values...)
- notIn(Field<?>...) -
Method in interface org.jooq.Field
this not in (values...)
- notIn(Select<?>) -
Method in interface org.jooq.Field
this not in (select...)
- notLike(T) -
Method in interface org.jooq.Field
this not like value
- 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) -
Method in class org.jooq.impl.Factory
- The
ntile([number]) over ([analytic clause]) function.
- NULL() -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.constant(Object) instead. Cast the constant to
any type, if this is necessary in your RDBMS dialect.
- nullif(T) -
Method in interface org.jooq.Field
- Gets the Oracle-style NULLIF(value, other) function
- nullif(Field<T>) -
Method in interface org.jooq.Field
- 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.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.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.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
- Gets the Oracle-style NVL(value, defaultValue) function
- nvl(Field<T>) -
Method in interface org.jooq.Field
- 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
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<Z>, Field<Z>) -
Method in interface org.jooq.Field
- 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
ON DUPLICATE KEY UPDATE clause to this insert query.
ON DUPLICATE KEY UPDATE clause should be added to
this INSERT statement.
1 literal.
Operator.OR
operator.
Operator.OR
operator.
Operator.OR
operator.
Operator.OR operator
Operator.OR operator
Operator.OR operator
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator
Operator.OR operator
Operator.OR operator
SQLDialect.ORACLE dialectSQLDialect.ORACLE specific factorySQLDialect.ORACLE
This class has a hidden dependency on the Oracle JDBC driver.ORDER BY clause to the window function.
ORDER BY clause to the window function.
ORDER BY clause to the window function.
Operator.OR operator.
Operator.OR operator
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator
Operator.OR operator.
Operator.OR operator
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator
Operator.OR operator.
Operator.OR operator
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator and proceed to the next step.
Operator.OR operator
SQLDialect.ORACLE dialectSQLDialect.ORACLE dialect.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.
precent_rank() over ([analytic clause]) function.
SQLDialect.POSTGRES dialectSQLDialect.POSTGRES specific factoryConfiguration to jOOQ, given a deserialised
Configuration.
ConfigurationProvider's
This method is used by jOOQ retrieve a client-provided
Configuration.
rank_over() over ([analytic clause]) function.
SelectQuerySelectQuerySelectJoinStep.rightOuterJoin(TableLike) instead
SelectJoinStep.rightOuterJoin(String) instead
SelectJoinStep.rightOuterJoin(String, Object...) instead
RIGHT OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
RIGHT OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
RIGHT OUTER JOIN a table and proceed to the next step
This is only possible where the underlying RDBMS supports it
OracleFactory.rownum() instead,
or the more general Factory.rowNumberOver() window function.
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 ...
- rowsBetweenUnboundedFollwing() -
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
- Get the rpad(field, length) function
- rpad(int) -
Method in interface org.jooq.Field
- Get the rpad(field, length) function
- rpad(Field<? extends Number>, Field<String>) -
Method in interface org.jooq.Field
- Get the rpad(field, length, c) function
- rpad(int, char) -
Method in interface org.jooq.Field
- Get the rpad(field, length, c) function
- rtrim() -
Method in interface org.jooq.Field
- Get the rtrim(field) function
Schema.Factory.select(Field...) but in fact the compiler links
Factory.select(Object...).
Use Factory.selectZero() or Factory.selectOne() instead, if
you're just selecting dummy values.
Use Factory.constants(Object...) if you really intend to
select several constants
Query that can provide a Result after executionSELECT clause of this query
SELECT clause of this query
Select query, where additional conditions can be added
to the where clause.Select query
SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
Select query
This is the step in query construction, where you can add tables to a query.Select query
This is the step in query construction, where you can add grouping to a
query.Select query, where additional conditions can be added
to the having clause.Select query
This is the step in query construction, where you can add a having clause to
a query.Select query
This is the step in query construction, where you can join tables to a query.Select query
This is the final step in query construction, where you can add a order by
clause to a query.Select query, where additional conditions can be added
to a join's on clause.1 literal
Example:
Factory create = new Factory();
create.selectOne()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
Select query
This is the step in query construction, where you can join tables to a query.Select query
This is the step in query construction, where you can add ordering to a
query.SelectQuery
SelectQuery
Select query
This is the step in query construction, where you can add additional
projections to a query.Select query
This is the step in query construction, where you can add conditions to a
query.0 literal
Example:
Factory create = new Factory();
create.selectZero()
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2)
.execute();
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause
UPDATE in the INSERT
statement's ON DUPLICATE KEY UPDATE clause
Please assure that key/value pairs have matching <T>
types.
UPDATE statement
UPDATE statement
UPDATE statement
Please assure that key/value pairs have matching <T>
types.
UPDATE in the MERGE statement's
WHEN MATCHED clause
UPDATE in the MERGE statement's
WHEN MATCHED clause
UPDATE in the MERGE
statement's WHEN MATCHED clause.
UPDATE statement
UPDATE statement
UPDATE statement
Please assure that key/value pairs have matching <T>
types.
List
ConfigurationProvider to provide jOOQ with
Configuration's upon deserialisation.
Select query, where additional conditions can be
added to the where clause.Select querySelect query
This is the final step in query construction, where you can add a limit
clause to a query.Select query
This is the step in query construction, where you can add a order by clause
to a query.Select query
This is the step in query construction, where you can add conditions to a
query.
CASE [this] WHEN [sortMap.key(0)] THEN sortMap.value(0)
WHEN [sortMap.key(1)] THEN sortMap.value(1)
...
- sortAsc(List<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(List<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.impl.StopWatch
- Split the time and debug log a message, if trace logging is enabled
- splitInfo(String) -
Method in class org.jooq.impl.StopWatch
- Split the time and info log a message, if trace logging is enabled
- splitTrace(String) -
Method in class org.jooq.impl.StopWatch
- Split the time and trace log a message, if trace logging is enabled
- SQLDialect - Enum in org.jooq
- This enumeration lists all supported dialects.
- SQLDialectNotSupportedException - Exception in org.jooq
- 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.SQLDialectNotSupportedException
-
- SQLDialectNotSupportedException(String, boolean) -
Constructor for exception org.jooq.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
- Get the sqrt(field) function
- StopWatch - Class in org.jooq.impl
- A time measuring device
- StopWatch() -
Constructor for class org.jooq.impl.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.
- StoredFunction<T> - Interface in org.jooq
- A stored function
- StoredFunctionImpl<T> - Class in org.jooq.impl
-
- StoredFunctionImpl(SQLDialect, String, Schema, DataType<T>) -
Constructor for class org.jooq.impl.StoredFunctionImpl
-
- StoredFunctionImpl(SQLDialect, String, Schema, Package, DataType<T>) -
Constructor for class org.jooq.impl.StoredFunctionImpl
-
- StoredFunctionImpl(Configuration, String, Schema, DataType<T>) -
Constructor for class org.jooq.impl.StoredFunctionImpl
-
- StoredFunctionImpl(Configuration, String, Schema, Package, DataType<T>) -
Constructor for class org.jooq.impl.StoredFunctionImpl
-
- StoredObject - Interface in org.jooq
- A common interface for stored procedures and stored functions.
- StoredProcedure - Interface in org.jooq
- A stored procedure
- StoredProcedureImpl - Class in org.jooq.impl
-
- StoredProcedureImpl(SQLDialect, String, Schema) -
Constructor for class org.jooq.impl.StoredProcedureImpl
-
- StoredProcedureImpl(SQLDialect, String, Schema, Package) -
Constructor for class org.jooq.impl.StoredProcedureImpl
-
- StoredProcedureImpl(Configuration, String, Schema) -
Constructor for class org.jooq.impl.StoredProcedureImpl
-
- StoredProcedureImpl(Configuration, String, Schema, Package) -
Constructor for class org.jooq.impl.StoredProcedureImpl
-
- StoreQuery<R extends TableRecord<R>> - Interface in org.jooq
- A query storing objects to the database.
- StringUtils - Class in org.jooq.impl
-
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
- substring(int) -
Method in interface org.jooq.Field
- Get the substring(field, startingPosition) function
This translates into any dialect
- substring(int, int) -
Method in interface org.jooq.Field
- Get the substring(field, startingPosition, length) function
This translates into any dialect
- subtract(Number) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.sub(Number) instead
- subtract(Field<? extends Number>) -
Method in interface org.jooq.Field
- Deprecated. - 1.5.8 - Use
Field.sub(Field) instead
- sum() -
Method in interface org.jooq.Field
- Get the sum over a numeric field: sum(field)
- sumOver() -
Method in interface org.jooq.Field
- The
sum(field) over ([analytic clause]) function.
- 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
Configuration. Use the other constructor instead.
TrueCondition anymore,
as of 1.5.7
Condition that will always evaluate to true
Query that can truncate a table in the database.UniqueKey is an object representing a UNIQUE KEY
or a PRIMARY KEY.UpdatableRecordImpl.UpdatableRecordImpl(UpdatableTable, Configuration) instead
Query that can update data in the database.Update's DSL API.Update's DSL API.UpdateQuery
Update's DSL API.Update's DSL API.Update's DSL API.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...])
- 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
-
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
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.
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 MATCHED THEN UPDATE clause to the
MERGE statement
0 literal.
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||