org.jooq

Interface Name

All Superinterfaces:

QueryPart, Serializable

public interface Name
extends QueryPart

A SQL identifier QueryPart.

A Name is a QueryPart that renders a SQL identifier according to the settings specified in Settings.getRenderNameStyle().

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
<R extends Record> CommonTableExpression<R>	as(Select<R> select) Specify a subselect to refer to by the Name to form a common table expression.
WindowDefinition	as(WindowSpecification window) Create a WindowDefinition from this name.
DerivedColumnList	fields(String... fieldNames) Add a list of fields to this name to make this name a DerivedColumnList.
String[]	getName() The qualified name of this SQL identifier.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Method Detail

getName

String[] getName()

The qualified name of this SQL identifier.

as

@Support(value={CUBRID,DB2,HANA,INFORMIX,POSTGRES,ORACLE,SQLSERVER,SYBASE})
WindowDefinition as(WindowSpecification window)

Create a WindowDefinition from this name.

This creates a window definition that can be

• declared in the WINDOW clause (see SelectWindowStep.window(WindowDefinition...)
• referenced from the OVER clause (see WindowOverStep.over(WindowDefinition)

as

@Support(value={DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
<R extends Record> CommonTableExpression<R> as(Select<R> select)

Specify a subselect to refer to by the Name to form a common table expression.

Column names are implicitly inherited from the SELECT statement.

fields

@Support(value={DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLSERVER,SYBASE})
DerivedColumnList fields(String... fieldNames)

Add a list of fields to this name to make this name a DerivedColumnList.

The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.