Module org.jooq

Package org.jooq

Interface CommonTableExpression<R extends Record>

All Superinterfaces:

Fields, GroupField, Named, Qualified, QueryPart, RecordQualifier<R>, Serializable, Table<R>, TableLike<R>

public interface CommonTableExpression<R extends Record>
extends Table<R>

A common table expression.

A common table expression is a table that can be supplied to WITH clauses. It may or may not be defined recursively.

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 Table<?> t = name("t").fields("v").as(select(one()));

 using(configuration)
    .select()
    .from(t)
    .fetch();
 

Instances can be created using Name#as(Select).

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull DerivedColumnList	$derivedColumnList()	Experimental query object model accessor method, see also QOM.
@Nullable QOM.Materialized	$materialized()	Experimental query object model accessor method, see also QOM.
@NotNull ResultQuery<R>	$query()	Experimental query object model accessor method, see also QOM.

Methods inherited from interface org.jooq.Fields

dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types

Methods inherited from interface org.jooq.Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.Qualified

$schema, getCatalog, getSchema

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.RecordQualifier

getDataType, getPackage, getRecordType, newRecord

Methods inherited from interface org.jooq.Table

as, as, as, as, as, as, as, as, as, as, as, as, asterisk, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getType, getUniqueKeys, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, join, join, leftAntiJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftSemiJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, recordType, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, where, where, where, where, where, where, where, where, whereExists, whereNotExists

Methods inherited from interface org.jooq.TableLike

asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable

Method Detail

$derivedColumnList

@Experimental
@NotNull
@NotNull DerivedColumnList $derivedColumnList()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

$query

@Experimental
@NotNull
@NotNull ResultQuery<R> $query()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.

$materialized

@Experimental
@Nullable
@Nullable QOM.Materialized $materialized()

Experimental query object model accessor method, see also QOM. Subject to change in future jOOQ versions, use at your own risk.