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 Detail

      • 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.