Uses of Annotation Interface
org.jooq.PlainSQL
Packages that use 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 ConditionCombine this condition with another one using theOperator.ANDoperator.@NotNull ConditionCombine this condition with another one using theOperator.ANDoperator.@NotNull ConditionCombine this condition with another one using theOperator.ANDoperator.@NotNull ConditionCombine this condition with another one using theOperator.ANDoperator.@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectConnectByConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator and proceed to the next step.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator.@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ANDoperator@NotNull CreateViewFinalStepAdd anASclause to theCREATE VIEWstatement.@NotNull CreateViewFinalStepAdd anASclause to theCREATE VIEWstatement.@NotNull CreateViewFinalStepAdd anASclause to theCREATE VIEWstatement.@NotNull CreateViewFinalStepAdd anASclause to theCREATE VIEWstatement.@NotNull BatchBindStepCreate a batch statement to execute a set of queries in batch mode (with bind values).@NotNull BatchCreate a batch statement to execute a set of queries in batch mode (without bind values).@NotNull BatchCreate a batch statement to execute a set of queries in batch mode (with bind values).@NotNull SelectConnectByAfterStartWithConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query@NotNull SelectConnectByConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByConditionStep<R>Add an Oracle-specificCONNECT BYclause to the query.@NotNull SelectConnectByAfterStartWithConditionStep<R>SelectConnectByAfterStartWithStep.connectByNoCycle(String sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByAfterStartWithConditionStep<R>SelectConnectByAfterStartWithStep.connectByNoCycle(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R>SelectConnectByStep.connectByNoCycle(String sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R>SelectConnectByStep.connectByNoCycle(String sql, Object... bindings) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R>SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectConnectByConditionStep<R>SelectConnectByStep.connectByNoCycle(SQL sql) Add an Oracle-specificCONNECT BY NOCYCLEclause to the query@NotNull SelectJoinStep<R>SelectJoinStep.crossApply(String sql) CROSS APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.crossApply(String sql, Object... bindings) CROSS APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.crossApply(String sql, QueryPart... parts) CROSS APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.crossApply(SQL sql) CROSS APPLYa table to this table.Table.crossApply(String sql) CROSS APPLYa table to this table.Table.crossApply(String sql, Object... bindings) CROSS APPLYa table to this table.Table.crossApply(String sql, QueryPart... parts) CROSS APPLYa table to this table.Table.crossApply(SQL sql) CROSS APPLYa table to this table.@NotNull SelectJoinStep<R>Convenience method toCROSS JOINa table to the last table added to theFROMclause usingTable.crossJoin(String)@NotNull SelectJoinStep<R>Convenience method toCROSS JOINa table to the last table added to theFROMclause usingTable.crossJoin(String, Object...)@NotNull SelectJoinStep<R>Convenience method toCROSS JOINa table to the last table added to theFROMclause usingTable.crossJoin(String, QueryPart...)@NotNull SelectJoinStep<R>Convenience method toCROSS JOINa table to the last table added to theFROMclause usingTable.crossJoin(String)CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.CROSS JOINa table to this table.intExecute a query holding plain SQL.intExecute a new query holding plain SQL.intExecute a new query holding plain SQL.intExecute 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 newCompletionStagethat 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 ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.@NotNull ResultsExecute a new query holding plain SQL, possibly returning several result sets.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute a new query holding plain SQL.@Nullable RecordExecute 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 RecordDSLContext.fetchSingle(String sql) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, Object... bindings) Execute a new query holding plain SQL.@NotNull RecordDSLContext.fetchSingle(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull RecordDSLContext.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 ObjectDSLContext.fetchValue(String sql) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.fetchValue(String sql, Object... bindings) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.fetchValue(String sql, QueryPart... parts) Execute a new query holding plain SQL.@Nullable ObjectDSLContext.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 clauseto the aggregate function.@NotNull WindowBeforeOverStep<T>AggregateFilterStep.filterWhere(String sql, Object... bindings) Add aFILTER clauseto the aggregate function.@NotNull WindowBeforeOverStep<T>AggregateFilterStep.filterWhere(String sql, QueryPart... parts) Add aFILTER clauseto the aggregate function.@NotNull WindowBeforeOverStep<T>AggregateFilterStep.filterWhere(SQL sql) Add aFILTER clauseto the aggregate function.@NotNull SelectJoinStep<R>Add aFROMclause to the query.@NotNull SelectJoinStep<R>Add aFROMclause to the query.@NotNull SelectJoinStep<R>Add aFROMclause to the query.@NotNull SelectJoinStep<R>Add aFROMclause to the query.@NotNull UpdateWhereStep<R>Add aFROMclause to the query.@NotNull UpdateWhereStep<R>Add aFROMclause to the query.@NotNull UpdateWhereStep<R>Add aFROMclause to the query.@NotNull UpdateWhereStep<R>Add aFROMclause to the query.@NotNull SelectOnStep<R>Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterJoin(String).@NotNull SelectOnStep<R>Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(String, Object...).@NotNull SelectOnStep<R>Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(String, QueryPart...).@NotNull SelectOnStep<R>Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterJoin(String).@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>FULL OUTER JOINa table to this table.@NotNull SelectOnStep<R>SelectJoinStep.fullOuterJoin(String sql) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterJoin(String)@NotNull SelectOnStep<R>SelectJoinStep.fullOuterJoin(String sql, Object... bindings) Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(String, Object...)@NotNull SelectOnStep<R>SelectJoinStep.fullOuterJoin(String sql, QueryPart... parts) Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(String, QueryPart...)@NotNull SelectOnStep<R>SelectJoinStep.fullOuterJoin(SQL sql) Convenience method toFULL OUTER JOINa table to the last table added to theFROMclause usingTable.fullOuterJoin(String)@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOINa table to this table.@NotNull TableOnStep<Record>Table.fullOuterJoin(SQL sql) FULL OUTER JOINa table to this table.@NotNull SelectHavingConditionStep<R>Add aHAVINGclause to the query.@NotNull SelectHavingConditionStep<R>Add aHAVINGclause to the query.@NotNull SelectHavingConditionStep<R>Add aHAVINGclause to the query.@NotNull SelectHavingConditionStep<R>Add aHAVINGclause to the query.@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String, Object...).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String, QueryPart...).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String).@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String, Object...).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String, QueryPart...).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(Name).@NotNull SelectOnStep<R>Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(String).@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull TableOnStep<Record>INNER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R>Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String).@NotNull SelectJoinPartitionByStep<R>Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String, Object...).@NotNull SelectJoinPartitionByStep<R>Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String, QueryPart...).@NotNull SelectJoinPartitionByStep<R>Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String).@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>LEFT OUTER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.leftOuterJoin(String sql) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.leftOuterJoin(String sql, Object... bindings) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String, Object...)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.leftOuterJoin(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String, QueryPart...)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.leftOuterJoin(SQL sql) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(String)@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.leftOuterJoin(SQL sql) LEFT OUTER JOINa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.naturalFullOuterJoin(String sql) Convenience method toNATURAL FULL OUTER JOINa table to the last table added to theFROMclause usingTable.naturalFullOuterJoin(String)@NotNull SelectJoinStep<R>SelectJoinStep.naturalFullOuterJoin(String sql, Object... bindings) Convenience method toNATURAL FULL OUTER JOINa table to the last table added to theFROMclause usingTable.naturalFullOuterJoin(String, Object...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalFullOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL FULL OUTER JOINa table to the last table added to theFROMclause usingTable.naturalFullOuterJoin(String, QueryPart...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalFullOuterJoin(SQL sql) Convenience method toNATURAL FULL OUTER JOINa table to the last table added to theFROMclause usingTable.naturalFullOuterJoin(String)Table.naturalFullOuterJoin(String sql) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(String sql, Object... bindings) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(String sql, QueryPart... parts) NATURAL FULL OUTER JOINa table to this table.Table.naturalFullOuterJoin(SQL sql) NATURAL FULL OUTER JOINa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.naturalJoin(String sql) Convenience method toNATURAL JOINa table to the last table added to theFROMclause usingTable.naturalJoin(String)@NotNull SelectJoinStep<R>SelectJoinStep.naturalJoin(String sql, Object... bindings) Convenience method toNATURAL JOINa table to the last table added to theFROMclause usingTable.naturalJoin(String, Object...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalJoin(String sql, QueryPart... parts) Convenience method toNATURAL JOINa table to the last table added to theFROMclause usingTable.naturalJoin(String, QueryPart...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalJoin(SQL sql) Convenience method toNATURAL JOINa table to the last table added to theFROMclause usingTable.naturalJoin(String)Table.naturalJoin(String sql) NATURAL JOINa table to this table.Table.naturalJoin(String sql, Object... bindings) NATURAL JOINa table to this table.Table.naturalJoin(String sql, QueryPart... parts) NATURAL JOINa table to this table.Table.naturalJoin(SQL sql) NATURAL JOINa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.naturalLeftOuterJoin(String sql) Convenience method toNATURAL LEFT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalLeftOuterJoin(String)@NotNull SelectJoinStep<R>SelectJoinStep.naturalLeftOuterJoin(String sql, Object... bindings) Convenience method toNATURAL LEFT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalLeftOuterJoin(String, Object...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalLeftOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL LEFT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalLeftOuterJoin(String, QueryPart...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalLeftOuterJoin(SQL sql) Convenience method toNATURAL LEFT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalLeftOuterJoin(String)Table.naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(String sql, QueryPart... parts) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(Name name) NATURAL LEFT OUTER JOINa table to this table.Table.naturalLeftOuterJoin(SQL sql) NATURAL LEFT OUTER JOINa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.naturalRightOuterJoin(String sql) Convenience method toNATURAL RIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalRightOuterJoin(String)@NotNull SelectJoinStep<R>SelectJoinStep.naturalRightOuterJoin(String sql, Object... bindings) Convenience method toNATURAL RIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalRightOuterJoin(String, Object...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalRightOuterJoin(String sql, QueryPart... parts) Convenience method toNATURAL RIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalRightOuterJoin(String, QueryPart...)@NotNull SelectJoinStep<R>SelectJoinStep.naturalRightOuterJoin(SQL sql) Convenience method toNATURAL RIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalRightOuterJoin(String)Table.naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOINa table to this table.Table.naturalRightOuterJoin(SQL sql) NATURAL RIGHT OUTER JOINa table to this table.@NotNull DivideByOnConditionStepAdd a division condition to theDIVIDE BYclause@NotNull DivideByOnConditionStepAdd a division condition to theDIVIDE BYclause@NotNull DivideByOnConditionStepAdd a division condition to theDIVIDE BYclause@NotNull DivideByOnConditionStepAdd a division condition to theDIVIDE BYclause@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 anONclause to the previousJOIN.@NotNull SelectOnConditionStep<R>Add anONclause to the previousJOIN.@NotNull SelectOnConditionStep<R>Add anONclause to the previousJOIN.@NotNull SelectOnConditionStep<R>Add anONclause to the previousJOIN.@NotNull TableOnConditionStep<R>Add anONclause to theJOIN.@NotNull TableOnConditionStep<R>Add anONclause to theJOIN.@NotNull TableOnConditionStep<R>Add anONclause to theJOIN.@NotNull TableOnConditionStep<R>Add anONclause to theJOIN.@NotNull ConditionCombine this condition with another one using theOperator.ORoperator.@NotNull ConditionCombine this condition with another one using theOperator.ORoperator.@NotNull ConditionCombine this condition with another one using theOperator.ORoperator.@NotNull ConditionCombine this condition with another one using theOperator.ORoperator.@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull DeleteConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull DivideByOnConditionStepCombine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull InsertOnConflictConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull MergeOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectHavingConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull SelectQualifyConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator and proceed to the next step.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull TableOnConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator.@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull UpdateConditionStep<R>Combine the currently assembled conditions with another one using theOperator.ORoperator@NotNull SelectJoinStep<R>SelectJoinStep.outerApply(String sql) OUTER APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.outerApply(String sql, Object... bindings) OUTER APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.outerApply(String sql, QueryPart... parts) OUTER APPLYa table to this table.@NotNull SelectJoinStep<R>SelectJoinStep.outerApply(SQL sql) OUTER APPLYa table to this table.Table.outerApply(String sql) OUTER APPLYa table to this table.Table.outerApply(String sql, Object... bindings) OUTER APPLYa table to this table.Table.outerApply(String sql, QueryPart... parts) OUTER APPLYa table to this table.Table.outerApply(SQL sql) OUTER APPLYa table to this table.@NotNull QueriesParse a SQL string to a set of queries.@NotNull QueriesParse a SQL string with bind variables to a set of queries.@NotNull ConditionParser.parseCondition(String sql) Parse a SQL string to a condition.@NotNull ConditionParser.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 NameParse a SQL string to a name.@NotNull NameParse a SQL string with bind variables to a name.@Nullable QueryParser.parseQuery(String sql) Parse a SQL string to a query.@Nullable QueryParser.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 RowParse a SQL string to a row.@NotNull RowParse 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 StatementParser.parseStatement(String sql) Parse a SQL string to a procedural statement.@Nullable StatementParser.parseStatement(String sql, Object... bindings) Parse a SQL string with bind variables to a procedural statement.@NotNull BlockParser.parseStatements(String sql) Parse a SQL string to a set of procedural statements.@NotNull BlockParser.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 aQUALIFYclause to the query.@NotNull SelectQualifyConditionStep<R>Add aQUALIFYclause to the query.@NotNull SelectQualifyConditionStep<R>Add aQUALIFYclause to the query.@NotNull SelectQualifyConditionStep<R>Add aQUALIFYclause to the query.@NotNull RowCountQueryCreate a new query holding plain SQL.@NotNull RowCountQueryCreate a new query holding plain SQL.@NotNull RowCountQueryCreate a new query holding plain SQL.@NotNull RowCountQueryCreate 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 JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String).@NotNull SelectJoinPartitionByStep<R>Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String, Object...).@NotNull SelectJoinPartitionByStep<R>Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String, QueryPart...).@NotNull SelectJoinPartitionByStep<R>Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String).@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>RIGHT OUTER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.rightOuterJoin(String sql) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.rightOuterJoin(String sql, Object... bindings) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String, Object...)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.rightOuterJoin(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String, QueryPart...)@NotNull SelectJoinPartitionByStep<R>SelectJoinStep.rightOuterJoin(SQL sql) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(String)@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record>Table.rightOuterJoin(SQL sql) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOINa table to this table.@NotNull TableOnStep<Record>TableOuterJoinStep.rightOuterJoin(SQL sql) RIGHT OUTER JOINa 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 WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectConnectByAfterStartWithStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull SelectGroupByStep<R>Add an Oracle-specificSTART WITHclause to the query'sCONNECT BYclause.@NotNull CreateTableFinalStepAdd vendor-specific storage clauses to theCREATE TABLEstatement.@NotNull CreateTableFinalStepAdd vendor-specific storage clauses to theCREATE TABLEstatement.@NotNull CreateTableFinalStepAdd vendor-specific storage clauses to theCREATE TABLEstatement.@NotNull CreateTableFinalStepAdd vendor-specific storage clauses to theCREATE TABLEstatement.@NotNull SelectOnStep<R>SelectJoinStep.straightJoin(String sql) STRAIGHT_JOINa table to this table.@NotNull SelectOnStep<R>SelectJoinStep.straightJoin(String sql, Object... bindings) STRAIGHT_JOINa table to this table.@NotNull SelectOnStep<R>SelectJoinStep.straightJoin(String sql, QueryPart... parts) STRAIGHT_JOINa table to this table.@NotNull SelectOnStep<R>SelectJoinStep.straightJoin(SQL sql) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(String sql) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(String sql, Object... bindings) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(String sql, QueryPart... parts) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(Name name) STRAIGHT_JOINa table to this table.@NotNull TableOnStep<Record>Table.straightJoin(SQL sql) STRAIGHT_JOINa table to this table.@NotNull DeleteWhereStep<R>Add aUSINGclause to the query.@NotNull DeleteWhereStep<R>Add aUSINGclause to the query.@NotNull DeleteWhereStep<R>Add aUSINGclause to the query.@NotNull DeleteWhereStep<R>Add aUSINGclause to the query.@NotNull CreateTriggerActionStepAdd theWHENclause to theCREATE TRIGGERstatement.@NotNull CreateTriggerActionStepAdd theWHENclause to theCREATE TRIGGERstatement.@NotNull CreateTriggerActionStepAdd theWHENclause to theCREATE TRIGGERstatement.@NotNull CreateTriggerActionStepAdd theWHENclause to theCREATE TRIGGERstatement.@NotNull MergeMatchedThenStep<R>MergeMatchedStep.whenMatchedAnd(String sql) Add theWHEN MATCHED ANDclause to theMERGEstatement.@NotNull MergeMatchedThenStep<R>MergeMatchedStep.whenMatchedAnd(String sql, Object... bindings) Add theWHEN MATCHED ANDclause to theMERGEstatement.@NotNull MergeMatchedThenStep<R>MergeMatchedStep.whenMatchedAnd(String sql, QueryPart... parts) Add theWHEN MATCHED ANDclause to theMERGEstatement.@NotNull MergeMatchedThenStep<R>MergeMatchedStep.whenMatchedAnd(SQL sql) Add theWHEN MATCHED ANDclause to theMERGEstatement.@NotNull CreateIndexFinalStepAdd theWHEREclause to theCREATE INDEXstatement.@NotNull CreateIndexFinalStepAdd theWHEREclause to theCREATE INDEXstatement.@NotNull CreateIndexFinalStepAdd theWHEREclause to theCREATE INDEXstatement.@NotNull CreateIndexFinalStepAdd theWHEREclause to theCREATE INDEXstatement.@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 aWHEREclause to supply an index predicate to theINSERTstatement'sON CONFLICT …clause.@NotNull InsertOnConflictDoUpdateStep<R>Add aWHEREclause to supply an index predicate to theINSERTstatement'sON CONFLICT …clause.@NotNull InsertOnConflictDoUpdateStep<R>Add aWHEREclause to supply an index predicate to theINSERTstatement'sON CONFLICT …clause.@NotNull InsertOnConflictDoUpdateStep<R>Add aWHEREclause to supply an index predicate to theINSERTstatement'sON CONFLICT …clause.@NotNull InsertOnConflictConditionStep<R>Add aWHEREclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull InsertOnConflictConditionStep<R>Add aWHEREclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull InsertOnConflictConditionStep<R>Add aWHEREclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull InsertOnConflictConditionStep<R>Add aWHEREclause to theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.@NotNull SelectConditionStep<R>Add aWHEREclause to the query.@NotNull SelectConditionStep<R>Add aWHEREclause to the query.@NotNull SelectConditionStep<R>Add aWHEREclause to the query.@NotNull SelectConditionStep<R>Add aWHEREclause to the query.Add aWHEREclause to the table.Add aWHEREclause to the table.Add aWHEREclause to the table.Add aWHEREclause 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
Methods in org.jooq.impl with annotations of type PlainSQLModifier 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 ConditionCreate a new condition holding plain SQL.static @NotNull ConditionCreate a new condition holding plain SQL.static @NotNull ConditionA custom SQL clause that can render arbitrary SQL elements.static @NotNull ConditionCreate 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 PrivilegeCreate a new privilege reference.static @NotNull RowCountQueryCreate a new query holding plain SQL.static @NotNull RowCountQueryCreate a new query holding plain SQL.static @NotNull RowCountQueryCreate a new query holding plain SQL.static @NotNull RowCountQueryCreate 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 SQLA custom SQL clause that can render arbitrary expressions.static @NotNull SQLA custom SQL clause that can render arbitrary expressions.static @NotNull SQLA custom SQL clause that can render arbitrary expressions.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA custom procedural fragment that can render arbitrary statements.static @NotNull StatementA 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.