|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
Field.between(Object, Object) instead
Field.equal(Object) instead
Field.equal(Object),
Field.notEqual(Object), etc instead
Operator.AND
Operator.AND
SelectQuery.addHaving(Condition...) instead
SelectQuery.addHaving(Condition...) instead
Field.in(Collection) instead
Field.in(Object...) instead
SelectQuery.addJoin(TableLike, Condition...) instead
SelectQuery.addJoin(TableLike, JoinType, Condition...)
instead
OrderProvider.addLimit(int, int) with offset = 0
Field.isNotNull() instead
Field.isNull() instead
QueryPart that can create an aliased QueryPart of itselfOperator.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.
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 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 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.
SELECT y.*, (SELECT a FROM x) FROM y
SELECT y.*, (SELECT a FROM x) [alias] FROM y
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 ...
- 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)
this between minValue and maxValue
this between minValue and maxValue
Field.between(Object, Object) instead
QueryPartInternal.bind(Configuration, PreparedStatement)
instead
QueryPartInternal.bind(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 DECODE
Condition.and(Condition) instead
Condition.and(Condition) instead
Condition.and(Condition) instead
Condition.and(Condition) or
Condition.or(Condition) instead
Field.equal(Object) instead
Field.equal(Object) or any similar one instead
DataType from the provided Java
type <T>.
value as type in a
PreparedStatement.
Factory.constants(Object...) instead
<T>
Array from this ArrayRecord
This method is for INTERNAL use only.
ARRAY
Factory's underlying JDBC Connection
ResultSet.Condition implementations in client code.Field implementations in client code.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 ("").
- delete() -
Method in class org.jooq.impl.UpdatableRecordImpl
-
- delete() -
Method in interface org.jooq.UpdatableRecord
- Deletes this record from the database.
- 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
- 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
- descending() -
Method in interface org.jooq.Field
- Create a descending sort field from this
- 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
-
- divide(Number) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
- divide(Field<? extends Number>) -
Method in interface org.jooq.Field
- An arithmetic expression dividing this by value
- 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_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.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>, Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeDelete(Table, Condition) instead
- executeDelete(Table<R>, Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeDeleteOne(Table, Condition) instead
- 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>, Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeDeleteOne(Table, Condition) instead
- executeDeleteOne(Table<R>, Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeDeleteOne(Table, Condition) instead
- 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, Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeUpdate(Table, TableRecord, Condition)
instead
- executeUpdate(Table<R>, R, Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeUpdateOne(Table, TableRecord, Condition)
instead
- 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, Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeUpdateOne(Table, TableRecord, Condition)
instead
- executeUpdateOne(Table<R>, R, Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Factory.executeUpdateOne(Table, TableRecord, Condition)
instead
- 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.
- 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]
Factory.fetch(Table, Condition) instead
Factory.fetch(Table, Condition) instead
SELECT * FROM [table] WHERE [condition]
Query.execute() and then
Select.getResult()
SELECT * FROM [table] WHERE [field] IN [values]
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]
Factory.fetchOne(Table, Condition) instead
Factory.fetchOne(Table, Condition) instead
SELECT * FROM [table] WHERE [condition]
QueryPart) that holds a list of
Fields.#getvalueAsBigDecimal(Field) instead
#getvalueAsBigDecimal(Field, BigDecimal)
instead
#getvalueAsBigInteger(Field) instead
#getvalueAsBigInteger(Field, BigInteger)
instead
Record.getValueAsByte(Field) instead
Record.getValueAsByte(Field, Byte) instead
AttachableInternal
internal API, soon. Do not reference directly.
#getvalueAsDate(Field) instead
#getvalueAsDate(Field, Date) instead
SQLDialect
QueryPartInternal
anymore
#getvalueAsDouble(Field) instead
#getvalueAsDouble(Field, Double) instead
Factory without a Connection
Factory with a Connection
#getvalueAsFloat(Field) instead
#getvalueAsFloat(Field, Float) instead
#getvalueAsInteger(Field) instead
#getvalueAsInteger(Field, Integer) instead
List
#getvalueAsLong(Field) instead
#getvalueAsLong(Field, Long) instead
Updatable.getMainUniqueKey() instead
Adapter type hiding the internal API. Do not
reference this type anymore. Reference QueryPart
instead.
Record
Record
#getvalueAsShort(Field) instead
#getvalueAsShort(Field, Short) instead
Types value
Record.getValueAsString(Field) instead
Record.getValueAsString(Field, String) instead
#getvalueAsTimestamp(Field) instead
#getvalueAsTimestamp(Field, Timestamp) instead
#getvalueAsTime(Field) instead
#getvalueAsTime(Field, Time) instead
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 (SelectgroupBy(Field<?>...) -
Method in interface org.jooq.SelectGroupByStep
- Add grouping to the query and proceed to the next step
- groupBy(Collection<Field<?>>) -
Method in interface org.jooq.SelectGroupByStep
- Add grouping to the query and proceed to the next step
SQLDialect.H2 dialectSQLDialect.H2 specific factorySQLDialect.HSQLDB dialectSQLDialect.HSQLDB specific factorythis 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...)
- inCondition(Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.in(Object...) instead
- inCondition(Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.in(Collection) instead
- 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
-
- 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
- Create a new
InsertSelectQuery
- InsertQuery<R extends TableRecord<R>> - Interface in org.jooq
- A query for data insertion
- InsertSelectQuery<R extends TableRecord<R>> - Interface in org.jooq
- A query of the type
INSERT INTO [x] SELECT ...- 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
-
- 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.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
-
- 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.
- 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
-
Field.equal(Field) instead
Field.equal(Field) instead, or any similar
method.
SelectJoinStep.leftOuterJoin(TableLike) instead
SelectJoinStep.leftOuterJoin(String) instead
SelectJoinStep.leftOuterJoin(String, Object...) instead
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
- LONG -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- LONGBLOB -
Static variable in class org.jooq.util.h2.H2DataType
-
- LONGBLOB -
Static variable in class org.jooq.util.mysql.MySQLDataType
-
- 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
-
- 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.sqlite.SQLiteDataType
-
- 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
SQLDialect.MYSQL dialectSQLDialect.MYSQL specific factoryRecord that can be inserted into the corresponding
table.
Factory's underlying JDBC Connection
Condition.not() instead
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...)
- notInCondition(Field<T>, Collection<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.notIn(Collection) instead
- notInCondition(Field<T>, T...) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.notIn(Object...) instead
- notLike(T) -
Method in interface org.jooq.Field
this not like value
- notNullCondition(Field<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.isNotNull() instead
- NTEXT -
Static variable in class org.jooq.util.h2.H2DataType
-
- 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.
- nullCondition(Field<T>) -
Method in class org.jooq.impl.Factory
- Deprecated. - Use
Field.isNull() instead
- 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
- 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
-
- NVARCHAR -
Static variable in class org.jooq.util.h2.H2DataType
-
- NVARCHAR -
Static variable in class org.jooq.util.oracle.OracleDataType
-
- NVARCHAR -
Static variable in class org.jooq.util.sqlite.SQLiteDataType
-
- 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(T, T) -
Method in interface org.jooq.Field
- Gets the Oracle-style NVL2(value, valueIfNotNull, valueIfNull) function
- nvl2(Field<T>, Field<T>) -
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
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.
SQLDialect.ORACLE dialectSQLDialect.ORACLE specific factorySQLDialect.ORACLE
This class has a hidden dependency on the Oracle JDBC driver.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.
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 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.
SQLDialect.POSTGRES dialectSQLDialect.POSTGRES specific factoryAdapter type hiding the internal API. Do not reference
this type anymore. Reference QueryPart instead.SelectQuerySelectQuerySelectJoinStep.rightOuterJoin(TableLike) instead
SelectJoinStep.rightOuterJoin(String) instead
SelectJoinStep.rightOuterJoin(String, Object...) instead
Schema.
Factory create = new Factory();
create.select(value1, value2)
.from(table1)
.join(table2).on(field1.equal(field2))
.where(field1.greaterThan(100))
.orderBy(field2);
query.execute(connection);
Query that can provide a Result after executionSelect 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.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 conditions to a
query.List
SimpleSelect query, where additional conditions can be
added to the where clause.SimpleSelect querySimpleSelect query
This is the final step in query construction, where you can add a limit
clause to a query.SimpleSelect query
This is the step in query construction, where you can add a order by clause
to a query.SimpleSelect query
This is the step in query construction, where you can add conditions to a
query.Configuration.getDialect()SQLDialect.SQLITE dialectSQLDialect.SQLITE specific factoryStore and ArrayStore 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.String that are null safe.Configuration. Use the other constructor instead.
QueryPartInternal.toSQLDeclaration(Configuration) instead
QueryPartInternal.toSQLDeclaration(Configuration, boolean)
instead
QueryPartInternal.toSQLReference(Configuration) instead
QueryPartInternal.toSQLReference(Configuration, boolean)
instead
TrueCondition anymore,
as of 1.5.7
Condition that will always evaluate to true
UpdatableRecordImpl.UpdatableRecordImpl(UpdatableTable, Configuration) instead
UpdateQuery
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
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
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||