Uses of Annotation Interface
org.jooq.PlainSQL
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of PlainSQL in org.jooq
Modifier and TypeMethodDescription@NotNull Condition
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
Combine this condition with another one using theOperator.AND
operator.@NotNull Condition
Combine this condition with another one using theOperator.AND
operator.@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull CreateViewFinalStep
Add anAS
clause to theCREATE VIEW
statement.@NotNull CreateViewFinalStep
Add anAS
clause to theCREATE VIEW
statement.@NotNull CreateViewFinalStep
Add anAS
clause to theCREATE VIEW
statement.@NotNull CreateViewFinalStep
Add anAS
clause to theCREATE VIEW
statement.@NotNull BatchBindStep
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (without bind values).@NotNull Batch
Create a batch statement to execute a set of queries in batch mode (with bind values).@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByConditionStep<R>
Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>
SelectConnectByAfterStartWithStep.connectByNoCycle
(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep<R>
SelectConnectByStep.connectByNoCycle
(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectJoinStep<R>
SelectJoinStep.crossApply
(String sql) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.crossApply
(String sql, Object... bindings) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.crossApply
(SQL sql) CROSS APPLY
a table to this table.Table.crossApply
(String sql) CROSS APPLY
a table to this table.Table.crossApply
(String sql, Object... bindings) CROSS APPLY
a table to this table.Table.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.Table.crossApply
(SQL sql) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, Object...)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String)
CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.CROSS JOIN
a table to this table.int
Execute a query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute a new query holding plain SQL.int
Execute a query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.Execute a new query holding plain SQL.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, Object... bindings) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, Object... bindings) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(Executor executor, SQL sql) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.@NotNull CompletionStage<Result<Record>>
DSLContext.fetchAsync
(SQL sql) Fetch results in a newCompletionStage
.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.@Nullable Record
Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, Object... bindings) Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, QueryPart... parts) Execute a new query holding plain SQL.DSLContext.fetchOptional
(SQL sql) Execute a new query holding plain SQL.@NotNull Optional<?>
DSLContext.fetchOptionalValue
(String sql) Execute a new query holding plain SQL.@NotNull Optional<?>
DSLContext.fetchOptionalValue
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Optional<?>
DSLContext.fetchOptionalValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Optional<?>
DSLContext.fetchOptionalValue
(SQL sql) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(SQL sql) Execute a new query holding plain SQL.DSLContext.fetchStream
(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.DSLContext.fetchStream
(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.@Nullable Object
DSLContext.fetchValue
(String sql) Execute a new query holding plain SQL.@Nullable Object
DSLContext.fetchValue
(String sql, Object... bindings) Execute a new query holding plain SQL.@Nullable Object
DSLContext.fetchValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@Nullable Object
DSLContext.fetchValue
(SQL sql) Execute a new query holding plain SQL.@NotNull List<?>
DSLContext.fetchValues
(String sql) Execute a new query holding plain SQL.@NotNull List<?>
DSLContext.fetchValues
(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull List<?>
DSLContext.fetchValues
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull List<?>
DSLContext.fetchValues
(SQL sql) Execute a new query holding plain SQL.@NotNull WindowBeforeOverStep<T>
AggregateFilterStep.filterWhere
(String sql) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep<T>
AggregateFilterStep.filterWhere
(String sql, Object... bindings) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep<T>
AggregateFilterStep.filterWhere
(String sql, QueryPart... parts) Add aFILTER clause
to the aggregate function.@NotNull WindowBeforeOverStep<T>
AggregateFilterStep.filterWhere
(SQL sql) Add aFILTER clause
to the aggregate function.@NotNull SelectJoinStep<R>
Add aFROM
clause to the query.@NotNull SelectJoinStep<R>
Add aFROM
clause to the query.@NotNull SelectJoinStep<R>
Add aFROM
clause to the query.@NotNull SelectJoinStep<R>
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
Add aFROM
clause to the query.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
.@NotNull TableOnStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterJoin
(String sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterJoin
(String sql, Object... bindings) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, Object...)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterJoin
(String sql, QueryPart... parts) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterJoin
(SQL sql) Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(String)
@NotNull TableOnStep<Record>
Table.fullOuterJoin
(String sql) FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.fullOuterJoin
(String sql, Object... bindings) FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.fullOuterJoin
(SQL sql) FULL OUTER JOIN
a table to this table.@NotNull SelectHavingConditionStep<R>
Add aHAVING
clause to the query.@NotNull SelectHavingConditionStep<R>
Add aHAVING
clause to the query.@NotNull SelectHavingConditionStep<R>
Add aHAVING
clause to the query.@NotNull SelectHavingConditionStep<R>
Add aHAVING
clause to the query.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, Object...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String)
.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterJoin
(String sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterJoin
(String sql, Object... bindings) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, Object...)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterJoin
(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterJoin
(SQL sql) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String)
@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql) LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, Object... bindings) LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.leftOuterJoin
(SQL sql) LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalFullOuterJoin
(String sql) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalFullOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalFullOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalFullOuterJoin
(SQL sql) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String)
Table.naturalFullOuterJoin
(String sql) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, Object... bindings) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(String sql, QueryPart... parts) NATURAL FULL OUTER JOIN
a table to this table.Table.naturalFullOuterJoin
(SQL sql) NATURAL FULL OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalJoin
(String sql) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalJoin
(String sql, Object... bindings) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, Object...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalJoin
(String sql, QueryPart... parts) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalJoin
(SQL sql) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String)
Table.naturalJoin
(String sql) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, Object... bindings) NATURAL JOIN
a table to this table.Table.naturalJoin
(String sql, QueryPart... parts) NATURAL JOIN
a table to this table.Table.naturalJoin
(SQL sql) NATURAL JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalLeftOuterJoin
(String sql) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalLeftOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalLeftOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalLeftOuterJoin
(SQL sql) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String)
Table.naturalLeftOuterJoin
(String sql) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, Object... bindings) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(Name name) NATURAL LEFT OUTER JOIN
a table to this table.Table.naturalLeftOuterJoin
(SQL sql) NATURAL LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalRightOuterJoin
(String sql) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalRightOuterJoin
(String sql, Object... bindings) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, Object...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalRightOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, QueryPart...)
@NotNull SelectJoinStep<R>
SelectJoinStep.naturalRightOuterJoin
(SQL sql) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String)
Table.naturalRightOuterJoin
(String sql) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN
a table to this table.Table.naturalRightOuterJoin
(SQL sql) NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull DivideByOnConditionStep
Add a division condition to theDIVIDE BY
clause@NotNull DivideByOnConditionStep
Add a division condition to theDIVIDE BY
clause@NotNull DivideByOnConditionStep
Add a division condition to theDIVIDE BY
clause@NotNull DivideByOnConditionStep
Add a division condition to theDIVIDE BY
clause@NotNull MergeOnConditionStep<R>
Provide join conditions and proceed to the next step@NotNull MergeOnConditionStep<R>
Provide join conditions and proceed to the next step@NotNull MergeOnConditionStep<R>
Provide join conditions and proceed to the next step@NotNull MergeOnConditionStep<R>
Provide join conditions and proceed to the next step@NotNull SelectOnConditionStep<R>
Add anON
clause to the previousJOIN
.@NotNull SelectOnConditionStep<R>
Add anON
clause to the previousJOIN
.@NotNull SelectOnConditionStep<R>
Add anON
clause to the previousJOIN
.@NotNull SelectOnConditionStep<R>
Add anON
clause to the previousJOIN
.@NotNull TableOnConditionStep<R>
Add anON
clause to theJOIN
.@NotNull TableOnConditionStep<R>
Add anON
clause to theJOIN
.@NotNull TableOnConditionStep<R>
Add anON
clause to theJOIN
.@NotNull TableOnConditionStep<R>
Add anON
clause to theJOIN
.@NotNull Condition
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
Combine this condition with another one using theOperator.OR
operator.@NotNull Condition
Combine this condition with another one using theOperator.OR
operator.@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull DeleteConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull TableOnConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull UpdateConditionStep<R>
Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull SelectJoinStep<R>
SelectJoinStep.outerApply
(String sql) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.outerApply
(String sql, Object... bindings) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.outerApply
(SQL sql) OUTER APPLY
a table to this table.Table.outerApply
(String sql) OUTER APPLY
a table to this table.Table.outerApply
(String sql, Object... bindings) OUTER APPLY
a table to this table.Table.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.Table.outerApply
(SQL sql) OUTER APPLY
a table to this table.@NotNull Queries
Parse a SQL string to a set of queries.@NotNull Queries
Parse a SQL string with bind variables to a set of queries.@NotNull Condition
Parser.parseCondition
(String sql) Parse a SQL string to a condition.@NotNull Condition
Parser.parseCondition
(String sql, Object... bindings) Parse a SQL string with bind variables to a condition.@NotNull Field<?>
Parser.parseField
(String sql) Parse a SQL string to a field.@NotNull Field<?>
Parser.parseField
(String sql, Object... bindings) Parse a SQL string with bind variables to a field.@NotNull Name
Parse a SQL string to a name.@NotNull Name
Parse a SQL string with bind variables to a name.@Nullable Query
Parser.parseQuery
(String sql) Parse a SQL string to a query.@Nullable Query
Parser.parseQuery
(String sql, Object... bindings) Parse a SQL string with bind variables to a query.@Nullable ResultQuery<?>
Parser.parseResultQuery
(String sql) Parse a SQL string to a result query.@Nullable ResultQuery<?>
Parser.parseResultQuery
(String sql, Object... bindings) Parse a SQL string with bind variables to a result query.@NotNull Row
Parse a SQL string to a row.@NotNull Row
Parse a SQL string with bind variables to a row.@Nullable Select<?>
Parser.parseSelect
(String sql) Parse a SQL string to a select statement.@Nullable Select<?>
Parser.parseSelect
(String sql, Object... bindings) Parse a SQL string to a select statement.@Nullable Statement
Parser.parseStatement
(String sql) Parse a SQL string to a procedural statement.@Nullable Statement
Parser.parseStatement
(String sql, Object... bindings) Parse a SQL string with bind variables to a procedural statement.@NotNull Block
Parser.parseStatements
(String sql) Parse a SQL string to a set of procedural statements.@NotNull Block
Parser.parseStatements
(String sql, Object... bindings) Parse a SQL string with bind variables to a set of procedural statements.@NotNull Table<?>
Parser.parseTable
(String sql) Parse a SQL string to a table.@NotNull Table<?>
Parser.parseTable
(String sql, Object... bindings) Parse a SQL string with bind variables to a table.@NotNull SelectQualifyConditionStep<R>
Add aQUALIFY
clause to the query.@NotNull SelectQualifyConditionStep<R>
Add aQUALIFY
clause to the query.@NotNull SelectQualifyConditionStep<R>
Add aQUALIFY
clause to the query.@NotNull SelectQualifyConditionStep<R>
Add aQUALIFY
clause to the query.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull RowCountQuery
Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext.resultQuery
(SQL sql) Create a new query holding plain SQL.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterJoin
(String sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterJoin
(String sql, Object... bindings) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, Object...)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterJoin
(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterJoin
(SQL sql) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String)
@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql) RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, Object... bindings) RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep.rightOuterJoin
(SQL sql) RIGHT OUTER JOIN
a table to this table.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectConnectByAfterStartWithStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep<R>
Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull CreateTableFinalStep
Add theSTORAGE
clause to theCREATE TABLE
statement.@NotNull CreateTableFinalStep
Add theSTORAGE
clause to theCREATE TABLE
statement.@NotNull CreateTableFinalStep
Add theSTORAGE
clause to theCREATE TABLE
statement.@NotNull CreateTableFinalStep
Add theSTORAGE
clause to theCREATE TABLE
statement.@NotNull SelectOnStep<R>
SelectJoinStep.straightJoin
(String sql) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep.straightJoin
(String sql, Object... bindings) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep.straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep.straightJoin
(SQL sql) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(String sql) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(String sql, Object... bindings) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(Name name) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(SQL sql) STRAIGHT_JOIN
a table to this table.@NotNull DeleteWhereStep<R>
Add aUSING
clause to the query.@NotNull DeleteWhereStep<R>
Add aUSING
clause to the query.@NotNull DeleteWhereStep<R>
Add aUSING
clause to the query.@NotNull DeleteWhereStep<R>
Add aUSING
clause to the query.@NotNull CreateTriggerActionStep
Add theWHEN
clause to theCREATE TRIGGER
statement.@NotNull CreateTriggerActionStep
Add theWHEN
clause to theCREATE TRIGGER
statement.@NotNull CreateTriggerActionStep
Add theWHEN
clause to theCREATE TRIGGER
statement.@NotNull CreateTriggerActionStep
Add theWHEN
clause to theCREATE TRIGGER
statement.@NotNull MergeMatchedThenStep<R>
MergeMatchedStep.whenMatchedAnd
(String sql) Add theWHEN MATCHED AND
clause to theMERGE
statement.@NotNull MergeMatchedThenStep<R>
MergeMatchedStep.whenMatchedAnd
(String sql, Object... bindings) Add theWHEN MATCHED AND
clause to theMERGE
statement.@NotNull MergeMatchedThenStep<R>
MergeMatchedStep.whenMatchedAnd
(String sql, QueryPart... parts) Add theWHEN MATCHED AND
clause to theMERGE
statement.@NotNull MergeMatchedThenStep<R>
MergeMatchedStep.whenMatchedAnd
(SQL sql) Add theWHEN MATCHED AND
clause to theMERGE
statement.@NotNull CreateIndexFinalStep
Add theWHERE
clause to theCREATE INDEX
statement.@NotNull CreateIndexFinalStep
Add theWHERE
clause to theCREATE INDEX
statement.@NotNull CreateIndexFinalStep
Add theWHERE
clause to theCREATE INDEX
statement.@NotNull CreateIndexFinalStep
Add theWHERE
clause to theCREATE INDEX
statement.@NotNull DeleteConditionStep<R>
Add conditions to the query.@NotNull DeleteConditionStep<R>
Add conditions to the query.@NotNull DeleteConditionStep<R>
Add conditions to the query.@NotNull DeleteConditionStep<R>
Add conditions to the query.@NotNull InsertOnConflictDoUpdateStep<R>
Add aWHERE
clause to supply an index predicate to theINSERT
statement'sON CONFLICT …
clause.@NotNull InsertOnConflictDoUpdateStep<R>
Add aWHERE
clause to supply an index predicate to theINSERT
statement'sON CONFLICT …
clause.@NotNull InsertOnConflictDoUpdateStep<R>
Add aWHERE
clause to supply an index predicate to theINSERT
statement'sON CONFLICT …
clause.@NotNull InsertOnConflictDoUpdateStep<R>
Add aWHERE
clause to supply an index predicate to theINSERT
statement'sON CONFLICT …
clause.@NotNull InsertOnConflictConditionStep<R>
Add aWHERE
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull InsertOnConflictConditionStep<R>
Add aWHERE
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull InsertOnConflictConditionStep<R>
Add aWHERE
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull InsertOnConflictConditionStep<R>
Add aWHERE
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull SelectConditionStep<R>
Add aWHERE
clause to the query.@NotNull SelectConditionStep<R>
Add aWHERE
clause to the query.@NotNull SelectConditionStep<R>
Add aWHERE
clause to the query.@NotNull SelectConditionStep<R>
Add aWHERE
clause to the query.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Add aWHERE
clause to the table.Add aWHERE
clause to the table.@NotNull UpdateConditionStep<R>
Add conditions to the query@NotNull UpdateConditionStep<R>
Add conditions to the query@NotNull UpdateConditionStep<R>
Add conditions to the query@NotNull UpdateConditionStep<R>
Add conditions to the querySpecify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation.Specify a SQL Server style table hint for query optimisation. -
Uses of PlainSQL in org.jooq.impl
Modifier and TypeMethodDescriptionstatic <T> @NotNull AggregateFunction<T>
aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
DSL.aggregateDistinct
(String name, Class<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
DSL.aggregateDistinct
(String name, DataType<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static @NotNull Condition
Create a new condition holding plain SQL.static @NotNull Condition
Create a new condition holding plain SQL.static @NotNull Condition
A custom SQL clause that can render arbitrary SQL elements.static @NotNull Condition
Create a new condition holding plain SQL.Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
A custom SQL clause that can render arbitrary SQL elements.Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.A custom SQL clause that can render arbitrary SQL elements.Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
Create a "plain SQL" field.static <T> @NotNull Field<T>
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field<T>
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static @NotNull Privilege
Create a new privilege reference.static @NotNull RowCountQuery
Create a new query holding plain SQL.static @NotNull RowCountQuery
Create a new query holding plain SQL.static @NotNull RowCountQuery
Create a new query holding plain SQL.static @NotNull RowCountQuery
Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL.resultQuery
(String sql) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL.resultQuery
(SQL sql) Create a new query holding plain SQL.static @NotNull SelectWhereStep<Record>
DSL.selectFrom
(String sql) Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL.selectFrom
(String sql, Object... bindings) Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL.selectFrom
(SQL sql) Create a new DSL select statement, projecting*
.static @NotNull Sequence<BigInteger>
Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6162] - UseDSL.sequence(Name, Class)
instead.Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6162] - UseDSL.sequence(Name, DataType)
instead.static @NotNull SQL
A custom SQL clause that can render arbitrary expressions.static @NotNull SQL
A custom SQL clause that can render arbitrary expressions.static @NotNull SQL
A custom SQL clause that can render arbitrary expressions.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.A custom SQL clause that can render arbitrary table expressions.
DSL.sequence(Name)
instead.