Uses of Interface
org.jooq.TableLike
-
Packages that use TableLike Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes. -
-
Uses of TableLike in org.jooq
Subinterfaces of TableLike in org.jooq Modifier and Type Interface Description interface
CommonTableExpression<R extends Record>
A common table expression.interface
JSONTableColumnPathStep
A step in the construction of anJSON_TABLE
expression.interface
JSONTableColumnsStep
A step in the construction of anJSON_TABLE
expression.interface
Select<R extends Record>
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,T1>
interface
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
interface
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
interface
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
interface
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
interface
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
interface
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
interface
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
interface
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
interface
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
interface
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
interface
SelectSeekStep2<R extends Record,T1,T2>
interface
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
interface
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
interface
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
interface
SelectSeekStep3<R extends Record,T1,T2,T3>
interface
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
interface
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
interface
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
interface
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
interface
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
interface
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
Table<R extends Record>
A table.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
XMLTableColumnPathStep
A step in the construction of anXMLTABLE
expression.interface
XMLTableColumnsStep
A step in the construction of anXMLTABLE
expression.Methods in org.jooq with parameters of type TableLike Modifier and Type Method Description void
SelectQuery. addFrom(TableLike<?> from)
Add tables to the table product.void
SelectQuery. addFrom(TableLike<?>... from)
Add tables to the table product.void
UpdateQuery. addFrom(TableLike<?> from)
Add tables to the table product.void
UpdateQuery. addFrom(TableLike<?>... from)
Add tables to the table product.void
SelectQuery. addJoin(TableLike<?> table, Condition condition)
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery. addJoin(TableLike<?> table, Condition... conditions)
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery. addJoin(TableLike<?> table, JoinType type, Condition condition)
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery. addJoin(TableLike<?> table, JoinType type, Condition... conditions)
Joins the existing table product to a new table using a condition, connecting them with each other withOperator.AND
.void
SelectQuery. addJoin(TableLike<?> table, JoinType type, Condition[] conditions, Field<?>[] partitionBy)
Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery. addJoin(TableLike<?> table, JoinType type, Condition conditions, Field<?>[] partitionBy)
Joins the existing table product to a new table using conditions, connecting them with each other withOperator.AND
.void
SelectQuery. addJoinOnKey(TableLike<?> table, JoinType type)
Joins the existing table product to a new table using a foreign key.void
SelectQuery. addJoinOnKey(TableLike<?> table, JoinType type, ForeignKey<?,?> key)
Joins the existing table product to a new table using a foreign key.void
SelectQuery. addJoinOnKey(TableLike<?> table, JoinType type, TableField<?,?>... keyFields)
Joins the existing table product to a new table using a foreign key.void
SelectQuery. addJoinUsing(TableLike<?> table, Collection<? extends Field<?>> fields)
Joins the existing table product to a new table with aUSING
clause.void
SelectQuery. addJoinUsing(TableLike<?> table, JoinType type, Collection<? extends Field<?>> fields)
Joins the existing table product to a new table with aUSING
clause.void
DeleteQuery. addUsing(TableLike<?> table)
Add tables to theUSING
clause.void
DeleteQuery. addUsing(TableLike<?>... tables)
Add tables to theUSING
clause.@NotNull SelectJoinStep<R>
SelectJoinStep. crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep. crossJoin(TableLike<?> table)
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(TableLike)
@NotNull Table<Record>
Table. crossJoin(TableLike<?> table)
CROSS JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectFromStep. from(TableLike<?> table)
Add aFROM
clause to the query.@NotNull SelectJoinStep<R>
SelectFromStep. from(TableLike<?>... tables)
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
UpdateFromStep. from(TableLike<?> table)
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
UpdateFromStep. from(TableLike<?>... table)
Add aFROM
clause to the query.@NotNull SelectOnStep<R>
SelectJoinStep. fullJoin(TableLike<?> table)
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
.@NotNull TableOnStep<Record>
Table. fullJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep. fullOuterJoin(TableLike<?> table)
Convenience method toFULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.fullOuterJoin(TableLike)
@NotNull TableOnStep<Record>
Table. fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep. innerJoin(TableLike<?> table)
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.@NotNull TableOnStep<Record>
Table. innerJoin(TableLike<?> table)
INNER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep. join(TableLike<?> table)
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(TableLike)
.@NotNull SelectOptionalOnStep<R>
SelectJoinStep. join(TableLike<?> table, JoinType type)
Convenience method to join a table to the last table added to theFROM
clause usingTable.join(TableLike, JoinType)
@NotNull TableOnStep<Record>
Table. join(TableLike<?> table)
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
@NotNull TableOnStep<Record>
TableOuterJoinStep. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
.@NotNull SelectOnStep<R>
SelectJoinStep. leftAntiJoin(TableLike<?> table)
A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.@NotNull TableOnStep<R>
Table. leftAntiJoin(TableLike<?> table)
A syntheticLEFT ANTI JOIN
clause that translates to an equivalentNOT EXISTS
predicate.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep. leftJoin(TableLike<?> table)
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
.@NotNull TablePartitionByStep<Record>
Table. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep. leftOuterJoin(TableLike<?> table)
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(TableLike)
@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep. leftSemiJoin(TableLike<?> table)
A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.@NotNull TableOnStep<R>
Table. leftSemiJoin(TableLike<?> table)
A syntheticLEFT SEMI JOIN
clause that translates to an equivalentEXISTS
predicate.@NotNull SelectJoinStep<R>
SelectJoinStep. naturalFullOuterJoin(TableLike<?> table)
Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(TableLike)
@NotNull Table<Record>
Table. naturalFullOuterJoin(TableLike<?> table)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep. naturalJoin(TableLike<?> table)
Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(TableLike)
@NotNull Table<Record>
Table. naturalJoin(TableLike<?> table)
NATURAL JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep. naturalLeftOuterJoin(TableLike<?> table)
Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(TableLike)
@NotNull Table<Record>
Table. naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep. naturalRightOuterJoin(TableLike<?> table)
Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(TableLike)
@NotNull Table<Record>
Table. naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep. outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep. rightJoin(TableLike<?> table)
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
.@NotNull TablePartitionByStep<Record>
Table. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep. rightOuterJoin(TableLike<?> table)
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(TableLike)
@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.<R extends Record>
@NotNull SelectQuery<R>DSLContext. selectQuery(TableLike<R> table)
Create a newSelectQuery
@NotNull SelectOnStep<R>
SelectJoinStep. straightJoin(TableLike<?> table)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(TableLike<?> table)
STRAIGHT_JOIN
a table to this table.@NotNull DeleteWhereStep<R>
DeleteUsingStep. using(TableLike<?> table)
Add aUSING
clause to the query.@NotNull DeleteWhereStep<R>
DeleteUsingStep. using(TableLike<?>... tables)
Add aUSING
clause to the query.@NotNull MergeOnStep<R>
MergeUsingStep. using(TableLike<?> table)
Add theUSING
clause to the SQL standardMERGE
statement.Method parameters in org.jooq with type arguments of type TableLike Modifier and Type Method Description void
SelectQuery. addFrom(Collection<? extends TableLike<?>> from)
Add tables to the table product.void
UpdateQuery. addFrom(Collection<? extends TableLike<?>> from)
Add tables to the table product.void
DeleteQuery. addUsing(Collection<? extends TableLike<?>> tables)
Add tables to theUSING
clause.@NotNull SelectJoinStep<R>
SelectFromStep. from(Collection<? extends TableLike<?>> tables)
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
UpdateFromStep. from(Collection<? extends TableLike<?>> tables)
Add aFROM
clause to the query.@NotNull DeleteWhereStep<R>
DeleteUsingStep. using(Collection<? extends TableLike<?>> tables)
Add aUSING
clause to the query. -
Uses of TableLike in org.jooq.impl
Classes in org.jooq.impl that implement TableLike Modifier and Type Class Description class
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
TableImpl<R extends Record>
A common base type for tablesMethods in org.jooq.impl with parameters of type TableLike Modifier and Type Method Description static <R extends Record>
@NotNull Table<R>DSL. lateral(TableLike<R> table)
Create aLATERAL
joined table.<R extends Record>
SelectQuery<R>DefaultDSLContext. selectQuery(TableLike<R> table)
-