Module org.jooq
Package org.jooq

Interface Asterisk

All Superinterfaces:
QueryPart, SelectFieldOrAsterisk, Serializable
public interface Asterisk extends SelectFieldOrAsterisk
An unqualified asterisk.

Asterisks (qualified and unqualified) are expressions that can be used exclusively in SELECT clauses and a few other clauses that explicitly allow for asterisks, including RETURNING on DML statements. Asterisks are syntax sugar in SQL, which are expanded to a column list by the parser once all the columns in the FROM clause are known.

Example: 

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

 using(configuration)
    .select(asterisk())
    .from(ACTOR)
    .fetch();

Instances can be created using DSL.asterisk().

Author:
Lukas Eder
See Also:
Table.asterisk()

  • Method Summary

    Modifier and Type
    Method
    Description
    @NotNull Asterisk
    except​(String... fieldNames)
    The asterisk (* EXCEPT (fields)) expression to be used in SELECT clauses.
    @NotNull Asterisk
    except​(Field<?>... fields)
    The asterisk (*) to be used in SELECT clauses.
    @NotNull Asterisk
    except​(Name... fieldNames)
    The asterisk (*) to be used in SELECT clauses.

    Methods inherited from interface org.jooq.QueryPart

    equals, hashCode, toString

  • Method Details

    • except

      @NotNull @Support @NotNull Asterisk except​(String... fieldNames)
      The asterisk (* EXCEPT (fields)) expression to be used in SELECT clauses.

      This expression is a convenient way to select "all but some fields". Some dialects (e.g. SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.

    • except

      @NotNull @Support @NotNull Asterisk except​(Name... fieldNames)
      The asterisk (*) to be used in SELECT clauses.

      This expression is a convenient way to select "all but some fields". Some dialects (e.g. SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.

    • except

      @NotNull @Support @NotNull Asterisk except​(Field<?>... fields)
      The asterisk (*) to be used in SELECT clauses.

      This expression is a convenient way to select "all but some fields". Some dialects (e.g. SQLDialect.H2) implement this feature natively. In other dialects, jOOQ expands the asterisk if possible.