@NotNull Condition |
Condition.and(String sql) |
Combine this condition with another one using the Operator.AND
operator.
|
@NotNull Condition |
Condition.and(String sql,
Object... bindings) |
Combine this condition with another one using the Operator.AND
operator.
|
@NotNull Condition |
Condition.and(String sql,
QueryPart... parts) |
Combine this condition with another one using the Operator.AND
operator.
|
@NotNull Condition |
Condition.and(SQL sql) |
Combine this condition with another one using the Operator.AND
operator.
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator and proceed to the next step.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator.
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.and(String sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.and(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.and(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.and(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.AND operator
|
@NotNull CreateViewFinalStep |
CreateViewAsStep.as(String sql) |
Add an AS clause to the CREATE VIEW statement.
|
@NotNull CreateViewFinalStep |
CreateViewAsStep.as(String sql,
Object... bindings) |
Add an AS clause to the CREATE VIEW statement.
|
@NotNull CreateViewFinalStep |
CreateViewAsStep.as(String sql,
QueryPart... parts) |
Add an AS clause to the CREATE VIEW statement.
|
@NotNull CreateViewFinalStep |
CreateViewAsStep.as(SQL sql) |
Add an AS clause to the CREATE VIEW statement.
|
@NotNull BatchBindStep |
DSLContext.batch(String sql) |
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
@NotNull Batch |
DSLContext.batch(String... queries) |
Create a batch statement to execute a set of queries in batch mode
(without bind values).
|
@NotNull Batch |
DSLContext.batch(String sql,
Object[]... bindings) |
Create a batch statement to execute a set of queries in batch mode (with
bind values).
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(String sql) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(String sql,
Object... bindings) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(String sql,
QueryPart... parts) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectBy(SQL sql) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql,
Object... bindings) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(String sql,
QueryPart... parts) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectBy(SQL sql) |
Add an Oracle-specific CONNECT BY clause to the query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(String sql) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(String sql,
Object... bindings) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(String sql,
QueryPart... parts) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByAfterStartWithConditionStep<R> |
SelectConnectByAfterStartWithStep.connectByNoCycle(SQL sql) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql,
Object... bindings) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(String sql,
QueryPart... parts) |
Add an Oracle-specific CONNECT BY NOCYCLE clause to the
query
|
@NotNull SelectConnectByConditionStep<R> |
SelectConnectByStep.connectByNoCycle(SQL sql) |
Add an Oracle-specific CONNECT 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.
|
@NotNull Table<Record> |
Table.crossApply(String sql) |
CROSS APPLY a table to this table.
|
@NotNull Table<Record> |
Table.crossApply(String sql,
Object... bindings) |
CROSS APPLY a table to this table.
|
@NotNull Table<Record> |
Table.crossApply(String sql,
QueryPart... parts) |
CROSS APPLY a table to this table.
|
@NotNull Table<Record> |
Table.crossApply(SQL sql) |
CROSS APPLY a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.crossJoin(SQL sql) |
|
@NotNull Table<Record> |
Table.crossJoin(String sql) |
CROSS JOIN a table to this table.
|
@NotNull Table<Record> |
Table.crossJoin(String sql,
Object... bindings) |
CROSS JOIN a table to this table.
|
@NotNull Table<Record> |
Table.crossJoin(String sql,
QueryPart... parts) |
CROSS JOIN a table to this table.
|
@NotNull Table<Record> |
Table.crossJoin(SQL sql) |
CROSS JOIN a table to this table.
|
int |
DSLContext.execute(String sql) |
Execute a query holding plain SQL.
|
int |
DSLContext.execute(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(SQL sql) |
Execute a query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Result<Record> |
DSLContext.fetch(SQL sql) |
Execute a new query holding plain SQL.
|
@NotNull CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql) |
|
@NotNull CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
Object... bindings) |
|
@NotNull CompletionStage<Result<Record>> |
DSLContext.fetchAsync(String sql,
QueryPart... parts) |
|
@NotNull CompletionStage<Result<Record>> |
DSLContext.fetchAsync(Executor executor,
String sql) |
Fetch results in a new CompletionStage 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 new CompletionStage 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 new CompletionStage 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 new CompletionStage that is asynchronously
completed by a task running in the given executor.
|
@NotNull CompletionStage<Result<Record>> |
DSLContext.fetchAsync(SQL sql) |
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql,
Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Cursor<Record> |
DSLContext.fetchLazy(SQL sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Results |
DSLContext.fetchMany(String sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
DSLContext.fetchMany(String sql,
Object... bindings) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
DSLContext.fetchMany(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@NotNull Results |
DSLContext.fetchMany(SQL sql) |
Execute a new query holding plain SQL, possibly returning several result
sets.
|
@Nullable Record |
DSLContext.fetchOne(String sql) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@Nullable Record |
DSLContext.fetchOne(SQL sql) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql,
Object... bindings) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
DSLContext.fetchOptional(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL.
|
@NotNull Optional<Record> |
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.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql,
Object... bindings) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
DSLContext.fetchStream(String sql,
QueryPart... parts) |
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
@NotNull Stream<Record> |
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 a FILTER clause to the aggregate function.
|
@NotNull WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql,
Object... bindings) |
Add a FILTER clause to the aggregate function.
|
@NotNull WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(String sql,
QueryPart... parts) |
Add a FILTER clause to the aggregate function.
|
@NotNull WindowBeforeOverStep<T> |
AggregateFilterStep.filterWhere(SQL sql) |
Add a FILTER clause to the aggregate function.
|
@NotNull SelectJoinStep<R> |
SelectFromStep.from(String sql) |
Add a FROM clause to the query.
|
@NotNull SelectJoinStep<R> |
SelectFromStep.from(String sql,
Object... bindings) |
Add a FROM clause to the query.
|
@NotNull SelectJoinStep<R> |
SelectFromStep.from(String sql,
QueryPart... parts) |
Add a FROM clause to the query.
|
@NotNull SelectJoinStep<R> |
SelectFromStep.from(SQL sql) |
Add a FROM clause to the query.
|
@NotNull UpdateWhereStep<R> |
UpdateFromStep.from(String sql) |
Add a FROM clause to the query.
|
@NotNull UpdateWhereStep<R> |
UpdateFromStep.from(String sql,
Object... bindings) |
Add a FROM clause to the query.
|
@NotNull UpdateWhereStep<R> |
UpdateFromStep.from(String sql,
QueryPart... parts) |
Add a FROM clause to the query.
|
@NotNull UpdateWhereStep<R> |
UpdateFromStep.from(SQL sql) |
Add a FROM clause to the query.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullJoin(String sql) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullJoin(String sql,
Object... bindings) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullJoin(SQL sql) |
|
@NotNull TableOnStep<Record> |
Table.fullJoin(String sql) |
FULL OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.fullJoin(String sql,
Object... bindings) |
FULL OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.fullJoin(String sql,
QueryPart... parts) |
FULL OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.fullJoin(SQL sql) |
FULL OUTER JOIN a table to this table.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.fullOuterJoin(SQL sql) |
|
@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> |
SelectHavingStep.having(String sql) |
Add a HAVING clause to the query.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql,
Object... bindings) |
Add a HAVING clause to the query.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingStep.having(String sql,
QueryPart... parts) |
Add a HAVING clause to the query.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingStep.having(SQL sql) |
Add a HAVING clause to the query.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) .
|
@NotNull SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
Object... bindings) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.innerJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.innerJoin(SQL sql) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) .
|
@NotNull TableOnStep<Record> |
Table.innerJoin(String sql) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.innerJoin(String sql,
Object... bindings) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.innerJoin(String sql,
QueryPart... parts) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.innerJoin(SQL sql) |
INNER JOIN a table to this table.
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(String sql) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) .
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(String sql,
Object... bindings) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(String sql,
QueryPart... parts) |
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(Name name) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using
Table.join(Name) .
|
@NotNull SelectOnStep<R> |
SelectJoinStep.join(SQL sql) |
Convenience method to INNER JOIN a table to the last table
added to the FROM clause using Table.join(String) .
|
@NotNull TableOnStep<Record> |
Table.join(String sql) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.join(String sql,
Object... bindings) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.join(String sql,
QueryPart... parts) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.join(Name name) |
INNER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
Table.join(SQL sql) |
INNER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftJoin(SQL sql) |
|
@NotNull TablePartitionByStep<Record> |
Table.leftJoin(String sql) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.leftJoin(String sql,
Object... bindings) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.leftJoin(String sql,
QueryPart... parts) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.leftJoin(SQL sql) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
Object... bindings) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftJoin(String sql,
QueryPart... parts) |
LEFT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.leftJoin(SQL sql) |
LEFT OUTER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.leftOuterJoin(SQL sql) |
|
@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) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalFullOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalFullOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalFullOuterJoin(SQL sql) |
|
@NotNull Table<Record> |
Table.naturalFullOuterJoin(String sql) |
NATURAL FULL OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalFullOuterJoin(String sql,
Object... bindings) |
NATURAL FULL OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalFullOuterJoin(String sql,
QueryPart... parts) |
NATURAL FULL OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalFullOuterJoin(SQL sql) |
NATURAL FULL OUTER JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalJoin(SQL sql) |
|
@NotNull Table<Record> |
Table.naturalJoin(String sql) |
NATURAL JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalJoin(String sql,
Object... bindings) |
NATURAL JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalJoin(String sql,
QueryPart... parts) |
NATURAL JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalJoin(SQL sql) |
NATURAL JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalLeftOuterJoin(SQL sql) |
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(String sql) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(String sql,
Object... bindings) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(String sql,
QueryPart... parts) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(Name name) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalLeftOuterJoin(SQL sql) |
NATURAL LEFT OUTER JOIN a table to this table.
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinStep<R> |
SelectJoinStep.naturalRightOuterJoin(SQL sql) |
|
@NotNull Table<Record> |
Table.naturalRightOuterJoin(String sql) |
NATURAL RIGHT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalRightOuterJoin(String sql,
Object... bindings) |
NATURAL RIGHT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalRightOuterJoin(String sql,
QueryPart... parts) |
NATURAL RIGHT OUTER JOIN a table to this table.
|
@NotNull Table<Record> |
Table.naturalRightOuterJoin(SQL sql) |
NATURAL RIGHT OUTER JOIN a table to this table.
|
@NotNull DivideByOnConditionStep |
DivideByOnStep.on(String sql) |
Add a division condition to the DIVIDE BY clause
|
@NotNull DivideByOnConditionStep |
DivideByOnStep.on(String sql,
Object... bindings) |
Add a division condition to the DIVIDE BY clause
|
@NotNull DivideByOnConditionStep |
DivideByOnStep.on(String sql,
QueryPart... parts) |
Add a division condition to the DIVIDE BY clause
|
@NotNull DivideByOnConditionStep |
DivideByOnStep.on(SQL sql) |
Add a division condition to the DIVIDE BY clause
|
@NotNull MergeOnConditionStep<R> |
MergeOnStep.on(String sql) |
Provide join conditions and proceed to the next step
|
@NotNull MergeOnConditionStep<R> |
MergeOnStep.on(String sql,
Object... bindings) |
Provide join conditions and proceed to the next step
|
@NotNull MergeOnConditionStep<R> |
MergeOnStep.on(String sql,
QueryPart... parts) |
Provide join conditions and proceed to the next step
|
@NotNull MergeOnConditionStep<R> |
MergeOnStep.on(SQL sql) |
Provide join conditions and proceed to the next step
|
@NotNull SelectOnConditionStep<R> |
SelectOnStep.on(String sql) |
Add an ON clause to the previous JOIN .
|
@NotNull SelectOnConditionStep<R> |
SelectOnStep.on(String sql,
Object... bindings) |
Add an ON clause to the previous JOIN .
|
@NotNull SelectOnConditionStep<R> |
SelectOnStep.on(String sql,
QueryPart... parts) |
Add an ON clause to the previous JOIN .
|
@NotNull SelectOnConditionStep<R> |
SelectOnStep.on(SQL sql) |
Add an ON clause to the previous JOIN .
|
@NotNull TableOnConditionStep<R> |
TableOnStep.on(String sql) |
Add an ON clause to the JOIN .
|
@NotNull TableOnConditionStep<R> |
TableOnStep.on(String sql,
Object... bindings) |
Add an ON clause to the JOIN .
|
@NotNull TableOnConditionStep<R> |
TableOnStep.on(String sql,
QueryPart... parts) |
Add an ON clause to the JOIN .
|
@NotNull TableOnConditionStep<R> |
TableOnStep.on(SQL sql) |
Add an ON clause to the JOIN .
|
@NotNull Condition |
Condition.or(String sql) |
Combine this condition with another one using the Operator.OR
operator.
|
@NotNull Condition |
Condition.or(String sql,
Object... bindings) |
Combine this condition with another one using the Operator.OR
operator.
|
@NotNull Condition |
Condition.or(String sql,
QueryPart... parts) |
Combine this condition with another one using the Operator.OR
operator.
|
@NotNull Condition |
Condition.or(SQL sql) |
Combine this condition with another one using the Operator.OR
operator.
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull DeleteConditionStep<R> |
DeleteConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull DivideByOnConditionStep |
DivideByOnConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull MergeOnConditionStep<R> |
MergeOnConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectConditionStep<R> |
SelectConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectHavingConditionStep<R> |
SelectHavingConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectOnConditionStep<R> |
SelectOnConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator and proceed to the next step.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull TableOnConditionStep<R> |
TableOnConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator.
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.or(String sql) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.or(String sql,
Object... bindings) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.or(String sql,
QueryPart... parts) |
Combine the currently assembled conditions with another one using the
Operator.OR operator
|
@NotNull UpdateConditionStep<R> |
UpdateConditionStep.or(SQL sql) |
Combine the currently assembled conditions with another one using the
Operator.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.
|
@NotNull Table<Record> |
Table.outerApply(String sql) |
OUTER APPLY a table to this table.
|
@NotNull Table<Record> |
Table.outerApply(String sql,
Object... bindings) |
OUTER APPLY a table to this table.
|
@NotNull Table<Record> |
Table.outerApply(String sql,
QueryPart... parts) |
OUTER APPLY a table to this table.
|
@NotNull Table<Record> |
Table.outerApply(SQL sql) |
OUTER APPLY a table to this table.
|
@NotNull Queries |
Parser.parse(String sql) |
Parse a SQL string to a set of queries.
|
@NotNull Queries |
Parser.parse(String sql,
Object... bindings) |
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 |
Parser.parseName(String sql) |
Parse a SQL string to a name.
|
@NotNull Name |
Parser.parseName(String sql,
Object... bindings) |
Parse a SQL string with bind variables to a name.
|
@NotNull Query |
Parser.parseQuery(String sql) |
Parse a SQL string to a query.
|
@NotNull Query |
Parser.parseQuery(String sql,
Object... bindings) |
Parse a SQL string with bind variables to a query.
|
@NotNull ResultQuery<?> |
Parser.parseResultQuery(String sql) |
Parse a SQL string to a result query.
|
@NotNull ResultQuery<?> |
Parser.parseResultQuery(String sql,
Object... bindings) |
Parse a SQL string with bind variables to a result query.
|
@NotNull Row |
Parser.parseRow(String sql) |
Parse a SQL string to a row.
|
@NotNull Row |
Parser.parseRow(String sql,
Object... bindings) |
Parse a SQL string with bind variables to a row.
|
@NotNull Select<?> |
Parser.parseSelect(String sql) |
Parse a SQL string to a select statement.
|
@NotNull Select<?> |
Parser.parseSelect(String sql,
Object... bindings) |
Parse a SQL string to a select statement.
|
@NotNull Statement |
Parser.parseStatement(String sql) |
Parse a SQL string to a procedural statement.
|
@NotNull 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> |
SelectQualifyStep.qualify(String sql) |
Add a QUALIFY clause to the query.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyStep.qualify(String sql,
Object... bindings) |
Add a QUALIFY clause to the query.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyStep.qualify(String sql,
QueryPart... parts) |
Add a QUALIFY clause to the query.
|
@NotNull SelectQualifyConditionStep<R> |
SelectQualifyStep.qualify(SQL sql) |
Add a QUALIFY clause to the query.
|
@NotNull RowCountQuery |
DSLContext.query(String sql) |
Create a new query holding plain SQL.
|
@NotNull RowCountQuery |
DSLContext.query(String sql,
Object... bindings) |
Create a new query holding plain SQL.
|
@NotNull RowCountQuery |
DSLContext.query(String sql,
QueryPart... parts) |
Create a new query holding plain SQL.
|
@NotNull RowCountQuery |
DSLContext.query(SQL sql) |
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> |
SelectJoinStep.rightJoin(String sql) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightJoin(SQL sql) |
|
@NotNull TablePartitionByStep<Record> |
Table.rightJoin(String sql) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.rightJoin(String sql,
Object... bindings) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.rightJoin(String sql,
QueryPart... parts) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TablePartitionByStep<Record> |
Table.rightJoin(SQL sql) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
Object... bindings) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightJoin(String sql,
QueryPart... parts) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull TableOnStep<Record> |
TableOuterJoinStep.rightJoin(SQL sql) |
RIGHT OUTER JOIN a table to this table.
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql,
Object... bindings) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(String sql,
QueryPart... parts) |
|
@NotNull SelectJoinPartitionByStep<R> |
SelectJoinStep.rightOuterJoin(SQL sql) |
|
@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> |
SelectConnectByStep.startWith(String sql) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(String sql,
Object... bindings) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(String sql,
QueryPart... parts) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectConnectByAfterStartWithStep<R> |
SelectConnectByStep.startWith(SQL sql) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql,
Object... bindings) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectGroupByStep<R> |
SelectStartWithStep.startWith(String sql,
QueryPart... parts) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull SelectGroupByStep<R> |
SelectStartWithStep.startWith(SQL sql) |
Add an Oracle-specific START WITH clause to the query's
CONNECT BY clause.
|
@NotNull CreateTableFinalStep |
CreateTableStorageStep.storage(String sql) |
Add vendor-specific storage clauses to the CREATE TABLE statement.
|
@NotNull CreateTableFinalStep |
CreateTableStorageStep.storage(String sql,
Object... bindings) |
Add vendor-specific storage clauses to the CREATE TABLE statement.
|
@NotNull CreateTableFinalStep |
CreateTableStorageStep.storage(String sql,
QueryPart... parts) |
Add vendor-specific storage clauses to the CREATE TABLE
statement.
|
@NotNull CreateTableFinalStep |
CreateTableStorageStep.storage(SQL sql) |
Add vendor-specific storage clauses to the CREATE 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> |
DeleteUsingStep.using(String sql) |
Add a USING clause to the query.
|
@NotNull DeleteWhereStep<R> |
DeleteUsingStep.using(String sql,
Object... bindings) |
Add a USING clause to the query.
|
@NotNull DeleteWhereStep<R> |
DeleteUsingStep.using(String sql,
QueryPart... parts) |
Add a USING clause to the query.
|
@NotNull DeleteWhereStep<R> |
DeleteUsingStep.using(SQL sql) |
Add a USING clause to the query.
|
@NotNull MergeMatchedThenStep<R> |
MergeMatchedStep.whenMatchedAnd(String sql) |
Add the WHEN MATCHED AND clause to the
MERGE statement.
|
@NotNull MergeMatchedThenStep<R> |
MergeMatchedStep.whenMatchedAnd(String sql,
Object... bindings) |
Add the WHEN MATCHED AND clause to the
MERGE statement.
|
@NotNull MergeMatchedThenStep<R> |
MergeMatchedStep.whenMatchedAnd(String sql,
QueryPart... parts) |
Add the WHEN MATCHED AND clause to the MERGE
statement.
|
@NotNull MergeMatchedThenStep<R> |
MergeMatchedStep.whenMatchedAnd(SQL sql) |
Add the WHEN MATCHED AND clause to the
MERGE statement.
|
@NotNull CreateIndexFinalStep |
CreateIndexWhereStep.where(String sql) |
Add a WHERE clause to create a partial index.
|
@NotNull CreateIndexFinalStep |
CreateIndexWhereStep.where(String sql,
Object... bindings) |
Add a WHERE clause to create a partial index.
|
@NotNull CreateIndexFinalStep |
CreateIndexWhereStep.where(String sql,
QueryPart... parts) |
Add a WHERE clause to create a partial index.
|
@NotNull CreateIndexFinalStep |
CreateIndexWhereStep.where(SQL sql) |
Add a WHERE clause to create a partial index.
|
@NotNull DeleteConditionStep<R> |
DeleteWhereStep.where(String sql) |
Add conditions to the query.
|
@NotNull DeleteConditionStep<R> |
DeleteWhereStep.where(String sql,
Object... bindings) |
Add conditions to the query.
|
@NotNull DeleteConditionStep<R> |
DeleteWhereStep.where(String sql,
QueryPart... parts) |
Add conditions to the query.
|
@NotNull DeleteConditionStep<R> |
DeleteWhereStep.where(SQL sql) |
Add conditions to the query.
|
@NotNull InsertOnConflictDoUpdateStep<R> |
InsertOnConflictWhereIndexPredicateStep.where(String sql) |
Add a WHERE clause to supply an index predicate to the
INSERT statement's ON CONFLICT ... clause.
|
@NotNull InsertOnConflictDoUpdateStep<R> |
InsertOnConflictWhereIndexPredicateStep.where(String sql,
Object... bindings) |
Add a WHERE clause to supply an index predicate to the
INSERT statement's ON CONFLICT ... clause.
|
@NotNull InsertOnConflictDoUpdateStep<R> |
InsertOnConflictWhereIndexPredicateStep.where(String sql,
QueryPart... parts) |
Add a WHERE clause to supply an index predicate to the
INSERT statement's ON CONFLICT ... clause.
|
@NotNull InsertOnConflictDoUpdateStep<R> |
InsertOnConflictWhereIndexPredicateStep.where(SQL sql) |
Add a WHERE clause to supply an index predicate to the
INSERT statement's ON CONFLICT ... clause.
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictWhereStep.where(String sql) |
Add a WHERE clause to the INSERT statement's
ON DUPLICATE KEY UPDATE or ON CONFLICT ...
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictWhereStep.where(String sql,
Object... bindings) |
Add a WHERE clause to the INSERT statement's
ON DUPLICATE KEY UPDATE or ON CONFLICT ...
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictWhereStep.where(String sql,
QueryPart... parts) |
Add a WHERE clause to the INSERT statement's
ON DUPLICATE KEY UPDATE or ON CONFLICT ...
|
@NotNull InsertOnConflictConditionStep<R> |
InsertOnConflictWhereStep.where(SQL sql) |
Add a WHERE clause to the INSERT statement's
ON DUPLICATE KEY UPDATE or ON CONFLICT ...
|
@NotNull SelectConditionStep<R> |
SelectWhereStep.where(String sql) |
Add a WHERE clause to the query.
|
@NotNull SelectConditionStep<R> |
SelectWhereStep.where(String sql,
Object... bindings) |
Add a WHERE clause to the query.
|
@NotNull SelectConditionStep<R> |
SelectWhereStep.where(String sql,
QueryPart... parts) |
Add a WHERE clause to the query.
|
@NotNull SelectConditionStep<R> |
SelectWhereStep.where(SQL sql) |
Add a WHERE clause to the query.
|
@NotNull Table<R> |
Table.where(String sql) |
Add a WHERE clause to the table.
|
@NotNull Table<R> |
Table.where(String sql,
Object... bindings) |
Add a WHERE clause to the table.
|
@NotNull Table<R> |
Table.where(String sql,
QueryPart... parts) |
Add a WHERE clause to the table.
|
@NotNull Table<R> |
Table.where(SQL sql) |
Add a WHERE clause to the table.
|
@NotNull UpdateConditionStep<R> |
UpdateWhereStep.where(String sql) |
Add conditions to the query
|
@NotNull UpdateConditionStep<R> |
UpdateWhereStep.where(String sql,
Object... bindings) |
Add conditions to the query
|
@NotNull UpdateConditionStep<R> |
UpdateWhereStep.where(String sql,
QueryPart... parts) |
Add conditions to the query
|
@NotNull UpdateConditionStep<R> |
UpdateWhereStep.where(SQL sql) |
Add conditions to the query
|
@NotNull Table<R> |
Table.with(String hint) |
Specify a SQL Server style table hint for query optimisation.
|
@NotNull Table<R> |
Table.with(String hint,
Object... binds) |
Specify a SQL Server style table hint for query optimisation.
|
@NotNull Table<R> |
Table.with(String hint,
QueryPart... parts) |
Specify a SQL Server style table hint for query optimisation.
|
@NotNull Table<R> |
Table.with(SQL hint) |
Specify a SQL Server style table hint for query optimisation.
|